-
1. Re: Transaction rollback doesn't work for EJB CMP with MySQL
canghel Sep 17, 2004 3:44 AM (in response to 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 -
2. Re: Transaction rollback doesn't work for EJB CMP with mysql
distributed Sep 17, 2004 4:24 AM (in response to canghel)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 ? -
3. Re: Transaction rollback doesn't work for EJB CMP remove
aloubyansky Sep 17, 2004 4:35 AM (in response to canghel)Not a JBoss problem. Read MySql docs and post to user forums.
-
4. Re: Transaction rollback doesn't work for EJB CMP remove
distributed Sep 17, 2004 5:03 AM (in response to canghel)oops !
i am really sorry. didnt notice that Claudiu had posted to the devel forum.
my mistake.
vik -
5. Re: Transaction rollback doesn't work for EJB CMP remove
canghel Sep 17, 2004 5:27 AM (in response to 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 -
6. Re: Transaction rollback doesn't work for EJB CMP remove
distributed Sep 17, 2004 5:45 AM (in response to canghel)discussion continued at:
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=54234
vik