topic Re: Activiti corrupted DB on Windows in Alfresco Archive

Activiti corrupted DB on Windows

benreich — Fri, 15 Apr 2016 18:52:36 GMT

Hello,I have a strange problem. I initialize a new standalone H2 DB on windows and then log in to activiti explorer. If I stop tomcat and restart it all is OK. But if I boot windows and then try to go into activiti explorer I get the attached log. Only killing the DB and starting from scratch gets m

Re: Activiti corrupted DB on Windows

jbarrez — Wed, 20 Apr 2016 13:56:04 GMT

What's the jdbc url your using? How are you running H2?

Re: Activiti corrupted DB on Windows

benreich — Wed, 20 Apr 2016 14:43:31 GMT

My H2 Database is standalone and I access it in the following way

<blockcode>
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost//users/benr/workspace/activitidb/activiti;DB_CLOSE_DELAY=1000
jdbc.username=sa
jdbc.password=
</blockcode>

Thanks,

Ben

Re: Activiti corrupted DB on Windows

martin_grofcik — Thu, 21 Apr 2016 06:33:36 GMT

Hi Ben,

Is you DB started after win restart?

Regards
Martin

Re: Activiti corrupted DB on Windows

benreich — Sun, 24 Apr 2016 13:00:44 GMT

Hello and thanks for your help. Any idea on how I can start h2 at windows startup? I cannot find any way of doing that apart from openning the console by manually

Re: Activiti corrupted DB on Windows

martin_grofcik — Mon, 25 Apr 2016 11:16:35 GMT

Hi Ben,

search on H2 forum. I really do not know.

Regards
Martin