Error while creating file null.lobs.db [90062-101]
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2015 05:35 AM
I'm trying to deploy my workflow in Tomcat using H2 in-mem DB and getting the error below:
Same workflow working fine if I use the UnitTest.
Thanks.
DEV 10:27:45.258 [localhost-startStop-1] INFO o.a.e.i.bpmn.deployer.BpmnDeployer - Processing resource com/my/diagram/MyLeaveProcess.bpmnDEV 10:27:49.554 [localhost-startStop-1] ERROR o.a.e.i.interceptor.CommandContext - Error while closing command contextorg.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.
Labels:
- Labels:
-
Archive
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2015 07:55 PM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2015 05:31 PM
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.
By the way I'm using version: 5.12.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2015 04:25 PM
