3 Replies Latest reply on Nov 3, 2011 4:26 PM by Ekaterina Vasilyeva

    Could not create connection error is thrown in JBPM Console

    Rajesh Chikhale Newbie

      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