MySQL has only supported transactions since 3.23.15. The caveat is that at this version and above, transactions are only truly supported by two different tables types: InnoDB and BDB (see http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Table_types), and those table types are only installed by default in the MySQL-Max (MySQL++) edition. If you want transaction support out of the box, try PostgreSQL. Hope this helps. -- Chris Bonham President/CEO Third Eye Consulting, Inc. [EMAIL PROTECTED] http://www.thirdeyeconsulting.com 317.823.3686 317.823.0353 (FAX) Quoting gilles dodinet ([EMAIL PROTECTED]): > hi.. > i wanted to know the behavior of nested transactions and, while testing, i > noticed a something strange thing.. if i rollback the transaction, changes > are even written to db. is that a known problem with mysql (also 3.23)? > below the code i used : > > //not rolled back > Database db = jdo.getDatabase(); > db.begin(); > Client client = new Client(31, "marsupilami-sensei", 0); > db.create(client); > db.rollback(); > > i had either another question : if i use nested transactions like this : > Database db = jdo.getDatabase(); > Database db2 = jdo.getDatabase(); > > db.begin(); > Client client = new Client(31, "marsupilami-sensei", 0); > db.create(client); > > db2.begin(); > client.setNom("naru-senpai"); //[1] > db2.commit(); > > db.commit(); > > the point [1] is inner the first transaction, right? so there's no really > nested transactions with Castor? am i wrong with theses assumptions? > > -- > gilles > > > _________________________________________________________________ > T�l�chargez MSN Explorer gratuitement � l'adresse > http://explorer.msn.fr/intl.asp > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
