java.sql.SQLException: StandardXAConnectionHandle:prepareStatement getTransaction exception: javax.transaction.SystemException: Cannot send XA(StandardXAConnection: commit on prepare = is closed = this autoCommit = listeners size =<1> next timeOut =<0> timeOut period =<60000> timeOut secs =<0> transaction manager= StandardXADataSource: connection count=<12> number of dead connection=<0> dead lock max wait=<300000> dead lock retry wait=<10000> driver= driver name= number of *free* connections=<3516> max con=<0> min con=<50> prepared stmt cache size=<0> transaction manager= xid connection size=<0> StandardConnectionPoolDataSource: master prepared stmt cache size=<0> prepared stmt cache size =<0> StandardDataSource: driver= url= user= CoreDataSource : debug = description = login time out =<60> user = verbose = StandardXADataSource: connection count=<12> number of dead connection=<0> dead lock max wait=<300000> dead lock retry wait=<10000> driver= driver name= number of *free* connections=<3516> max con=<0> min con=<50> prepared stmt cache size=<0> transaction manager= xid connection size=<0> StandardConnectionPoolDataSource: master prepared stmt cache size=<0> prepared stmt cache size =<0> StandardDataSource: driver= url= user= CoreDataSource : debug = description = login time out =<60> user = verbose = StandardXAStatefulConnection: commit on prepare = timed out = id =<28373> state =<6> time out =<0> xid = StandardXAConnectionHandle: global transaction = is really used = this autoCommit = in use size =<0> master prepared stmt cache size =<0> transaction = connection = com.mysql.jdbc.JDBC4Connection@69848720) start:javax.transaction.xa.XAException (error code = -4) --null

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Kuali JIRA by Mindi Balmer, 1 year ago
> dead lock max wait=<300000> dead lock retry wait=<10000> driver= driver name= number of *free* connections=<3516> max con=<0> min con=<50> prepared stmt cache size=<0> transaction manager= xid connection size=<0
via Kuali JIRA by Mindi Balmer, 1 year ago
> dead lock max wait=<300000> dead lock retry wait=<10000> driver= driver name= number of *free* connections=<3516> max con=<0> min con=<50> prepared stmt cache size=<0> transaction manager= xid connection size=<0
via mysql.com by Unknown author, 2 years ago
The password hash doesn't h ave the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
via mysql.com by Unknown author, 2 years ago
The password hash doesn't h ave the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
via Stack Overflow by Harry
, 6 months ago
via voidcn.com by Unknown author, 1 year ago
The MySQL server is running with the --read-only option so it cannot execute this statement
java.sql.SQLException: StandardXAConnectionHandle:prepareStatement getTransaction exception: javax.transaction.SystemException: Cannot send XA(StandardXAConnection: commit on prepare = is closed = this autoCommit = listeners size =<1> next timeOut =<0> timeOut period =<60000> timeOut secs =<0> transaction manager= StandardXADataSource: connection count=<12> number of dead connection=<0> dead lock max wait=<300000> dead lock retry wait=<10000> driver= driver name= number of *free* connections=<3516> max con=<0> min con=<50> prepared stmt cache size=<0> transaction manager= xid connection size=<0> StandardConnectionPoolDataSource: master prepared stmt cache size=<0> prepared stmt cache size =<0> StandardDataSource: driver= url= user= CoreDataSource : debug = description = login time out =<60> user = verbose = StandardXADataSource: connection count=<12> number of dead connection=<0> dead lock max wait=<300000> dead lock retry wait=<10000> driver= driver name= number of *free* connections=<3516> max con=<0> min con=<50> prepared stmt cache size=<0> transaction manager= xid connection size=<0> StandardConnectionPoolDataSource: master prepared stmt cache size=<0> prepared stmt cache size =<0> StandardDataSource: driver= url= user= CoreDataSource : debug = description = login time out =<60> user = verbose = StandardXAStatefulConnection: commit on prepare = timed out = id =<28373> state =<6> time out =<0> xid = StandardXAConnectionHandle: global transaction = is really used = this autoCommit = in use size =<0> master prepared stmt cache size =<0> transaction = connection = com.mysql.jdbc.JDBC4Connection@69848720) start:javax.transaction.xa.XAException (error code = -4) --null
at org.enhydra.jdbc.standard.StandardXAConnectionHandle.prepareStatement(StandardXAConnectionHandle.java:302)
at sun.reflect.GeneratedMethodAccessor211.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at com.sun.proxy.$Proxy533.prepareStatement(Unknown Source)
at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Unknown Source)
at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPreparedStmt(Unknown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unknown Source)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source)
at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193)
at org.kuali.kpme.core.job.dao.JobDaoOjbImpl.getJobs(JobDaoOjbImpl.java:90)
at org.kuali.kpme.core.job.service.JobServiceImpl.getJobs(JobServiceImpl.java:63)
at sun.reflect.GeneratedMethodAccessor563.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:214)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy423.getJobs(Unknown Source)
at sun.reflect.GeneratedMethodAccessor563.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:58)
at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:214)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy424.getJobs(Unknown Source)
at sun.reflect.GeneratedMethodAccessor563.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy424.getJobs(Unknown Source)
at org.kuali.kpme.tklm.common.PersonInfoAction.execute(PersonInfoAction.java:77)
at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:491)
at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:487)
at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:216)
at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:203)
at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:90)
at org.kuali.kpme.core.KPMERequestProcessor.process(KPMERequestProcessor.java:43)
at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:198)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:78)
at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:89)
at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:327)
at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:75)
at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
at org.kuali.rice.krad.web.filter.BootstrapFilter.doFilter(BootstrapFilter.java:199)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.kuali.rice.core.web.Log4JContextClearingFilter.doFilterInternal(Log4JContextClearingFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.springframework.web.filter.AbstractRequestLoggingFilter.doFilterInternal(AbstractRequestLoggingFilter.java:213)
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.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at java.lang.Thread.run(Thread.java:701)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.