Table already exists [RESOLVED]

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

experimental

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.

frederikherema1

Try running 'ant db.drop' to clear the tables and run the demo.setup again, this should do the trick.

To make sure H2 is stopped, you can run 'ant demo.teardown'