topic Re: H2 standalone database difficulties in Alfresco Archive

H2 standalone database difficulties

waao — Thu, 05 Sep 2013 14:51:04 GMT

Hi guys,I'm a newbie about Activiti and BPMN things but i want to learn. I began 4 days ago, step by step I'd been able to work a little bit with Activiti in java code. Then i manage to integrate Activiti to Spring in a web app.Now I want to set up my web app and the Activiti Explorer on the same DB

Re: H2 standalone database difficulties

jbarrez — Thu, 12 Sep 2013 11:42:50 GMT

Running H2 standalone is normally just executing 'java -jar h2.jar'

However, if you go through that trouble, it might be better to install something like MySQL and have a 'real database' from the start

Re: H2 standalone database difficulties

ambharath — Tue, 24 Sep 2013 07:22:12 GMT

Hi Waao,

Considering the date of your post, by now, I'm more than sure you must have solved the problem yourself but just to check if you followed my approach, here's how I went about it:

1) I downloaded the activiti-explorer war file (version 5.13)
2) Modified the content of the war file's WEB-INF\activiti-standalone-context.xml & WEB-INF\classes\db.properties so as to point to my H2 database URL
3) Deployed the file to Tomcat and on start-up of the server, the explorer fired up all proper and was pointing to my standalone H2 database.

Inside the activiti-standalone-context.xml, this was the XML snippet that I updated:
<code>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="org.h2.Driver"/>
    <property name="url" value="MY_H2_URL" />
    <property name="username" value="MY_H2_USER_NAME" />
    <property name="password" value="MY_H2_PASSWORD" />
    <property name="defaultAutoCommit" value="false" />
</bean>
</code>
The content inside db.properties was pretty straightforward to tinker with.

-
A M Bharath

Re: H2 standalone database difficulties

waao — Mon, 30 Sep 2013 08:33:57 GMT

Hi !

Thanks for your answers. I couldn't work on my problem until today, so i post this answer to thank you for your advices.

As jbarrez said, i've tried to directly connect the Activiti Explorer to a MySQL DB and it's succesfull !
I simply modified the db.properties file with my DB paramters, add mysql jdbc jar file in tomcat's lib' and done ! It's work !

Re: H2 standalone database difficulties

ambharath — Thu, 03 Oct 2013 10:04:23 GMT

Hello Waao,

That's great! Keep going and keep posting!

-
A M Bharath