JTA, JBoss and rollback

orichaud · **Posted:** Tue Jun 08, 2004 9:02 am

Hi all,

I have managed to integrate Hibernate as a Jboss service and it rocks. My underlying database is mySQL. But, I have a problem : I can't rollback.

When I rollback by calling the rollback method on my current transaction, nothing happens. Objects that were created are not removed from the database. I don't understand what's happening and my system ends up in an unstable state since the database does not reflect the rollback. For short, everything happens as if the autocommit mode is turned on.

Regards.

ko5tik · **Posted:** Tue Jun 08, 2004 9:12 am

well, did it happened to you that autocommit mode is just turned on?
AFAIR, jboss datasources and hibernate suffer from this problem.

dig into mysql docs, there is information how to turni it off through parameter in connection string.

michael · **Posted:** Tue Jun 08, 2004 9:13 am

Are you using InnoDB tables (you should)?

orichaud · **Posted:** Tue Jun 08, 2004 9:30 am

Well I don't whether and how to turn off the autocommit mode, but I'm quite sure something like that is happening. Data are written to persistent storage before the transaction ends. And I don't think hibernate issue sql commands to compensate.

As far a I understand, it is a problem with mySQL.

Regards.

orichaud · **Posted:** Tue Jun 08, 2004 9:38 am

michael wrote:

Are you using InnoDB tables (you should)?

Sorry, but my knowledge of mySQL is poor. How can I check whether these tables are InnoDB tables?

orichaud · **Posted:** Tue Jun 08, 2004 9:50 am

michael wrote:

Are you using InnoDB tables (you should)?

My tables are of type MyISAM. And I can do little against that as my tables are generated using hibernator the Eclipse plugin.

michael · **Posted:** Tue Jun 08, 2004 10:01 am

MyISAM Tables do not support transactions

RobJellinghaus · **Joined:** Thu Jan 08, 2004 6:17 pm **Posts:** 278

orichaud wrote:

michael wrote:

Are you using InnoDB tables (you should)?

My tables are of type MyISAM. And I can do little against that as my tables are generated using hibernator the Eclipse plugin.

You must add the following to your MySQL.ini:

[mysqld]
...
default-table-type=InnoDB

This will make all your tables be InnoDB no matter who generates them, which is what you want if you want your tables to be transactional.

If you are on Linux I do not know how you set the default table type.

Cheers,
Rob

orichaud · **Posted:** Thu Jun 10, 2004 7:02 pm

Thanks it works ! I can now create InnoDB tables.

Problem : now I'm having problems with foreign keys when deleting an object. mySQL refuses to commit and Hibernate throws the following exception :

Code:

net.sf.hibernate.JDBCException: Could not synchronize database state with session: General error, message from server: "Cannot delete or update a parent row: a foreign key constraint fails". 

The foreign keys is generated by hibernate to handle binary associations.

I've posted http://forum.hibernate.org/viewtopic.php?t=931640

RobJellinghaus wrote:

orichaud wrote:

michael wrote:

Are you using InnoDB tables (you should)?

My tables are of type MyISAM. And I can do little against that as my tables are generated using hibernator the Eclipse plugin.

You must add the following to your MySQL.ini:

[mysqld]
...
default-table-type=InnoDB

This will make all your tables be InnoDB no matter who generates them, which is what you want if you want your tables to be transactional.

If you are on Linux I do not know how you set the default table type.

Cheers,
Rob

[url][/url]