cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating file null.lobs.db [90062-101]

jss
Champ in-the-making
Champ in-the-making
I'm trying to deploy my workflow in Tomcat using H2 in-mem DB and getting the error below:

DEV 10:27:45.258 [localhost-startStop-1] INFO  o.a.e.i.bpmn.deployer.BpmnDeployer - Processing resource com/my/diagram/MyLeaveProcess.bpmn
DEV 10:27:49.554 [localhost-startStop-1] ERROR o.a.e.i.interceptor.CommandContext - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: org.h2.jdbc.JdbcSQLException: Error while creating file null.lobs.db [90062-101]
### The error may involve org.activiti.engine.impl.persistence.entity.ResourceEntity.insertResource-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_)     values (?, 1, ?, ?, ?, ?)
### Cause: org.h2.jdbc.JdbcSQLException: Error while creating file null.lobs.db [90062-101]
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.1.1.jar:3.1.1]


Same workflow working fine if I use the UnitTest.

Thanks.
3 REPLIES 3

balsarori
Champ on-the-rise
Champ on-the-rise
Seems to be H2 specific issue
http://www.h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90062

"Error while creating file", are you sure you are running H2 in memory? Your URL should look something like
jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000

jss
Champ in-the-making
Champ in-the-making
Bassam, Yes I am using H2 in memory mode only and I have double checked my configuration.
By the way I'm using version: 5.12.