topic PersistenceException with Postgres in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87017#M58903 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I've set up a web app using Activiti Engine and Postgres. Initially I was using H2 db just for testing purpose and all was working fine, then I moved to Postgres. </SPAN><BR /><SPAN>In short, when I try to search for comments I get this error:</SPAN><BR /><BR /><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: &lt;|### Error querying database.&nbsp; Cause: org.postgresql.util.PSQLExcept</SPAN><BR /><SPAN>ion: ERROR: operator does not exist: character varying = bytea&lt;|### The error may involve org.activiti.engine.impl.persi</SPAN><BR /><SPAN>stence.entity.CommentEntity.selectCommentsByProcessInstanceId_postgres-Inline&lt;|### The error occurred while setting para</SPAN><BR /><SPAN>meters&lt;|### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:182)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.persistence.entity.CommentManager.findCommentsByProcessInstanceId(CommentManager.jav</SPAN><BR /><SPAN>a:59)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cmd.GetProcessInstanceCommentsCmd.execute(GetProcessInstanceCommentsCmd.java:38)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cmd.GetProcessInstanceCommentsCmd.execute(GetProcessInstanceCommentsCmd.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.TaskServiceImpl.getProcessInstanceComments(TaskServiceImpl.java:234)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ………………………</SPAN><BR /><BR /><SPAN>Caused by:</SPAN><BR /><SPAN>org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:470)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:369)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:362)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:243)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:117)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:79)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:182)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.persistence.entity.CommentManager.findCommentsByProcessInstanceId(CommentManager.jav</SPAN><BR /><SPAN>a:59)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cmd.GetProcessInstanceCommentsCmd.execute(GetProcessInstanceCommentsCmd.java:38)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.cmd.GetProcessInstanceCommentsCmd.execute(GetProcessInstanceCommentsCmd.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.TaskServiceImpl.getProcessInstanceComments(TaskServiceImpl.java:234)</SPAN><BR /><BR /><SPAN>I'v tried with 8.3-606.jdbc4 and PostgreS 8.3 and 9.1 but nothing changed.</SPAN><BR /><SPAN>Any clue?</SPAN><BR /><SPAN>M@rco</SPAN><BR /><BR /><SPAN>Here my conf:</SPAN><BR /><BR /><SPAN>database.url = jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432</SPAN><BR /><SPAN>database.driver = org.postgresql.Driver</SPAN><BR /><SPAN>database.username = postgres</SPAN><BR /><SPAN>database.password = postgres</SPAN><BR /><SPAN>database.showSql = true</SPAN><BR /><SPAN>database.generateDdl = false</SPAN><BR /><SPAN>database.target=POSTGRESQL</SPAN><BR /><BR /><SPAN>And in spring conf:</SPAN><BR /><BR /><SPAN>&lt;bean id="entityManagerFactory"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="persistenceUnitName" value="pu" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jpaVendorAdapter"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="database" value="${database.target}"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="showSql" value="${database.showSql}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="generateDdl" value="${database.generateDdl}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="dataSource"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClassName" value="${database.driver}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="${database.url}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="${database.username}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="${database.password}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN></BODY></HTML> Thu, 12 Jul 2012 09:00:04 GMT marfago 2012-07-12T09:00:04Z PersistenceException with Postgres https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87017#M58903 Hi,I've set up a web app using Activiti Engine and Postgres. Initially I was using H2 db just for testing purpose and all was working fine, then I moved to Postgres. In short, when I try to search for comments I get this error<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.apache.ibatis.exceptions.PersistenceException: &lt;|### Error queryin Thu, 12 Jul 2012 09:00:04 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87017#M58903 marfago 2012-07-12T09:00:04Z Re: PersistenceException with Postgres https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87018#M58904 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>There seems to be a bug in the select comments query.</SPAN><BR /><SPAN>I'll try to reproduce it on PostgreSQL and create a fix for this for the 5.10 release.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Thu, 12 Jul 2012 11:43:06 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87018#M58904 trademak 2012-07-12T11:43:06Z Re: PersistenceException with Postgres https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87019#M58905 <HTML><HEAD></HEAD><BODY><SPAN>Thanks.</SPAN><BR /><SPAN>Is there a jira for that?</SPAN><BR /><BR /><SPAN>M@rco</SPAN></BODY></HTML> Fri, 13 Jul 2012 05:46:26 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-with-postgres/m-p/87019#M58905 marfago 2012-07-13T05:46:26Z