nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Problem connecting to H2 database

koteswarrao

hi all

i am trying to connect to h2 database from my acitiviti application program without using apache or any other(simply to say, as a standalone system). i implemented one sample application which deployes "start——>user task——->end". when i tried to deploy this workflow i am getting following error. can anybody please clarify on this. persistence is my main concern(for my project).

org.activiti.engine.ActivitiException: no activiti tables in db. set <property name="databaseSchemaUpdate" to value="true" or value="create-drop" (use create-drop for testing only!) in bean processEngineConfiguration in activiti.cfg.xml for automatic schema creation
   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:487)
   at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:851)
   at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:233)
   at com.sample.activiti.MainClass.main(MainClass.java:52)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_GE_PROPERTY" not found; SQL statement:
select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [42102-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.Parser.readTableOrView(Parser.java:4347)
   at org.h2.command.Parser.readTableFilter(Parser.java:1001)
   at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1529)
   at org.h2.command.Parser.parseSelectSimple(Parser.java:1626)
   at org.h2.command.Parser.parseSelectSub(Parser.java:1523)
   at org.h2.command.Parser.parseSelectUnion(Parser.java:1368)
   at org.h2.command.Parser.parseSelect(Parser.java:1356)
   at org.h2.command.Parser.parsePrepared(Parser.java:395)
   at org.h2.command.Parser.parse(Parser.java:278)
   at org.h2.command.Parser.parse(Parser.java:250)
   at org.h2.command.Parser.prepareCommand(Parser.java:222)
   at org.h2.engine.Session.prepareLocal(Session.java:420)
   at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
   at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
   at java.lang.Thread.run(Unknown Source)

### The error may exist in org/activiti/db/ibatis/engine.mapping.xml
### The error may involve org.activiti.persistence.selectDbSchemaVersion
### The error occurred while executing a query
### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'
### Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_GE_PROPERTY" not found; SQL statement:
select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [42102-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.Parser.readTableOrView(Parser.java:4347)
   at org.h2.command.Parser.readTableFilter(Parser.java:1001)
   at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1529)
   at org.h2.command.Parser.parseSelectSimple(Parser.java:1626)
   at org.h2.command.Parser.parseSelectSub(Parser.java:1523)
   at org.h2.command.Parser.parseSelectUnion(Parser.java:1368)
   at org.h2.command.Parser.parseSelect(Parser.java:1356)
   at org.h2.command.Parser.parsePrepared(Parser.java:395)
   at org.h2.command.Parser.parse(Parser.java:278)
   at org.h2.command.Parser.parse(Parser.java:250)
   at org.h2.command.Parser.prepareCommand(Parser.java:222)
   at org.h2.engine.Session.prepareLocal(Session.java:420)
   at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
   at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
   at java.lang.Thread.run(Unknown Source)

   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:33)
   at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:509)
   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:445)
   … 8 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "ACT_GE_PROPERTY" not found; SQL statement:
select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [42102-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.Parser.readTableOrView(Parser.java:4347)
   at org.h2.command.Parser.readTableFilter(Parser.java:1001)
   at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1529)
   at org.h2.command.Parser.parseSelectSimple(Parser.java:1626)
   at org.h2.command.Parser.parseSelectSub(Parser.java:1523)
   at org.h2.command.Parser.parseSelectUnion(Parser.java:1368)
   at org.h2.command.Parser.parseSelect(Parser.java:1356)
   at org.h2.command.Parser.parsePrepared(Parser.java:395)
   at org.h2.command.Parser.parse(Parser.java:278)
   at org.h2.command.Parser.parse(Parser.java:250)
   at org.h2.command.Parser.prepareCommand(Parser.java:222)
   at org.h2.engine.Session.prepareLocal(Session.java:420)
   at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
   at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
   at java.lang.Thread.run(Unknown Source)

   at org.h2.engine.SessionRemote.done(SessionRemote.java:505)
   at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)
   at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)
   at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)
   at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)
   at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
   at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:225)
   at $Proxy0.prepareStatement(Unknown Source)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:50)
   at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:64)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:39)
   at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:55)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
   … 13 more
org.activiti.engine.ActivitiException: no activiti tables in db. set <property name="databaseSchemaUpdate" to value="true" or value="create-drop" (use create-drop for testing only!) in bean processEngineConfiguration in activiti.cfg.xml for automatic schema creation
   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:487)
   at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:851)
   at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:233)
   at com.sample.activiti.MainClass.main(MainClass.java:52)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_GE_PROPERTY" not found; SQL statement:
select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [42102-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.Parser.readTableOrView(Parser.java:4347)
   at org.h2.command.Parser.readTableFilter(Parser.java:1001)
   at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1529)
   at org.h2.command.Parser.parseSelectSimple(Parser.java:1626)
   at org.h2.command.Parser.parseSelectSub(Parser.java:1523)
   at org.h2.command.Parser.parseSelectUnion(Parser.java:1368)
   at org.h2.command.Parser.parseSelect(Parser.java:1356)
   at org.h2.command.Parser.parsePrepared(Parser.java:395)
   at org.h2.command.Parser.parse(Parser.java:278)
   at org.h2.command.Parser.parse(Parser.java:250)
   at org.h2.command.Parser.prepareCommand(Parser.java:222)
   at org.h2.engine.Session.prepareLocal(Session.java:420)
   at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
   at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
   at java.lang.Thread.run(Unknown Source)

### The error may exist in org/activiti/db/ibatis/engine.mapping.xml
### The error may involve org.activiti.persistence.selectDbSchemaVersion
### The error occurred while executing a query
### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'
### Cause: org.h2.jdbc.JdbcSQLException: Table "ACT_GE_PROPERTY" not found; SQL statement:
select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [42102-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.Parser.readTableOrView(Parser.java:4347)
   at org.h2.command.Parser.readTableFilter(Parser.java:1001)
   at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1529)
   at org.h2.command.Parser.parseSelectSimple(Parser.java:1626)
   at org.h2.command.Parser.parseSelectSub(Parser.java:1523)
   at org.h2.command.Parser.parseSelectUnion(Parser.java:1368)
   at org.h2.command.Parser.parseSelect(Parser.java:1356)
   at org.h2.command.Parser.parsePrepared(Parser.java:395)
   at org.h2.command.Parser.parse(Parser.java:278)
   at org.h2.command.Parser.parse(Parser.java:250)
   at org.h2.command.Parser.prepareCommand(Parser.java:222)
   at org.h2.engine.Session.prepareLocal(Session.java:420)
   at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
   at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
   at java.lang.Thread.run(Unknown Source)

   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:33)
   at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:509)
   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:445)
   … 8 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "ACT_GE_PROPERTY" not found; SQL statement:
select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version' [42102-132]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.Parser.readTableOrView(Parser.java:4347)
   at org.h2.command.Parser.readTableFilter(Parser.java:1001)
   at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1529)
   at org.h2.command.Parser.parseSelectSimple(Parser.java:1626)
   at org.h2.command.Parser.parseSelectSub(Parser.java:1523)
   at org.h2.command.Parser.parseSelectUnion(Parser.java:1368)
   at org.h2.command.Parser.parseSelect(Parser.java:1356)
   at org.h2.command.Parser.parsePrepared(Parser.java:395)
   at org.h2.command.Parser.parse(Parser.java:278)
   at org.h2.command.Parser.parse(Parser.java:250)
   at org.h2.command.Parser.prepareCommand(Parser.java:222)
   at org.h2.engine.Session.prepareLocal(Session.java:420)
   at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
   at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
   at java.lang.Thread.run(Unknown Source)

   at org.h2.engine.SessionRemote.done(SessionRemote.java:505)
   at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)
   at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)
   at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)
   at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)
   at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
   at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:225)
   at $Proxy0.prepareStatement(Unknown Source)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:50)
   at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:64)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:39)
   at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:55)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
   … 13 more

Find more posts tagged with

Comments

frederikherema1

What's the value of the property in your activiti config?
<br><property name="databaseSchemaUpdate"<br>

koteswarrao

thankyou for the prompt reply.

the value of <property name="databaseSchemaUpdate" is set to "true"
why i am getting that error i dont know and moreover, when i create a new activiti project in my eclipse its not creating activiti.cfg.xml file..dont know why?

frederikherema1

How do you build your process-engine (code in at com.sample.activiti.MainClass.main(MainClass.java:52)) ?

koteswarrao

while creating "activiti" project, i didnt get "activiti.cfg.xml" file in my "src/test/resources". so i manually created one xml file and copied the required properties to it. some times i am getting abover error and if i point out to the "activiti.cfg.xml" file while building processengine its giving error like "there is no "activiti.cfg.xml file found in the classpath".

now i am trying to build processEngine using API as follows

ProcessEngine cachedprocessEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration()
    .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE)
    .setJdbcUrl("jdbc:h2:mem:my-own-db;DB_CLOSE_DELAY=1000")
    .setJobExecutorActivate(true)
    .buildProcessEngine();

frederikherema1

What version of activiti are you running? Setting the databaseSchemaUpdate should do the trick…

koteswarrao

activiti version : 5.3

i dont have "H2" database installed in my system but i am trying to access it
i just started the "h2.start.bat" file which was provided in "activiti installation folder"

koteswarrao

Hi frederikheremans
this is the total summary of my approach

first i downloaded activiti designer plugins using "eclipse s/w updates" then i created Activiti project and included all the actviti jars through "eclipse build path". after creation of project these are the folders which i found in my package explorer
i attached the file with name "package_explorer". there is nothing inside "src/test/resources".

then i tried programing for the workflow using following snippet

package org.activiti;

import org.activiti.engine.ProcessEngine;
import org.activiti.engine.ProcessEngineConfiguration;

public class SampleTask
{
private static ProcessEngine processEngine;
public static void main(String[] args)
{

if(processEngine==null)
{
ProcessEngine processEngine=ProcessEngineConfiguration.createStandaloneProcessEngineConfigurationFromResource("activiti.cfg.xml").buildProcessEngine();
}

System.out.println("processengine"+processEngine.getName());
}

}

then i am getting following error "actviti.cfg.xml" file not found
if i dont specify the file name and tried building with "createdefaultprocessengine" then i am getting above first said error, which is "database tables are not found"

note: i am not using anything other than these. namely no server, no database installation and all.