• Post Reply Bookmark Topic Watch Topic
  • New Topic

mysql and CMT  RSS feed

 
adrian osullivan
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can't get my stateless session bean to rollback CMT transaction for a MySQL 4.0.18. I have tried both com.mysql.jdbc.Driver and the MM Driver, but in both cases, the 'insert' statement is executed immediately, regardless of the transaction.

It works fine on Oracle 9i, using exactly the same bean and same deployment descriptor.

Any ideas?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Some of MYSQL table types are non-transactional (ISAM/MYISAM I think - there's probably more). Make sure your DDL defines the right type.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!