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
Which mysql table type are you using? Tables stored using MYIASM (the default mysql storage engine) are NOT transactional. Be sure you are using the INNODB storage engine.
See: http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html