Simple Hibernate Transaction Rollback test

[karldmoore]

Are you using InnoDB?

[TheStijn]

no I'm not
is that required for transactions?

[karldmoore]

I'm not a MySQL expert but I guess that could be the problem.

To use transactions as demonstrated in the preceding section, you must be using a transaction-safe table type—either InnoDB or BDB. There are various pieces of syntax that will get the same effect.

http://dev.mysql.com/books/mysqlpres...rial/ch10.html

[TheStijn]

tx
I'll try this first thing tomorrow and let you know if it worked.

greetz

[karldmoore]

I'll try this first thing tomorrow and let you know if it worked.

There have been quite a few threads that have been fixed by doing the same thing, hopefully this will be the same in your case .

[mesquite]

Stijn,

If you use JUnit to test the transactions, try to manage your transaction from the testclass instead of the service.

Extend the testclass from AbstractTransactionalSpringContextTests and use the provided TransactionManager from that class instead of managing your transactions from the service.
Maybe there is something wrong with your transactionmanager instance you provide in the service layer.

Try it this way to see if that works.

Koen

[TheStijn]

Are you using InnoDB?

As you probably expected that did the trick!

tx a lot (all of you) for your help!

Stijn

[karldmoore]

As you probably expected that did the trick! tx a lot (all of you) for your help!

Great news, thanks for posting back. Glad it's all working!