Can someone please explain why I get the following error in JBOSS 3.0.x and not in JBOSS 2.4.4? Maybe if I understand this I can fix it.
EXCEPTION: You cannot set autocommit during a managed transaction!
10:12:08,985 ERROR [STDERR] java.sql.SQLException: You cannot set autocommit during a managed transaction!
10:12:08,995 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.setJdbcAutoCommit(LocalManagedConnection.java:447)
10:12:09,015 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalConnection.setAutoCommit(LocalConnection.java:426)
Fix your code to not mess with transaction settings if you are using cmt or UserTransaction. You might not have gotten the error in 2.4 because it didn't check what you were trying to do very carefully. See the response to your other post.