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,