Session Bean - BMT - MySQL not rolling back a CMP create()

[toto_fr]

Hi All,

Between a ut.begin() and ut.rollback() in my session bean I do a CMPHome.create().
Any later setXXX() on that CMP would be rolledbacked but in the end the first row created (with create()) is still in the DB.
What's wrong there ?
Am I missing something ?
Any hint would be highly appreciated!

- Anthony

[kv_moj]

Hi,

The default format of tables created in mySql is ISAM which is non-transactional.
If this is what's happening on your system, then you need to convert your tables to either BDB or InnoDB.

I've not used BDB but InnoDB format seems to work fine in my setup.

To convert your tables get a sql command line and for each table enter:

ALTER TABLE dbName.tableName TYPE=INNODB;

kv.