Transaction rollback doesn't work for EJB CMP remove

[canghel]

Hi,

I encounter the following problem in the following scenario:
1. I start a new transaction
2. I find an EJB CMP entity calling findByPrimaryKey on the home interface (the entity is successfully found)
3. I call remove on the entity
4. I call rollback on the current transaction via transaction manager and I expect that the deletion I did in step 3 is undone
5. I check to see if I still can get the entity by calling again findByPrimaryKey. The problem is that the entity is no more found meaning that the rollback did not work.

In case of store the rollback works fine only in case of remove the rollback doesn't work. I do not get any exceptions.

I am using JBoss 3.2.6RC1 and MySQL for the Database. Does anyone know why the rollback doesn't work in case of remove ???

Thanks in advance,
Claudiu

[canghel]

Hi,

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 ?

thanks,
Claudiu

[distributed]

hello ppl,

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

The problem:
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..
vik
PS: Claudiu.. should we post this under JCA/JBoss topic also ?

[aloubyansky]

Not a JBoss problem. Read MySql docs and post to user forums.

[distributed]

oops !
i am really sorry. didnt notice that Claudiu had posted to the devel forum.
my mistake.
vik

[canghel]

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,
Claudiu

[distributed]

discussion continued at:
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=54234

vik