topic Re: Persistent H2 Database (activiti-5.10) in Alfresco Archive

Persistent H2 Database (activiti-5.10)

nommyravian — Thu, 04 Oct 2012 08:41:20 GMT

Hi,I've deployed activiti-5.10 to my windows machine using demo setup instructions. Every time I start the engine, it comes up with new database and I lose added users and deployed process. How to make H2 database persistent?Thank you.

Re: Persistent H2 Database (activiti-5.10)

frederikherema1 — Thu, 04 Oct 2012 08:48:27 GMT

As you say, it's a demo setup. If you want to use your own database, check out the user guide for more info. Also, for running H2 on your machine, consult their documentation, it's really easy to get a h2 up and running.

Re: Persistent H2 Database (activiti-5.10)

nommyravian — Thu, 04 Oct 2012 08:57:07 GMT

Thanks for the reply.
I had been using the demo setup of activiti-5.9 for last few days and it has persistent in memory database. Now I deployed activiti-5.10 and it's dropping and recreating database every time I start the server. Why activiti-5.9 demo setup wasn't doing this? I tried searching for jdbc property in activiti.cfg.xml and in persistence.xml for activiti 5-10 but couldn't fix it.

best regards,

Re: Persistent H2 Database (activiti-5.10)

jbarrez — Fri, 05 Oct 2012 06:37:19 GMT

Are you running 'ant demo.setup' over and over again? Afaik, this wont drop/create the schema … (but I can be wrong).
What happens if you start the Tomcat server and the H2 database yourself. There are ant targets for that, run 'ant -p' from the setup folder to see them.

Re: Persistent H2 Database (activiti-5.10)

nommyravian — Fri, 05 Oct 2012 09:20:55 GMT

Hi,
I was simply using ant demo.start but now I found the issue.

There is db.properties file in the path {activiti-5.10 Home}\apps\apache-tomcat-6.0.32\webapps\activiti-explorer\WEB-INF\classes. The default contents are;

db=h2
jdbc.driver=org.h2.Driver
#jdbc.url=jdbc:h2:tcp://localhost/activiti
jdbc.url=jdbc:h2:mem:activiti
jdbc.username=sa
jdbc.password=

I commented the 4th line and used the 3rd line of jdbc.url and it worked. Now schema is not dropped and re created every time. My db.properties file is now;

db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost/activiti
#jdbc.url=jdbc:h2:mem:activiti
jdbc.username=sa
jdbc.password=

Note: This file is updated in activiti 5-10 (I confirmed it with activiti 5-9). I don't know if activiti 5-10 developers have changed it intentionally or left the "jdbc.url=jdbc:h2:tcp://localhost/activiti" line commented mistakenly but changing this configuration solved my issue. Now I've persistent h2 db like I had in activiti 5.9

Re: Persistent H2 Database (activiti-5.10)

jbarrez — Thu, 11 Oct 2012 12:52:11 GMT

I do think it's an error by someone 'testing something out'.

I changed it back to the persistent db: https://github.com/Activiti/Activiti/commit/7df7452d8b4f81389a047b7c6d16679bc58f9da0