however, when i execute session.commit() in my DAO implementation, i get the following exception. i've used this same pattern in apps deployed on tomcat and weblogic, so i'm thinking this might be a jboss 3.2.6 issue. i didnt see a bug entry in jboss's JIRA. anyone know if I'm missing a config setting somewhere?
thanks in advance, t
Caused by: java.sql.SQLException: You cannot commit with autocommit set! at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:527) at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:473) at com.cauldron.framework.dao.hibernate.SpringHibernateDAOSupportImpl.createObject(SpringHibernateDAOSupportImpl.java:408) ... 54 more
I had a similar problem before. The connection obtained from JBoss managed datasource has autocommit set to true by default. So, you need to set it to false manually in your code where you get the connection from the datasource.