Configure Activiti Explorer for the H2 Database

[sachin_patil]

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 ?

[jbarrez]

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.

[sachin_patil]

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.

[jbarrez]

> .Can you please provide me the solution

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

[sachin_patil]

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 .

[jbarrez]

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 …

[sachin_patil]

Thank you.

[sachin_patil]

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

[sachin_patil]

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>

[sachin_patil]

<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>