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.
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.