AnsweredAssumed Answered

Getting exception while retreving comments

Question asked by sai576 on Aug 27, 2013
Latest reply on Sep 12, 2013 by trademak
Hi,

   I am getting exception while executing this rest uri  GET runtime/tasks/{taskId}/comments/{commentId}.The exception is
Cause: org.postgresql.util.PSQLException: Bad value for type long .I am using activiti 5.13, postgresql-9.1-902.jdbc4.jar.In google tried about this one in some users given suggestions shift to 9.1-902.jdbc4.jar before i am using postgresql-9.1dev-900.jdbc3.jar but still i am
facing this problem.



11:22:39,834 INFO  [org.restlet.Component.LogService] (http-127.0.0.1-127.0.0.1-8180-1) 2013-08-27   11:22:39   127.0.0.1   kermit   127.0.0.1   8180   GET   /activiti-rest/service/runtime/tasks/139215/events/140002   -   500   -   0   198   http://localhost:8180   Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0   -
11:22:57,089 WARNING [org.restlet.Component.ActivitiRestServicesApplication] (http-127.0.0.1-127.0.0.1-8180-1) Exception or error caught in resource: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.postgresql.util.PSQLException: Bad value for type long : \x5468697320697320207570646174656420636f6d6d656e74206f6e20746865207461736b2066726f6d207468652061646d696e20616761696e2e
### The error may exist in org/activiti/db/mapping/entity/Comment.xml
### The error may involve org.activiti.engine.impl.persistence.entity.CommentEntity.selectComment-Inline
### The error occurred while setting parameters
### SQL: select *      from ACT_HI_COMMENT      where ID_ = ?
### Cause: org.postgresql.util.PSQLException: Bad value for type long : \x5468697320697320207570646174656420636f6d6d656e74206f6e20746865207461736b2066726f6d207468652061646d696e20616761696e2e
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62) [mybatis-3.2.2.jar:3.2.2]
   at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:306) [activiti-engine-5.13.jar:5.13]
   at org.activiti.engine.impl.persistence.entity.CommentEntityManager.findComment(CommentEntityManager.java:64) [activiti-engine-5.13.jar:5.13]
   at org.activiti.engine.impl.cmd.GetCommentCmd.execute(GetCommentCmd.java:41) [activiti-engine-5.13.jar:5.13]
   at org.activiti.engine.impl.cmd.GetCommentCmd.execute(GetCommentCmd.java:27) [activiti-engine-5.13.jar:5.13]
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) [activiti-engine-5.13.jar:5.13]
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:61) [activiti-engine-5.13.jar:5.13]
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42) [activiti-spring-5.13.jar:]
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40) [activiti-spring-5.13.jar:]
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) [activiti-engine-5.13.jar:5.13]
   at org.activiti.engine.impl.TaskServiceImpl.getComment(TaskServiceImpl.java:282) [activiti-engine-5.13.jar:5.13]
   at org.activiti.rest.api.runtime.task.TaskCommentResource.getComment(TaskCommentResource.java:45) [activiti-rest-5.13.jar:]
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_25]
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_25]
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_25]
   at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_25]
   at org.restlet.resource.ServerResource.doHandle(ServerResource.java:452) [org.restlet-2.0.15.jar:]
   at org.restlet.resource.ServerResource.get(ServerResource.java:648) [org.restlet-2.0.15.jar:]
   at org.restlet.resource.ServerResource.doHandle(ServerResource.java:530) [org.restlet-2.0.15.jar:]
   at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:590) [org.restlet-2.0.15.jar:]
   at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:302) [org.restlet-2.0.15.jar:]
   at org.restlet.resource.ServerResource.handle(ServerResource.java:849) [org.restlet-2.0.15.jar:]
   at org.restlet.resource.Finder.handle(Finder.java:513) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Router.doHandle(Router.java:500) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Router.handle(Router.java:740) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:155) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.engine.ChainHelper.handle(ChainHelper.java:114) [org.restlet-2.0.15.jar:]
   at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:75) [org.restlet-2.0.15.jar:]
   at org.restlet.Application.handle(Application.java:391) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Router.doHandle(Router.java:500) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Router.handle(Router.java:740) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Router.doHandle(Router.java:500) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Router.handle(Router.java:740) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.doHandle(Filter.java:159) [org.restlet-2.0.15.jar:]
   at org.restlet.routing.Filter.handle(Filter.java:206) [org.restlet-2.0.15.jar:]
   at org.restlet.engine.ChainHelper.handle(ChainHelper.java:114) [org.restlet-2.0.15.jar:]
   at org.restlet.Component.handle(Component.java:391) [org.restlet-2.0.15.jar:]
   at org.restlet.Server.handle(Server.java:491) [org.restlet-2.0.15.jar:]
   at org.restlet.engine.ServerHelper.handle(ServerHelper.java:74) [org.restlet-2.0.15.jar:]
   at org.restlet.engine.http.HttpServerHelper.handle(HttpServerHelper.java:153) [org.restlet-2.0.15.jar:]
   at org.restlet.ext.servlet.ServerServlet.service(ServerServlet.java:1031) [org.restlet.ext.servlet-2.0.15.jar:]
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
   at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
   at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_25]
Caused by: org.postgresql.util.PSQLException: Bad value for type long : \x5468697320697320207570646174656420636f6d6d656e74206f6e20746865207461736b2066726f6d207468652061646d696e20616761696e2e
   at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2784) [postgresql-9.1-902.jdbc4.jar:]
   at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2007) [postgresql-9.1-902.jdbc4.jar:]
   at org.postgresql.jdbc4.Jdbc4ResultSet.getBlob(Jdbc4ResultSet.java:49) [postgresql-9.1-902.jdbc4.jar:]
   at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:344) [postgresql-9.1-902.jdbc4.jar:]
   at org.apache.ibatis.type.BlobTypeHandler.getNullableResult(BlobTypeHandler.java:37) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.type.BlobTypeHandler.getNullableResult(BlobTypeHandler.java:25) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:51) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:325) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:301) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:270) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:216) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:188) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:154) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) [mybatis-3.2.2.jar:3.2.2]
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) [mybatis-3.2.2.jar:3.2.2]
   … 75 more

Thanks &Regards
Sai Kumar

Outcomes