topic Configure Activiti Explorer for the H2 Database in Alfresco Archive

Configure Activiti Explorer for the H2 Database

sachin_patil — Wed, 18 Feb 2015 10:47:57 GMT

A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:tcp://localhost/activiti". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-185] 90011/90011 (Help).Can any one help on this ?

Re: Configure Activiti Explorer for the H2 Database

jbarrez — Wed, 18 Feb 2015 16:50:27 GMT

Which version of H2? If you search the forum, you'll see people posting solutions to this question, where it seems that newer version of H2 require new jdbc url formats.

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Wed, 18 Feb 2015 18:25:10 GMT

H2 Version 1.4.185 (2015-01-16) (Platform-Independent Zip).Can you please provide me the solution ? I am trying it from past 1 day . I am not find any solution.

Re: Configure Activiti Explorer for the H2 Database

jbarrez — Sat, 28 Feb 2015 08:21:58 GMT

> .Can you please provide me the solution

Yes, the solution was to search the forum, as multiple people have reported this.

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Sat, 28 Feb 2015 08:36:04 GMT

I am not able to find the solution in the Activiti forum. Can you provide me the solution where I am doing wrong .Plz I am trying it from last One week , and not able to configure H2 database to activiti. Plz provide me the solution . It will be the helpfull .

Re: Configure Activiti Explorer for the H2 Database

jbarrez — Sat, 28 Feb 2015 10:13:57 GMT

One Google Query led me to http://www.h2database.com/html/tutorial.html where it states

"Database URL: jdbc:h2:tcp://localhost/~/test"

Not sure how you are searching …

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Sun, 01 Mar 2015 18:22:21 GMT

Thank you.

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Sun, 01 Mar 2015 18:50:24 GMT

Next question , How to reflect the table in the activiti in to H2 database ?
What are the change I need to do ?
I am using activiti-5.17.0 and H2 Version 1.4.185 (2015-01-16) (Platform-Independent Zip),The changes I made in the file are are as follows.
1) db.properties (Change's made in the activiti-explorer\WEB-INF\classes\db.properties as below )
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost/~/activiti
jdbc.username=sa
jdbc.password=

2) AS there no activiti-standalone-context.xml file , becoz I am activiti-5.17.0 which come with activiti-custom-context.xml. I need to make the changes in the activiti-explorer\WEB-INF\classes\activiti-custom-context.xml, becoz to configure the activiti to H2 standalone database . The changes are as follows.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="org.h2.Driver" />
    <property name="url" value="jdbc:h2:tcp://localhost/~/activiti" />
    <property name="username" value="sa" />
    <property name="password" value="" />
    <property name="defaultAutoCommit" value="false" />
</bean>

I did the changes in the both file , and created the war file and placed in the C:\apache-tomcat-7.0.59\webapps. when I started the tomcat server I am getting error . I have attached the tomcat server log error and screen shot of the activiti , I am running H2 database also mean while before running tomcat server. Could you please help on the issue ? Becoz I am not able to find the solution , I am working from past couple of weeks , But I am not able Configure Activiti Explorer for the H2 Database.Please Help on this issue

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Sun, 01 Mar 2015 19:08:55 GMT

2) AS there no activiti-standalone-context.xml file , becoz I am activiti-5.17.0 which come with activiti-custom-context.xml. I need to make the changes in the activiti-explorer\WEB-INF\classes\activiti-custom-context.xml, becoz to configure the activiti to H2 standalone database . The changes are as follows.
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="org.h2.Driver" />
    <property name="url" value="jdbc:h2:tcp://localhost/~/activiti" />
    <property name="username" value="sa" />
    <property name="password" value="" />
    <property name="defaultAutoCommit" value="false" />
</bean>

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Sun, 01 Mar 2015 19:09:18 GMT

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Sun, 01 Mar 2015 19:11:31 GMT

Re: Configure Activiti Explorer for the H2 Database

jbarrez — Mon, 02 Mar 2015 10:25:57 GMT

No you don't. There is a db.properties file to do that. Configuring H2 with Activiti is really simple.

Googling your error … gives me this: http://stackoverflow.com/questions/12346707/java-util-zip-zipexception-invalid-cen-header-bad-signature

So you must have done something wrong with zipping the war file ….

Re: Configure Activiti Explorer for the H2 Database

sachin_patil — Mon, 02 Mar 2015 12:45:38 GMT

Can you tell me the steps to Configuring H2 with Activiti ? It would be really helpful .

Re: Configure Activiti Explorer for the H2 Database

jbarrez — Tue, 03 Mar 2015 17:15:50 GMT

I could, but it's trivial to do it shouldn't require steps.
So have you looked at the zip exception? Why are you rezipping the war (badly)? First try to get exploded deployment working before making it a .war again.