i am try to get tasklist of a user but i have the same error: anonymous wrote : | 15:39:53,808 WARN [JDBCExceptionReporter] SQL Error: 1054, SQLState: 42S22 | 15:39:53,808 ERROR [JDBCExceptionReporter] Unknown column 'taskinstan0_.ISSIGNA | LING_' in 'field list' | 15:39:53,808 DEBUG [JbpmContext] closing JbpmContext | 15:39:53,808 DEBUG [Services] closing service 'persistence': org.jbpm.persisten | [EMAIL PROTECTED] | 15:39:53,808 DEBUG [DbPersistenceService] committing hibernate transaction | 15:39:53,855 DEBUG [DbPersistenceService] closing hibernate session | 15:39:53,855 DEBUG [Services] closing service 'authentication': org.jbpm.securi | [EMAIL PROTECTED] | 15:39:53,855 WARN [RequestProcessor] Unhandled Exception thrown: class org.hib | rnate.exception.SQLGrammarException | 15:39:53,855 ERROR [[action]] Servlet.service() for servlet action threw except | on | org.hibernate.exception.SQLGrammarException: could not initialize a collection: | [org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances#9] | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter. | ava:67) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel | er.java:43) | at org.hibernate.loader.Loader.loadCollection(Loader.java:1926) | at org.hibernate.loader.collection.CollectionLoader.initialize(Collecti | nLoader.java:36) | at org.hibernate.persister.collection.AbstractCollectionPersister.initi | lize(AbstractCollectionPersister.java:541) | at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onI | itializeCollection(DefaultInitializeCollectionEventListener.java:60) | at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java | 1705) | at org.hibernate.collection.AbstractPersistentCollection.initialize(Abs | ractPersistentCollection.java:344) | at org.hibernate.collection.AbstractPersistentCollection.read(AbstractP | rsistentCollection.java:86) | at org.hibernate.collection.AbstractPersistentCollection.readSize(Abstr | ctPersistentCollection.java:109) | at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:12 | ) | at com.actions.StartProcessInstance.performAction(StartProcessInstance. | ava:52) | at com.actions.BaseAction.execute(BaseAction.java:19) | at org.apache.struts.action.RequestProcessor.processActionPerform(Reque | tProcessor.java:431) | at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j | va:236) | at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 | 6) | at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432 | | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App | icationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application | ilterChain.java:173) | at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDis | atcher.java:672) | at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applic | tionDispatcher.java:463) | at org.apache.catalina.core.ApplicationDispatcher.doForward(Application | ispatcher.java:398) | at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDi | patcher.java:301) | at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor | java:1085) | at org.apache.struts.action.RequestProcessor.processForwardConfig(Reque | tProcessor.java:398) | at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j | va:241) | at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 | 6) | at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432 | | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App | icationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application | ilterChain.java:173) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF | lter.java:96) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App | icationFilterChain.java:202) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application | ilterChain.java:173) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper | alve.java:213) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContext | alve.java:178) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi | yAssociationValve.java:175) | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal | e.java:74) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve. | ava:126) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve. | ava:105) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa | ve.java:107) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja | a:148) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav | :869) | at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler. | rocessConnection(Http11BaseProtocol.java:664) | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndp | int.java:527) | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWo | kerThread.java:112) | at java.lang.Thread.run(Thread.java:595) | Caused by: java.sql.SQLException: Unknown column 'taskinstan0_.ISSIGNALLING_' i | 'field list' | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) | at com.mysql.jdbc.Connection.execSQL(Connection.java:3026) | at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.j | va:1137) | at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java | 1231) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer | (WrappedPreparedStatement.java:236) | at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java | 186) | at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) | at org.hibernate.loader.Loader.doQuery(Loader.java:662) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L | ader.java:224) | at org.hibernate.loader.Loader.loadCollection(Loader.java:1919) | ... 47 more | 15:39:53,870 ERROR [[action]] Servlet.service() for servlet action threw except | on | org.hibernate.exception.SQLGrammarException: could not initialize a collection: | [org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances#9] | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter. | ava:67) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel | er.java:43) | at org.hibernate.loader.Loader.loadCollection(Loader.java:1926) | at org.hibernate.loader.collection.CollectionLoader.initialize(Collecti | nLoader.java:36) | at org.hibernate.persister.collection.AbstractCollectionPersister.initi | lize(AbstractCollectionPersister.java:541) | at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onI | itializeCollection(DefaultInitializeCollectionEventListener.java:60) | at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java | 1705) | at org.hibernate.collection.AbstractPersistentCollection.initialize(Abs | ractPersistentCollection.java:344) | at org.hibernate.collection.AbstractPersistentCollection.read(AbstractP | rsistentCollection.java:86) | at org.hibernate.collection.AbstractPersistentCollection.readSize(Abstr | ctPersistentCollection.java:109) | at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:12 | ) | at com.actions.StartProcessInstance.performAction(StartProcessInstance. | ava:52) | at com.actions.BaseAction.execute(BaseAction.java:19) | at org.apache.struts.action.RequestProcessor.processActionPerform(Reque | tProcessor.java:431) | at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j | va:236) | at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 | 6) | at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432 | | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App | icationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application | ilterChain.java:173) | at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDis | atcher.java:672) | at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applic | tionDispatcher.java:463) | at org.apache.catalina.core.ApplicationDispatcher.doForward(Application | ispatcher.java:398) | at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDi | patcher.java:301) | at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor | java:1085) | at org.apache.struts.action.RequestProcessor.processForwardConfig(Reque | tProcessor.java:398) | at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j | va:241) | at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11 | 6) | at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432 | | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App | icationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application | ilterChain.java:173) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF | lter.java:96) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App | icationFilterChain.java:202) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application | ilterChain.java:173) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper | alve.java:213) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContext | alve.java:178) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi | yAssociationValve.java:175) | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal | e.java:74) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve. | ava:126) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve. | ava:105) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa | ve.java:107) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja | a:148) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav | :869) | at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler. | rocessConnection(Http11BaseProtocol.java:664) | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndp | int.java:527) | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWo | kerThread.java:112) | at java.lang.Thread.run(Thread.java:595) | Caused by: java.sql.SQLException: Unknown column 'taskinstan0_.ISSIGNALLING_' i | 'field list' | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) | at com.mysql.jdbc.Connection.execSQL(Connection.java:3026) | at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.j | va:1137) | at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java | 1231) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer | (WrappedPreparedStatement.java:236) | at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java | 186) | at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) | at org.hibernate.loader.Loader.doQuery(Loader.java:662) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L | ader.java:224) | at org.hibernate.loader.Loader.loadCollection(Loader.java:1919) | ... 47 more |
i do the simple execution : | jbpmcontext.getTaskList("ernie"); | i dont understand this error. firstly i thought it ISSIGNALLING field on my database, please help me View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4062442#4062442 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4062442 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user