# Lost connection with MySQL **URL:** https://community.ofelia.com/t/lost-connection-with-mysql/3970 **Category:** Q&A **Created:** [20 November 2013 23:54 UTC](https://community.ofelia.com/t/lost-connection-with-mysql/3970 "2013-11-20T23:54:25Z") **Posts on this page:** 4 **Page:** 1
### Author: ![decyzjoner](https://avatars.discourse-cdn.com/v4/letter/d/7993a0/32.png) [@decyzjoner](https://community.ofelia.com/u/decyzjoner) #### Post date: [20 November 2013 23:54 UTC](https://community.ofelia.com/t/lost-connection-with-mysql/3970/1 "2013-11-20T23:54:25Z")
Hi I've strange problem. My Production Bonita Portal works good. There are 5 processes and 100 intancess. After some time (few hours after restart server) there is o lot errors (in yellow notes), but Portal is still working.  After short time Portal stops. Please help, it's production so I must often restart server. Here is log: root@hds105:/opt/bos/logs# tail -1000 bonita.2013-11-20.log         at org.bonitasoft.console.server.datastore.bpm.cases.ArchivedCaseDatastore.runSearch(ArchivedCaseDatastore.java:104)         at org.bonitasoft.console.server.datastore.bpm.cases.ArchivedCaseDatastore.search(ArchivedCaseDatastore.java:77)         at org.bonitasoft.console.server.api.bpm.cases.APIArchivedCase.search(APIArchivedCase.java:66)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.reflect.UndeclaredThrowableException         at com.sun.proxy.$Proxy27.searchArchivedProcessInstancesInvolvingUser(Unknown Source)         at org.bonitasoft.console.server.datastore.bpm.cases.ArchivedCaseDatastore.runSearch(ArchivedCaseDatastore.java:93)         ... 26 more Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         ... 28 more Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)         ... 32 more Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)         ... 34 more Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)         ... 46 more Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032C9F7D000093F0 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032C9F7D000093F1], error=!invalid error code (0)!         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         ... 59 more Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)         at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)         at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)         ... 61 more Nov 20, 2013 12:17:21 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions SEVERE: Error when searching process user can start org.bonitasoft.web.toolkit.client.common.exception.api.APIException: Error when searching process user can start         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:168)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724) Caused by: org.bonitasoft.engine.exception.SearchException: Error while retrieving process definitions: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not execute query         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3649)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at ══════════════════════════.\()         at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:678)         at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)         at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at .Caused By:(org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not execute query)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:650)         at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)         at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)         at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)         at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at .Caused By:(org.hibernate.exception.GenericJDBCException: could not execute query)         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)         at org.hibernate.loader.Loader.doList(Loader.java:2545)         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)         at org.hibernate.loader.Loader.list(Loader.java:2271)         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)         at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)         at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)         at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)         at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at .Caused By:(could not execute query)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.doList(Loader.java:2542)         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)         at org.hibernate.loader.Loader.list(Loader.java:2271)         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)         at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)         at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)         at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)         at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at .Caused By:(error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.doList(Loader.java:2542)         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)         at org.hibernate.loader.Loader.list(Loader.java:2271)         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)         at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)         at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)         at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)         at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at .Caused By:(cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032CA48500009405 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032CA48500009407], error=!invalid error code (0)!)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)         at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)         at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.doList(Loader.java:2542)         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)         at org.hibernate.loader.Loader.list(Loader.java:2271)         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)         at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)         at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)         at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)         at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)         at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)         at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)         at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724)         at .Caused By:(No operations allowed after connection closed.) Nov 20, 2013 12:34:42 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions SEVERE: null java.lang.reflect.UndeclaredThrowableException         at com.sun.proxy.$Proxy23.getProfilesForUser(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProfileEngineClient.listProfilesForUser(ProfileEngineClient.java:73)         at org.bonitasoft.console.server.datastore.profile.SearchProfilesHelper.searchProfilesForUser(SearchProfilesHelper.java:64)         at org.bonitasoft.console.server.datastore.profile.SearchProfilesHelper.search(SearchProfilesHelper.java:47)         at org.bonitasoft.console.server.datastore.ComposedDatastore.search(ComposedDatastore.java:66)         at org.bonitasoft.web.toolkit.server.API.search(API.java:277)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724) Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         ... 30 more Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)         ... 34 more Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)         ... 36 more Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)         ... 48 more Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86BD00009475 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86BD00009476], error=!invalid error code (0)!         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         ... 61 more Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)         at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)         at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)         ... 63 more Nov 20, 2013 12:34:42 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions SEVERE: java.lang.reflect.UndeclaredThrowableException org.bonitasoft.web.toolkit.client.common.exception.api.APIException: java.lang.reflect.UndeclaredThrowableException         at org.bonitasoft.console.server.datastore.organization.UserDatastore.get(UserDatastore.java:133)         at org.bonitasoft.console.server.api.organization.APIUser.get(APIUser.java:113)         at org.bonitasoft.console.server.api.organization.APIUser.get(APIUser.java:44)         at org.bonitasoft.web.toolkit.server.API.runGet(API.java:216)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:158)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.reflect.UndeclaredThrowableException         at com.sun.proxy.$Proxy26.getUser(Unknown Source)         at org.bonitasoft.console.server.datastore.organization.UserDatastore.get(UserDatastore.java:125)         ... 26 more Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         ... 28 more Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)         ... 32 more Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)         ... 34 more Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)         ... 46 more Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86C800009477 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86C900009478], error=!invalid error code (0)!         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         ... 59 more Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)         at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)         at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)         ... 61 more Nov 20, 2013 12:34:48 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions SEVERE: java.lang.reflect.UndeclaredThrowableException org.bonitasoft.web.toolkit.client.common.exception.api.APIException: java.lang.reflect.UndeclaredThrowableException         at org.bonitasoft.console.server.datastore.bpm.cases.CommentDatastore.runCustomSearch(CommentDatastore.java:183)         at org.bonitasoft.console.server.datastore.bpm.cases.CommentDatastore.search(CommentDatastore.java:114)         at org.bonitasoft.console.server.api.bpm.cases.APIComment.search(APIComment.java:62)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.reflect.UndeclaredThrowableException         at com.sun.proxy.$Proxy27.searchComments(Unknown Source)         at org.bonitasoft.console.server.datastore.bpm.cases.CommentDatastore.runCustomSearch(CommentDatastore.java:179)         ... 26 more Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         ... 28 more Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)         ... 32 more Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)         ... 34 more Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)         ... 46 more Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C9C120000948F : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C9C1200009490], error=!invalid error code (0)!         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         ... 59 more Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)         at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)         at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)         ... 61 more Nov 20, 2013 12:51:00 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log SEVERE: Unexpected error while executing work java.lang.NullPointerException         at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.\(SProcessInstanceReadException.java:29)         at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)         at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)         at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)         at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)         at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)         at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)         at java.util.concurrent.FutureTask.run(FutureTask.java:262)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)         at java.lang.Thread.run(Thread.java:724) Nov 20, 2013 2:28:37 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log SEVERE: Unexpected error while executing work java.lang.NullPointerException         at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.\(SProcessInstanceReadException.java:29)         at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)         at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)         at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)         at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)         at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)         at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)         at java.util.concurrent.FutureTask.run(FutureTask.java:262)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)         at java.lang.Thread.run(Thread.java:724) Nov 20, 2013 2:30:37 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log SEVERE: Unexpected error while executing work java.lang.NullPointerException         at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.\(SProcessInstanceReadException.java:29)         at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)         at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)         at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)         at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)         at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)         at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)         at java.util.concurrent.FutureTask.run(FutureTask.java:262)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)         at java.lang.Thread.run(Thread.java:724) Nov 20, 2013 2:31:50 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log SEVERE: Unexpected error while executing work java.lang.NullPointerException         at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.\(SProcessInstanceReadException.java:29)         at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)         at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)         at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)         at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)         at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)         at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)         at java.util.concurrent.FutureTask.run(FutureTask.java:262)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)         at java.lang.Thread.run(Thread.java:724) Nov 20, 2013 3:35:39 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log SEVERE: Unexpected error while executing work java.lang.NullPointerException         at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.\(SProcessInstanceReadException.java:29)         at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)         at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)         at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)         at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)         at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)         at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)         at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)         at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)         at java.util.concurrent.FutureTask.run(FutureTask.java:262)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)         at java.lang.Thread.run(Thread.java:724) Nov 20, 2013 3:47:17 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions SEVERE: null java.lang.reflect.UndeclaredThrowableException         at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)         at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)         at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)         at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)         at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)         at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)         at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)         at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)         at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)         at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)         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:233)         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)         at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)         at java.lang.Thread.run(Thread.java:724) Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)         at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)         at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)         ... 30 more Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)         at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)         ... 34 more Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]         at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)         at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)         at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)         ... 36 more Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:606)         at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)         at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)         at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)         at org.hibernate.loader.Loader.doQuery(Loader.java:801)         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)         at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)         ... 48 more Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F6465300000000003ECD7A100009666 : 626F6E6974612D746F6D6361742D62746D2D6E6F6465300000000003ECD7A100009667], error=!invalid error code (0)!         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)         at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)         at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)         ... 61 more Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)         at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)         at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)         at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)         at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)         ... 63 more ---
### Author: ![jhosimar8806](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@jhosimar8806](https://community.ofelia.com/u/jhosimar8806) #### Post date: [21 November 2013 15:13 UTC](https://community.ofelia.com/t/lost-connection-with-mysql/3970/2 "2013-11-21T15:13:00Z")
  with that code you extract data from your database?  I wanted to know if you can help me with that because they already tried everything and I can not extract data from my database please help me. Can you tell me which code you used please? ---
### Author: ![haris.subasic](https://avatars.discourse-cdn.com/v4/letter/h/5daacb/32.png) [@haris.subasic](https://community.ofelia.com/u/haris.subasic) #### Post date: [25 November 2013 14:13 UTC](https://community.ofelia.com/t/lost-connection-with-mysql/3970/3 "2013-11-25T14:13:53Z")
Hello, I assume that you use Tomcat (it's good to specify it in your initial post ;)). It seems that you need to explicitly test the connection in your datasource settings since it times out. Most probably something like _resource.ds1.testQuery=SELECT 1_ in your bitronix settings file would do the trick. Hope this helps, Haris ---
### Author: ![jainmayank33](https://avatars.discourse-cdn.com/v4/letter/j/9fc29f/32.png) [@jainmayank33](https://community.ofelia.com/u/jainmayank33) #### Post date: [5 August 2016 02:41 UTC](https://community.ofelia.com/t/lost-connection-with-mysql/3970/4 "2016-08-05T02:41:24Z")
Hi decyzjoner, I understand this thread became very old. Can you please brief me how did you solve this problem? Appreciate your help! Thanks, Mayank