[jboss-user] [JBoss jBPM] - SEAM+JBPM+MySQL todo-list example

sln do-not-reply at jboss.com
Thu May 8 08:46:10 EDT 2008


Hi, Im having trouble getting the todo-list jBPM sample to work with seam. jBPM is configured to use MySQL as data repository. When the app starts, it does create the db in MySQL, but when I try to list the activities via SEAM, the following exception is thrown:


anonymous wrote : 
  | org.jbpm.JbpmException: couldn't get task instances list for actor 'xxx' 
  | at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:65) 
  | at org.jbpm.JbpmContext.getTaskList(JbpmContext.java:189) 
  | at org.jboss.seam.bpm.TaskInstanceList.getTaskInstanceList(TaskInstanceList.java:40) 
  | at org.jboss.seam.bpm.TaskInstanceList.getTaskInstanceList(TaskInstanceList.java:33) 
  | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
  | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
  | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
  | at java.lang.reflect.Method.invoke(Method.java:585) 
  | at org.jboss.seam.util.Reflections.invoke(Reflections.java:21) 
  | at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) 
  | at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) 
  | at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31) 
  | at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  | ...
  | 12:54:47,296 ERROR [STDERR] ache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
  |     at java.lang.Thread.run(Thread.java:595)
  | Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
  |     at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
  |     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
  |     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  |     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
  |     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
  |     at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
  |     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
  |     at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
  |     at org.hibernate.loader.Loader.doQuery(Loader.java:673)
  |     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
  | ...
  | Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
  |     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
  |     at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
  |     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
  |     ... 113 more
  | Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >
  |     at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:304)
  |     at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
  |     at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
  |     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
  |     ... 115 more
  | 12:54:47,312 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
  | 12:54:47,312 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
  | 12:54:47,312 ERROR [TaskMgmtSession] org.hibernate.exception.GenericJDBCException: Cannot open connection
  | 12:54:47,312 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
  | 12:54:47,312 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
  | 12:54:47,312 ERROR [TaskMgmtSession] org.hibernate.exception.GenericJDBCException: Cannot open connection
  | 12:54:47,328 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
  | 12:54:47,328 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
  | 12:54:47,328 ERROR [TaskMgmtSession] org.hibernate.exception.GenericJDBCException: Cannot open connection
  | 

¿Any ideas? Is there any config file not explicited in the docs I should be careful with ?

Thanks in advance 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4149420#4149420

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4149420




More information about the jboss-user mailing list