AnsweredAssumed Answered

Struggling with standalone H2 database

Question asked by praveenr on Feb 19, 2016
Latest reply on Feb 23, 2016 by shivam_0311
I am trying to get the standalone H2 working with Activiti engine, but I keep getting the below error when executing a BPMN example from Eclipse:

SEVERE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error opening session.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]
### The error may exist in org/activiti/db/mapping/entity/EventSubscription.xml
### The error occurred while processing mapper_resultMap[compensateResultMap]
### Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-132]

The Activiti Explorer is working and modified the "db.properties" as:
db=h2
jdbc.driver=org.h2.Driver
#jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000
jdbc.url=jdbc:h2:tcp://localhost/~/activiti
jdbc.username=sa
jdbc.password=

Instead of the localhost, I tried IP address too, but the result is same. Any guidance would be greatly appreciated.

Thanks

Outcomes