Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Sajid Moinuddin
Ranch Hand
Posts: 85
  • 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
 
Marco Barenkamp
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI,

the scenario you described cannot work until you use INNODB and the appropriate MySQL JBoss classes.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sajid Moinuddin, please don't post the same question in more than one topic .
 
Sajid Moinuddin
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry Paul,
I am sorry. But i didn't do it intentionally. However, is it ok if i post the same topic in diferrent groups? or same topic in different group with different caption?
However, My problem was solved when I changed the table type to innodb. Thanks Marco.
regards,
Sajid
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Sajid Moinuddin:
Sorry Paul,
I am sorry. But i didn't do it intentionally. However, is it ok if i post the same topic in diferrent groups? or same topic in different group with different caption?
However, My problem was solved when I changed the table type to innodb. Thanks Marco.
regards,
Sajid


That's quite alright Sajid . We would rather you only create one topic for one question. Otherwise discussions can become difficult to follow.
[ May 12, 2006: Message edited by: Paul Sturrock ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!