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

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

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

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.