topic DB Error when creating process engine in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/db-error-when-creating-process-engine/m-p/164868#M118586 <HTML><HEAD></HEAD><BODY><SPAN>Hello, </SPAN><BR /><BR /><SPAN>I'm using activiti 5.14 with PostgreSQL DB and create a process engine as follows: </SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />ProcessEngine processEngine = ProcessEngineConfiguration<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.createProcessEngineConfigurationFromResourceDefault()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.buildProcessEngine();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>My activiti.cfg.xml:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;beans xmlns="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:context="<A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A>" xmlns:tx="<A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>"<BR />&nbsp;&nbsp;&nbsp;xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A> <BR />&nbsp;&nbsp;&nbsp;<A href="http://www.springframework.org/schema/beans/spring-beans.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans.xsd</A> <BR />&nbsp;&nbsp;&nbsp;<A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A> <BR />&nbsp;&nbsp;&nbsp;<A href="http://www.springframework.org/schema/context/spring-context-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context/spring-context-3.0.xsd</A>"&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClass" value="org.postgresql.Driver" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="jdbc:postgresql://localhost:5432/mydb" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="dummy" /&gt;<BR /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="dummy" /&gt; <BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseType" value="postgres" /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="history" value="full" /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR />&lt;/beans&gt;<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><BR /><SPAN>However, I get following error:</SPAN><BR /><SPAN> </SPAN><PRE class="language-none line-numbers"><CODE><BR />Caused by: org.apache.ibatis.exceptions.PersistenceException: <BR />### Error querying database.&nbsp; Cause: Diese Methode ist noch nicht implementiert.<BR />### The error may exist in org/activiti/db/mapping/entity/Property.xml<BR />### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline<BR />### The error occurred while setting parameters<BR />### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?<BR />### Cause: Diese Methode ist noch nicht implementiert.<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:308)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:710)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; …<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:363)<BR />&nbsp;&nbsp;&nbsp;at com.example.activiti.processes.MainClass.main(MainClass.java:20)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>If databaseSchemaUpdate is set to false, similar error appears on deployment: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error querying database.&nbsp; Cause: Diese Methode ist noch nicht implementiert.<BR />### The error may exist in org/activiti/db/mapping/entity/Property.xml<BR />### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline<BR />### The error occurred while setting parameters<BR />### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?<BR />### Cause: Diese Methode ist noch nicht implementiert.<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:308)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; …<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.DeploymentEntityManager.insertDeployment(DeploymentEntityManager.java:39)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; …<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:139)<BR />&nbsp;&nbsp;&nbsp;at com.example.activiti.processes.MainClass.main(MainClass.java:52)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Am I doing anything wrong ? Is there any workaround for this? </SPAN><BR /><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Mon, 25 Nov 2013 07:50:04 GMT lison4ik 2013-11-25T07:50:04Z DB Error when creating process engine https://connect.hyland.com/t5/alfresco-archive/db-error-when-creating-process-engine/m-p/164868#M118586 Hello, I'm using activiti 5.14 with PostgreSQL DB and create a process engine as follows: ProcessEngine processEngine = ProcessEngineConfiguration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.createProcessEngineConfigurationFromResourceDefault()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.buildProcessEngine();‍‍‍‍‍My activiti.cfg.xml:&lt;?xml version="1.0" encodi Mon, 25 Nov 2013 07:50:04 GMT https://connect.hyland.com/t5/alfresco-archive/db-error-when-creating-process-engine/m-p/164868#M118586 lison4ik 2013-11-25T07:50:04Z Re: DB Error when creating process engine https://connect.hyland.com/t5/alfresco-archive/db-error-when-creating-process-engine/m-p/164869#M118587 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Can you post the full stacktrace when you run with databaseSchemaUpdate is true?</SPAN><BR /><SPAN>Are there any tables in your Postgres databse?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Tue, 26 Nov 2013 08:37:07 GMT https://connect.hyland.com/t5/alfresco-archive/db-error-when-creating-process-engine/m-p/164869#M118587 trademak 2013-11-26T08:37:07Z