[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - java.sql.SQLException: You cannot commit with autocommit set

[gvreddy]

Hi 

I got the following exception when i am trying to do commit using kodo persistencemanager class.

I specified autoCommit property to false in oracle-xa.xml file.
Any configuration is required to solve this issue.
Thanks in advance.

2007-05-14 18:49:04,630 DEBUG [kodo.Runtime] An exception occurred while ending the transaction.  This exception will be re-thrown.
kodo.util.FatalDataStoreException: You cannot commit with autocommit set!
NestedThrowables:
java.sql.SQLException: You cannot commit with autocommit set!
	at kodo.jdbc.sql.SQLExceptions.getFatalDataStore(SQLExceptions.java:42)
	at kodo.jdbc.sql.SQLExceptions.getFatalDataStore(SQLExceptions.java:24)
	at kodo.jdbc.runtime.JDBCStoreManager.commit(JDBCStoreManager.java:137)
	at kodo.runtime.DelegatingStoreManager.commit(DelegatingStoreManager.java:100)
	at kodo.runtime.PersistenceManagerImpl.endTransaction(PersistenceManagerImpl.java:1035)
	at kodo.runtime.PersistenceManagerImpl.afterCompletion(PersistenceManagerImpl.java:842)
	at org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1526)
	at org.jboss.tm.TransactionImpl.completeTransaction(TransactionImpl.java:1198)
	at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:377)
	at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:501)
	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:361)
	at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
	at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
	at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
	at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
	at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
	at org.jboss.ejb.Container.invoke(Container.java:954)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
	at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
	at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
	at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
	at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
	at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
	at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
	at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
	at $Proxy112.findEntryUserById(Unknown Source)
	at com.db.dcs.model.settlements.jboss.security.LdapDBLoginModule.validatePassword(LdapDBLoginModule.java:223)
	at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:210)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at javax.security.auth.login.LoginContext.invoke(LoginContext.java:675)
	at javax.security.auth.login.LoginContext.access$000(LoginContext.java:129)
	at javax.security.auth.login.LoginContext$4.run(LoginContext.java:610)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:607)
	at javax.security.auth.login.LoginContext.login(LoginContext.java:534)
	at org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityManager.java:601)
	at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:535)
	at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:344)
	at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.authenticate(JBossSecurityMgrRealm.java:491)
	at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:257)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:416)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: You cannot commit with autocommit set!
	at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:545)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:334)
	at com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
	at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:219)
	at com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
	at kodo.jdbc.runtime.JDBCStoreManager.commit(JDBCStoreManager.java:132)
	... 61 more

Some where i read that we can manually set autocommit to false.
But I am using persistencemanager class.


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4058004#4058004

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4058004