File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Sajid Moinuddin
Ranch Hand
Posts: 85
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 85
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic