AnsweredAssumed Answered

Problems connection H2

Question asked by berkaybuharali on May 13, 2014
Latest reply on Feb 20, 2015 by sachin.patil@fmr.com
Hi,

I try to use H2 database. First I changed db.properties in activiti-explorer Web-Inf folder like,

db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost/activiti;DB_CLOSE_DELAY=1000
jdbc.username=sa
jdbc.password=

Afterwards I restart tomcat and I received error,

ERROR org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl  - Exception while initializing Database connection
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:tcp://localhost/activiti;DB_CLOSE_DELAY=1000". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-170])
   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

And I try to connect H2 console using this link,

jdbc:h2:tcp://localhost/activiti

and it gives me
A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:tcp://localhost/activiti". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-177] 90011/90011 (Help).

I already add baseDir inside h2.sh

What should I do ? Thanks

Outcomes