after further investigations I noticed that the problem also occurs in case of store. So it seems that transaction rollback doesn't work for CMP EJB when MySQL is used for the database.
I changed the DB to Hypersonic and the rollback worked fine.
Has anyone any idea why the rollback doesn't work for MySQL. Are there any special settings to be done? Is anyone using CMP EJB and MySQL ?
I am having exactly the same problem.. in fact three different people have encountered it here at my company. so you r not alone, Claudiu. :)
Transactions are just not rolledback when using CMP and CMT (with attr 'Required') with mysql.
I have a simple Entity bean being created through a session bean func. .. Now after creating the entityobject in the session func i am throwing a EJBException... which should cause the entity creation to rollback... but it doesnt. (with hypersonicDB it does a perfect rollback)
Maybe there is something in the mysql datasource configuration that i left out. If it would be useful.. i can upload my code and the xmls on the net.
Does not using a XADatasource have anything to do with this ?
i am using Jboss 3.2.3 with mysql 4.0.14 with the 3.0.15 jdbc connectors for mysql.
any ideas ? anyone..
PS: Claudiu.. should we post this under JCA/JBoss topic also ?
Not a JBoss problem. Read MySql docs and post to user forums.
i am really sorry. didnt notice that Claudiu had posted to the devel forum.
I am also sorry for posting this on a wrong forum. But the problem is still there.... I think we should move the discussion on the user forum. Vik, thanks for your response. Let us hope that we can find something on the MySQL docs (Alexey in case you know more please tell us ... on the user forum of course)
Thanks again and please accept my apologies for using a wrong forum,