AnsweredAssumed Answered

Table already exists [RESOLVED]

Question asked by experimental on Nov 22, 2010
Latest reply on Nov 22, 2010 by frederikheremans1
I am trying to get Activiti installed. After following the advice in this post, by deleting the runtime and test library folders, it actually downloads everything.

I receive a SQL exception that the tables already exist:

db.create.engine:
      [sql] Executing resource: org/activiti/db/create/activiti.h2.create.sql
      [sql] Failed to execute:  create table ACT_GE_PROPERTY ( NAME_ varchar(64)
, VALUE_ varchar(300), REV_ integer, primary key (NAME_) )

BUILD FAILED
C:\activiti-5.0.rc1\setup\build.xml:180: org.h2.jdbc.JdbcSQLException: Table "AC
T_GE_PROPERTY" already exists; SQL statement:
create table ACT_GE_PROPERTY ( NAME_ varchar(64), VALUE_ varchar(300), REV_ int
eger, primary key (NAME_) ) [42101-124]

I am guessing this is due to a failed installation previously. How can I clear out the h2 database?

I've also noticed that a java persists after the build script fails. I know this is h2 because if I restart the build script it says port in use and it cannot bind. (The port used for h2)

I think the demo script and toolchain is quite complicated for what you are trying to accomplish and seems to be prone to falling over if the environment has a proxy or if the installation fails.

Outcomes