DB Error when creating process engine

[lison4ik]

Hello,

I'm using activiti 5.14 with PostgreSQL DB and create a process engine as follows:

ProcessEngine processEngine = ProcessEngineConfiguration            .createProcessEngineConfigurationFromResourceDefault()            .buildProcessEngine();‍‍‍‍‍

My activiti.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"   xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xsi:schemaLocation="http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-3.0.xsd">   <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">      <property name="driverClass" value="org.postgresql.Driver" />      <property name="url" value="jdbc:postgresql://localhost:5432/mydb" />      <property name="username" value="dummy" />       <property name="password" value="dummy" />    </bean>   <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">            <property name="databaseType" value="postgres" />            <property name="dataSource" ref="dataSource" />                            <property name="databaseSchemaUpdate" value="true" />                <property name="history" value="full" />                       <property name="jobExecutorActivate" value="false" />             </bean></beans>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

However, I get following error:

Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database.  Cause: Diese Methode ist noch nicht implementiert.### The error may exist in org/activiti/db/mapping/entity/Property.xml### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline### The error occurred while setting parameters### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?### Cause: Diese Methode ist noch nicht implementiert.   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)   at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:308)   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:710)        …   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:363)   at com.example.activiti.processes.MainClass.main(MainClass.java:20)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If databaseSchemaUpdate is set to false, similar error appears on deployment:

### Error querying database.  Cause: Diese Methode ist noch nicht implementiert.### The error may exist in org/activiti/db/mapping/entity/Property.xml### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline### The error occurred while setting parameters### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?### Cause: Diese Methode ist noch nicht implementiert.   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)   at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:308)        …   at org.activiti.engine.impl.persistence.entity.DeploymentEntityManager.insertDeployment(DeploymentEntityManager.java:39)        …   at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:75)   at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:139)   at com.example.activiti.processes.MainClass.main(MainClass.java:52)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Am I doing anything wrong ? Is there any workaround for this?

Thanks in advance.

[trademak]

Hi,

Can you post the full stacktrace when you run with databaseSchemaUpdate is true?
Are there any tables in your Postgres databse?

Best regards,