JBoss Community

Could not create connection error is thrown in JBPM Console

created by Rajesh Chikhale in jBPM - View the full discussion

Hi,

When navigationg through process overview tab in JBPM console an below  error is thrown

 

2011-03-15 15:37:43,781 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost%2F127.0.0.1-8080-3) Unable to get managed connection for jdbc/testDS1; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/testDS1)

 

H2 database is started correctly as per the build script execution.Please could you let me know what  might be the issue,below is the error log

 

Please find below logs

 

 

 

2011-03-15 15:37:41,156 ERROR [org.hibernate.ejb.AbstractEntityManagerImpl] (http-localhost%2F127.0.0.1-8080-3) Unable to mark for rollback on PersistenceException:

 

java.lang.IllegalStateException: [com.arjuna.ats.internal.jta.transaction.arjunacore.nosuchtx] [com.arjuna.ats.internal.jta.transaction.arjunacore.nosuchtx] No such transaction!

     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.setRollbackOnly(BaseTransaction.java:191)

     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.setRollbackOnly(BaseTransactionManagerDelegate.java:123)

     at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(AbstractEntityManagerImpl.java:421)

     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:576)

     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

     at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202)

     at org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)

     at org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)

     at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)

     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

     at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

     at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)

     at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)

     at org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)

     at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:133)

     at org.jbpm.integration.console.CommandDelegate.getSession(CommandDelegate.java:185)

     at org.jbpm.integration.console.CommandDelegate.<init>(CommandDelegate.java:69)

     at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:35)

     at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22)

     at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19)

     at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:98)

     at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:122)

     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.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)

     at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)

 

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)

 

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)

 

    at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)

 

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)

 

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)

 

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

 

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

 

    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

 

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

 

    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

 

    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

 

    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

 

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

 

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

 

    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

 

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

 

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

 

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

 

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

 

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

 

    at java.lang.Thread.run(Thread.java:595)

 

2011-03-15 15:37:41,171 INFO  [STDOUT] (http-localhost%2F127.0.0.1-8080-3) Error loading session data: java.lang.reflect.InvocationTargetException

 

2011-03-15 15:37:41,171 INFO  [STDOUT] (http-localhost%2F127.0.0.1-8080-3) Creating new session data ...

 

2011-03-15 15:37:43,734 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (http-localhost%2F127.0.0.1-8080-3) Throwable while attempting to get a new connection: null

 

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0" [50000-124]

 

    at org.h2.message.Message.getSQLException(Message.java:111)

 

    at org.h2.message.Message.convert(Message.java:288)

 

    at org.h2.engine.Database.openDatabase(Database.java:261)

 

    at org.h2.engine.Database.<init>(Database.java:221)

 

    at org.h2.engine.Engine.openSession(Engine.java:58)

 

    at org.h2.engine.Engine.openSession(Engine.java:142)

 

    at org.h2.engine.Engine.getSession(Engine.java:122)

 

    at org.h2.server.TcpServerThread.run(TcpServerThread.java:122)

 

    at java.lang.Thread.run(Thread.java:595)

 

Caused by: java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0

 

    at org.h2.message.Message.throwInternalError(Message.java:191)

 

    at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:220)

 

    at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:74)

 

    at org.h2.table.TableData.<init>(TableData.java:83)

 

    at org.h2.store.PageStore.addMeta(PageStore.java:1304)

 

    at org.h2.store.PageStore.redo(PageStore.java:1185)

 

    at org.h2.store.PageLog.recover(PageLog.java:285)

 

    at org.h2.store.PageStore.recover(PageStore.java:1051)

 

    at org.h2.store.PageStore.openExisting(PageStore.java:310)

 

    at org.h2.store.PageStore.open(PageStore.java:268)

 

    at org.h2.engine.Database.getPageStore(Database.java:2305)

 

    at org.h2.engine.Database.open(Database.java:624)

 

    at org.h2.engine.Database.openDatabase(Database.java:227)

 

    ... 6 more

 

)

 

    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)

 

    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)

 

    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)

 

    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)

 

    at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:679)

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)

 

    at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)

 

    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)

 

    at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

 

    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

 

    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

 

    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

 

    at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:54)

 

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)

 

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)

 

    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)

 

    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

 

    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)

 

    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)

 

    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)

 

    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)

 

    at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)

 

    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)

 

    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)

 

    at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:645)

 

    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:619)

 

    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:623)

 

    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220)

 

    at org.drools.persistence.jpa.JpaPersistenceContext.persist(JpaPersistenceContext.java:17)

 

    at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:125)

 

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

 

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

 

    at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

 

    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:116)

 

    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:54)

 

    at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)

 

    at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:145)

 

    at org.jbpm.integration.console.CommandDelegate.getSession(CommandDelegate.java:185)

 

    at org.jbpm.integration.console.CommandDelegate.<init>(CommandDelegate.java:69)

 

    at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:35)

 

    at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22)

 

    at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19)

 

    at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:98)

 

    at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:122)

 

    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.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)

 

    at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)

 

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)

 

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)

 

    at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)

 

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)

 

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)

 

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

 

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

 

    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

 

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

 

    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

 

    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

 

    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

 

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

 

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

 

    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

 

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

 

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

 

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

 

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

 

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

 

    at java.lang.Thread.run(Thread.java:595)

 

Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0" [50000-124]

 

    at org.h2.message.Message.getSQLException(Message.java:111)

 

    at org.h2.message.Message.convert(Message.java:288)

 

    at org.h2.engine.Database.openDatabase(Database.java:261)

 

    at org.h2.engine.Database.<init>(Database.java:221)

 

    at org.h2.engine.Engine.openSession(Engine.java:58)

 

    at org.h2.engine.Engine.openSession(Engine.java:142)

 

    at org.h2.engine.Engine.getSession(Engine.java:122)

 

    at org.h2.server.TcpServerThread.run(TcpServerThread.java:122)

 

    at java.lang.Thread.run(Thread.java:595)

 

Caused by: java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0

 

    at org.h2.message.Message.throwInternalError(Message.java:191)

 

    at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:220)

 

    at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:74)

 

    at org.h2.table.TableData.<init>(TableData.java:83)

 

    at org.h2.store.PageStore.addMeta(PageStore.java:1304)

 

    at org.h2.store.PageStore.redo(PageStore.java:1185)

 

    at org.h2.store.PageLog.recover(PageLog.java:285)

 

    at org.h2.store.PageStore.recover(PageStore.java:1051)

 

    at org.h2.store.PageStore.openExisting(PageStore.java:310)

 

    at org.h2.store.PageStore.open(PageStore.java:268)

 

    at org.h2.engine.Database.getPageStore(Database.java:2305)

 

    at org.h2.engine.Database.open(Database.java:624)

 

    at org.h2.engine.Database.openDatabase(Database.java:227)

 

    ... 6 more

 

 

 

    at org.h2.engine.SessionRemote.done(SessionRemote.java:522)

 

    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:115)

 

    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:337)

 

    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:229)

 

    at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)

 

    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)

 

    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)

 

    at org.h2.Driver.connect(Driver.java:58)

 

    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)

 

    ... 84 more

 

2011-03-15 15:37:43,765 WARN  [org.hibernate.util.JDBCExceptionReporter] (http-localhost%2F127.0.0.1-8080-3) SQL Error: 0, SQLState: null

 

2011-03-15 15:37:43,781 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost%2F127.0.0.1-8080-3) Unable to get managed connection for jdbc/testDS1; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/testDS1)

 

2011-03-15 15:37:43,781 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/gwt-console-server].[Resteasy]] (http-localhost%2F127.0.0.1-8080-3) Servlet.service() for servlet Resteasy threw exception

 

org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Could not initialize stateful knowledge session: java.lang.reflect.InvocationTargetException

 

    at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:319)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:230)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:206)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:360)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)

 

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)

 

    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)

 

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

 

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

 

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

 

    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

 

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

 

    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

 

    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

 

    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

 

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

 

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

 

    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

 

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

 

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

 

    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

 

    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

 

    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

 

    at java.lang.Thread.run(Thread.java:595)

 

Caused by: java.lang.RuntimeException: Could not initialize stateful knowledge session: java.lang.reflect.InvocationTargetException

 

    at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:177)

 

    at org.jbpm.integration.console.CommandDelegate.getSession(CommandDelegate.java:185)

 

    at org.jbpm.integration.console.CommandDelegate.<init>(CommandDelegate.java:69)

 

    at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:35)

 

    at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22)

 

    at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19)

 

    at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:98)

 

    at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:122)

 

    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.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)

 

    at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)

 

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)

 

    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)

 

    at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)

 

    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)

 

    ... 28 more

 

Caused by: java.lang.IllegalStateException: java.lang.reflect.InvocationTargetException

 

    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:130)

 

    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:54)

 

    at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)

 

    at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:145)

 

    ... 45 more

 

Caused by: java.lang.reflect.InvocationTargetException

 

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

 

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

 

    at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

 

    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:116)

 

    ... 48 more

 

Caused by: java.lang.RuntimeException: Could not commit session

 

    at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:136)

 

    ... 53 more

 

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection

 

    at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

 

    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:226)

 

    at org.drools.persistence.jpa.JpaPersistenceContext.persist(JpaPersistenceContext.java:17)

 

    at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:125)

 

    ... 53 more

 

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

 

    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)

 

    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)

 

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

 

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

 

    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

 

    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

 

    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

 

    at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:54)

 

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)

 

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)

 

    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)

 

    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

 

    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)

 

    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)

 

    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)

 

    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)

 

    at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)

 

    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)

 

    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)

 

    at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:645)

 

    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:619)

 

    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:623)

 

    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220)

 

    ... 55 more

 

Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/testDS1; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/testDS1)

 

    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)

 

    at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

 

    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

 

    ... 73 more

 

Caused by: javax.resource.ResourceException: Unable to get managed connection for jdbc/testDS1

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)

 

    at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)

 

    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)

 

    ... 75 more

 

Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0" [50000-124]

 

    at org.h2.message.Message.getSQLException(Message.java:111)

 

    at org.h2.message.Message.convert(Message.java:288)

 

    at org.h2.engine.Database.openDatabase(Database.java:261)

 

    at org.h2.engine.Database.<init>(Database.java:221)

 

    at org.h2.engine.Engine.openSession(Engine.java:58)

 

    at org.h2.engine.Engine.openSession(Engine.java:142)

 

    at org.h2.engine.Engine.getSession(Engine.java:122)

 

    at org.h2.server.TcpServerThread.run(TcpServerThread.java:122)

 

    at java.lang.Thread.run(Thread.java:595)

 

Caused by: java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0

 

    at org.h2.message.Message.throwInternalError(Message.java:191)

 

    at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:220)

 

    at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:74)

 

    at org.h2.table.TableData.<init>(TableData.java:83)

 

    at org.h2.store.PageStore.addMeta(PageStore.java:1304)

 

    at org.h2.store.PageStore.redo(PageStore.java:1185)

 

    at org.h2.store.PageLog.recover(PageLog.java:285)

 

    at org.h2.store.PageStore.recover(PageStore.java:1051)

 

    at org.h2.store.PageStore.openExisting(PageStore.java:310)

 

    at org.h2.store.PageStore.open(PageStore.java:268)

 

    at org.h2.engine.Database.getPageStore(Database.java:2305)

 

    at org.h2.engine.Database.open(Database.java:624)

 

    at org.h2.engine.Database.openDatabase(Database.java:227)

 

    ... 6 more

 

)

 

    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)

 

    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)

 

    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)

 

    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)

 

    at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:679)

 

    at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)

 

    ... 79 more

 

Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0" [50000-124]

 

    at org.h2.message.Message.getSQLException(Message.java:111)

 

    at org.h2.message.Message.convert(Message.java:288)

 

    at org.h2.engine.Database.openDatabase(Database.java:261)

 

    at org.h2.engine.Database.<init>(Database.java:221)

 

    at org.h2.engine.Engine.openSession(Engine.java:58)

 

    at org.h2.engine.Engine.openSession(Engine.java:142)

 

    at org.h2.engine.Engine.getSession(Engine.java:122)

 

    at org.h2.server.TcpServerThread.run(TcpServerThread.java:122)

 

    at java.lang.Thread.run(Thread.java:595)

 

Caused by: java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0

 

    at org.h2.message.Message.throwInternalError(Message.java:191)

 

    at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:220)

 

    at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:74)

 

    at org.h2.table.TableData.<init>(TableData.java:83)

 

    at org.h2.store.PageStore.addMeta(PageStore.java:1304)

 

    at org.h2.store.PageStore.redo(PageStore.java:1185)

 

    at org.h2.store.PageLog.recover(PageLog.java:285)

 

    at org.h2.store.PageStore.recover(PageStore.java:1051)

 

    at org.h2.store.PageStore.openExisting(PageStore.java:310)

 

    at org.h2.store.PageStore.open(PageStore.java:268)

 

    at org.h2.engine.Database.getPageStore(Database.java:2305)

 

    at org.h2.engine.Database.open(Database.java:624)

 

    at org.h2.engine.Database.openDatabase(Database.java:227)

 

    ... 6 more

 

 

 

    at org.h2.engine.SessionRemote.done(SessionRemote.java:522)

 

    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:115)

 

    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:337)

 

    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:229)

 

    at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)

 

    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)

 

    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)

 

    at org.h2.Driver.connect(Driver.java:58)

 

    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)

 

    ... 84 more

Reply to this message by going to Community

Start a new discussion in jBPM at Community