File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes jboss+mysql : transaction not rolling back properly!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "jboss+mysql : transaction not rolling back properly!!!" Watch "jboss+mysql : transaction not rolling back properly!!!" New topic
Author

jboss+mysql : transaction not rolling back properly!!!

Sajid Moinuddin
Ranch Hand

Joined: Mar 19, 2005
Posts: 85
Hi all,
I am using jboss4.0.3spi with mysql 4.1.2.

For some strange reason, my transactions are not rolling back properly. Say I am creating an Entity bean at the beginning of a business method and at the end of that method, i am rolling back the transaction. But the entity remains in the db(i find it when I check the db manually!!)

My tables for CMP entity beans are created by jboss while deploying the ejb.

I haven't changed any default Transaction manager property of jboss. So I am expecting the default in memory transaction manager will be working.I am using CMT for all my beans. I have set all transaction attribute to Required for all the methods of all my beans in the <assembly-descriptor> part.

Is there anything else I need to do to make the it work? How do I see the logs related to transaction. I am in complete darkness.
please help.
Regards,
Sajid
Sajid Moinuddin
Ranch Hand

Joined: Mar 19, 2005
Posts: 85
Ok,
now i'm sure...the problem bolongs to mysql. When I deployed the same ejbs in a jboss with hsqldb support, they worked just fine...
Now, What do I have to do to make mysql transaction aware??

thanks in advance...
Sajid
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Not all MySQL database engines support transactions. I forget which one doesn't - you should check the docs to make sure you are using the correct database engine.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jboss+mysql : transaction not rolling back properly!!!