AnsweredAssumed Answered

DB Error when creating process engine

Question asked by lison4ik on Nov 25, 2013
Latest reply on Nov 26, 2013 by trademak
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.

Outcomes