• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
HI,

the scenario you described cannot work until you use INNODB and the appropriate MySQL JBoss classes.
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic