topic Re: Simple question Can't change H2 parameters-exception in Alfresco Archive

Simple question Can't change H2 parameters-exception

vitalygoji — Wed, 06 May 2015 16:29:45 GMT

I am just starting with activitiThese are default database connectivity parameters found in /webapps/activiti-explorer/WEB-INF/classes/db.properties:db=h2jdbc.driver=org.h2.Driverjdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000jdbc.username=sajdbc.password=I want to change default memory database t

Re: Simple question Can't change H2 parameters-exception

jbarrez — Thu, 07 May 2015 13:22:03 GMT

Well, yes. You are pointing it to a standalone H2 server over tcp. You need to have that running.

Re: Simple question Can't change H2 parameters-exception

andymcc — Fri, 30 Oct 2015 13:28:26 GMT

I've just encountered exactly the same issue running Activiti 5.18 on Tomcat 8.0.28, accessing H2 1.4.190.jar running as a standalone server over tcp. (I'd set things up in accordance with https://forums.activiti.org/comment/17393#comment-17393 so was confident that it should work).

An initial solution for me was to revert to an earlier H2 release, specifically 1.3.175. That at least let me connect to the database, however, when I stop and restart Tomcat the error recurs.

I've raised a JIRA about the first part (the need to revert) but am still tryin to understand more about the second.

I'm also a newcomer to Activiti so, my apologies if the points I raise seem trivial.

Cheers

Andy McC

Re: Simple question Can't change H2 parameters-exception

vasile_dirla — Mon, 02 Nov 2015 10:54:44 GMT

this is caused by a incompatibility between the client and the server.
in activiti we use that dependency:
<code>
<dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <version>1.3.176</version>
      </dependency>
</code>

that means the connection with H2 version 1.3.176 is guaranteed.

if you would like to use H2 1.4.190 then you have to use the 1.4.190 library in the client side. (just tested with this version and is working)

Re: Simple question Can't change H2 parameters-exception

andymcc — Mon, 02 Nov 2015 16:43:53 GMT

Thanks for replying Vasile. I was working with a clean installation the latest Tomcat, h2 and Activiti *binaries*, so hadn't been aware of that dependency. I'll know to look at the source/pom in future before posting.
Thanks,
Andy McC