Mauro, is it a question or a FYI? BTW this exception is common with MySQL when not using eviction cause it cuts connections after 8h automatically.
Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber <http://www.tomitribe.com> 2016-03-03 17:05 GMT+01:00 mauro2java2011 <[email protected]>: > before to add the properties i get from catalina.out > > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No > operations allowed after connection closed. > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) > at > > com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1290) > at > com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1282) > at > com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5236) > at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > > org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) > at > > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > > org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) > at com.sun.proxy.$Proxy204.setAutoCommit(Unknown Source) > at > > org.apache.openejb.resource.jdbc.managed.local.LocalXAResource.start(LocalXAResource.java:65) > ... 93 more > *Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The > last packet successfully received from the server was 41,059,994 > milliseconds ago. The last packet sent successfully to the server was > 41,059,995 milliseconds ago. is longer than the server configured value of > 'wait_timeout'. You should consider either expiring and/or testing > connection validity before use in your application, increasing the server > configured values for client timeouts, or using the Connector/J connection > property 'autoReconnect=true' to avoid this problem.* > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117) > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3871) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2484) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788) > at > com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5282) > at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > > org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) > at > > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > > org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) > at com.sun.proxy.$Proxy204.setAutoCommit(Unknown Source) > at > > org.apache.openejb.resource.jdbc.managed.local.LocalXAResource.start(LocalXAResource.java:65) > at > > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:209) > at > > org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke(ManagedConnection.java:112) > at com.sun.proxy.$Proxy205.prepareStatement(Unknown Source) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:135) > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:248) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1643) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:508) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:488) > at > > org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:481) > at > org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422) > at > org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384) > at > > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) > at > > org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2070) > at > org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) > at > org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) > at > org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) > at > org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275) > at > org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291) > at mauro.ejbs.AbstractFacade.findRange(AbstractFacade.java:52) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:192) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:173) > at > > org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:181) > at > > org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:100) > at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:192) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:173) > at > > org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:85) > at > > org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:227) > at > > org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:194) > at > > org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:308) > at > > org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:303) > at > > org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) > at > > org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:308) > at > > mauro.ejbs.MacchinaFacade$$LocalBeanProxy.findRange(mauro/ejbs/MacchinaFacade.java) > at > > mauro.controllers.MacchinaController$1.createPageDataModel(MacchinaController.java:58) > at > mauro.controllers.MacchinaController.getItems(MacchinaController.java:158) > at > > mauro.controllers.MacchinaController$$OwbNormalScopeProxy0.getItems(mauro/controllers/MacchinaController.java) > at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at javax.el.BeanELResolver.getValue(BeanELResolver.java:99) > at > javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67) > at > > org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:179) > at org.apache.el.parser.AstValue.getValue(AstValue.java:183) > at org.apache.el.parser.AstEqual.getValue(AstEqual.java:37) > at > org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:184) > at > > org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70) > at > > org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) > at > javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266) > at > javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541) > at > > org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) > at > > org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305) > at > > javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) > at > > org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) > at > org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) > at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) > at > org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:44) > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) > at > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) > ... 4 more > Caused by: java.net.SocketException: Broken pipe > at java.net.SocketOutputStream.socketWrite0(Native Method) > at > java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113) > at java.net.SocketOutputStream.write(SocketOutputStream.java:159) > at > java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) > at > java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3852) > ... 106 more > > > Mar 03, 2016 5:14:25 AM > org.apache.openejb.core.transaction.EjbTransactionUtil > handleSystemException > SEVERE: EjbTransactionUtil.handleSystemException: Failed to execute query > "null". Check the query syntax for correctness. See nested exception for > details. > <openjpa-2.4.0-nonfinal-1598334-r422266:1599166 nonfatal user error> > org.apache.openjpa.persistence.ArgumentException: Failed to execute query > "null". Check the query syntax for correctness. See nested exception for > details. > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:872) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) > at > org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) > at > org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275) > at > org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291) > at mauro.ejbs.AbstractFacade.findRange(AbstractFacade.java:52) > at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:192) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:173) > at > > org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:181) > at > > org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:100) > at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:192) > at > > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:173) > at > > org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:85) > at > > org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:227) > at > > org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:194) > at > > org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:308) > at > > org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:303) > at > > org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) > at > > org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:308) > at > > mauro.ejbs.MacchinaFacade$$LocalBeanProxy.findRange(mauro/ejbs/MacchinaFacade.java) > at > > mauro.controllers.MacchinaController$1.createPageDataModel(MacchinaController.java:58) > at > mauro.controllers.MacchinaController.getItems(MacchinaController.java:158) > at > > mauro.controllers.MacchinaController$$OwbNormalScopeProxy0.getItems(mauro/controllers/MacchinaController.java) > at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at javax.el.BeanELResolver.getValue(BeanELResolver.java:99) > at > javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67) > at > > org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:179) > at org.apache.el.parser.AstValue.getValue(AstValue.java:183) > at org.apache.el.parser.AstEqual.getValue(AstEqual.java:37) > at > org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:184) > at > > org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70) > at > > org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) > at > javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266) > at > javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541) > at > javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541) > at > > org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) > at > > org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305) > at > > javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) > at > > org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) > at > org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) > at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) > at > org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:44) > at > > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) > at > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.lang.reflect.UndeclaredThrowableException > at com.sun.proxy.$Proxy205.prepareStatement(Unknown Source) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:135) > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:248) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1643) > at > > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:508) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:488) > at > > org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:481) > at > org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422) > at > org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384) > at > > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) > at > > org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2070) > at > org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) > at > org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) > ... 72 more > Caused by: javax.transaction.RollbackException: Transaction is marked for > rollback > at > > org.apache.geronimo.transaction.manager.TransactionImpl.registerSynchronization(TransactionImpl.java:154) > at > > org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke(ManagedConnection.java:119) > ... 91 more > > > > > -- > View this message in context: > http://tomee-openejb.979440.n4.nabble.com/how-set-propwerties-of-datasource-mysql-tp4677759p4677762.html > Sent from the TomEE Users mailing list archive at Nabble.com. >
