Details
Bug
Resolved
Major
Description
After upgrading Activiti 5.8 to 5.9 you get an exception when trying to post a comment (in the top right corner) for any task.
This only seems to happen when using a PostgreSQL database. When using H2 this will not happen. I tried both, vanilla.
The Exception (After trying to comment "Hello World"):
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.postgresql.util.PSQLException: Bad value for type long : \x48656c6c6f20 ### The error may involve org.activiti.engine.impl.persistence.entity.CommentEntity.selectEventsByTaskId-Inline ### The error occurred while setting parameters ### Cause: org.postgresql.util.PSQLException: Bad value for type long : \x48656c6c6f20576f726c64. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:81) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73) at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:182) at org.activiti.engine.impl.persistence.entity.CommentManager.findEventsByTaskId
Check the attachment for a full stacktrace!
my small contribution to help things go forward.
this solve the problem.
see
ACT-1147.patch