Hi all
Apologize for asking a generic problem.

I've just got strange error using Hibernate 3.0 on Resin 3.0.14 Professional with MySQL 5.0. I've had a Transaction that insert into multiple tables lets say,

insert into table a
consists of multiple rows
based on value on the first insert
insert into table b
consists of multiple rows
insert into table c
consists of multiple rows

I've used rollback on exception.

What funny is sometimes there are some rows missing between insertion but it is not always happened and there is no specific pattern. Only happens on couple of transaction among hundreds of them per day. No exception on resin console.

Is there any general issue with MySQL 5.0 that I have to aware of? Say, support for commit in MySQL 5.0.

I've read Platform Specific Issues but there is no indication for this problem.

Thanks very much
Endang