Activiti
  1. Activiti
  2. ACT-1147

Posting a comment to a task causes an exception (Bad value for type long) (After updating from 5.8 to 5.9)

    Details

    • Type: Bug Bug
    • Status: Resolved Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 5.9
    • Fix Version/s: 5.11
    • Component/s: Explorer
    • Labels:
    • Environment:
      Debian VM, Tomcat 7, PostgreSQL 8.4
    • Number of attachments :
      3

      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!

      1. 20120314_long_task_comment.txt
        7 kB
        Chris Samulski
      2. ACT-1147.patch
        2 kB
        Jerome Cavezian
      3. ACT-1147-5.10.patch
        2 kB
        Jerome Cavezian

        Activity

          People

          • Assignee:
            Joram Barrez
            Reporter:
            Chris Samulski
          • Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: