Changed the code to have the connection within the user transaction it now works.
Thanks JBoss Support!
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3837050#3837050
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=383
Here is the DB logs. I see an autocommit=1 and no transaction markers, so that is why
it is not rolling back. Any idea why?
040519 15:43:23 17 Connect [EMAIL PROTECTED] on eCity
| 17 Init DB ecity
| 17 Query select round('inf'), round('-i
Thanks for the quickly reply. I put on the tracing as recommended and here is the
rollback section:
2004-05-19 14:19:36,814 TRACE
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] supplying
ManagedConnection from pool: [EMAIL PROTECTED]
2004-05-19 14:19:36,814 TRACE
[org.jboss
I'm setting up MySQL with JBoss and testing the transaction facility. I have a
stateless session bean that I have created using the JBoss IDE. Everything works
without an error.
At the DB level, the transactions fail properly - INNODB is setup, and I roll-back
properly through SQL.
I'm usi
