As larry said, make sure the tables are InnoDB, easy one to miss. MySQL happily plugs along w/ MyISAM pretending like it does transactions.
On 5/23/06, Niels Beekman <[EMAIL PROTECTED]> wrote:
You specified SetAutoCommitAllowed="false", that instructs iBATIS to leave the default autocommit setting (true) in place, which causes automatic commits, unless an SQLException occurs when executing a statement. Changing it to "true" will cause iBATIS to use the "DefaultAutoCommit" setting. Niels -----Original Message----- From: Gary Efraín Laredo Chacón [mailto:[EMAIL PROTECTED] Sent: dinsdag 23 mei 2006 16:05 To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: Transaction Ibati MySql don't work Thanks, Exactly I want that it does roollbak, but it does not do it, the changes get to persist, without commit. thanks very much ------ Mensaje original ------- De : [EMAIL PROTECTED] Para : [email protected] Fecha : Tue, 23 May 2006 07:35:04 -0500 Asunto : Re: Transaction Ibati MySql don\'t work >Precisely, > >That is why i wanted to see the real code that was being called. The >piece that i saw looked more like a sample than real code. The >endTransaction without a commitTransaction will perform a rollback. >iBATIS does not have an explicit rollback call. Basically, if you call >startTransaction and then endTransaction without a commitTransaction, >it is assumed that there was a problem and the rollback is performed. > >Thanks for the feedback Ed ! > >Brandon Goodin > >On 5/23/06, mrEdmundo <[EMAIL PROTECTED]> wrote: >> Hi, >> >> It\'s a bit difficult to tell from the code sample you\'ve provided, but are >> you calling sqlMap.commitTransaction(); at the end of your updates? >> >> Your code should be: >> >> try >> { >> sqlMap.startTransaction(); >> >> // do your updates >> >> sqlMap.commitTransaction(); >> } >> finally >> { >> sqlMap.endTransaction(); // will rollback if transaction not committed >> } >> >> Regards, Ed. >> >> -----Original Message----- >> From: Gary Efraín Laredo Chacón [mailto:[EMAIL PROTECTED] >> Sent: 23 May 2006 06:09 >> To: [EMAIL PROTECTED] >> Cc: [email protected] >> Subject: Re: Transaction Ibati MySql don\'t work >> >> >> >> Thanks, >> >> The sqlMapConfig.xml file is: >> >> <?xml version=\"1.0\" encoding=\"UTF-8\"?> <!DOCTYPE sqlMapConfig PUBLIC >> \"-//ibatis.apache.org//DTD SQL Map Config 2.0//EN\" >> \"http://ibatis.apache.org/dtd/sql-map-config-2.dtd\";> >> <sqlMapConfig> >> <settings lazyLoadingEnabled=\"true\" cacheModelsEnabled=\"true\" >> enhancementEnabled=\"true\" maxRequests=\"32\" maxSessions=\"10\" >> maxTransactions=\"5\" useStatementNamespaces=\"false\"/> >> <transactionManager commitRequired=\"true\" type=\"JDBC\"> >> <property name=\"SetAutoCommitAllowed\" value=\"false\"/> >> <property name=\"DefaultAutoCommit\" value=\"false\"/> >> <dataSource type=\"SIMPLE\"> >> <property name=\"JDBC.Driver\" value=\"org.gjt.mm.mysql.Driver\"/> >> <property name=\"JDBC.ConnectionURL\" >> value=\"jdbc:mysql://hosting:3306/database\"/> >> <property name=\"JDBC.Username\" value=\"usuario\"/> >> <property name=\"JDBC.Password\" value=\"clave\"/> >> <property name=\"Pool.PingQuery\" value=\"select @@VERSION\"/> >> <property name=\"Pool.MaximumActiveConnections\" value=\"10\"/> >> <property name=\"Pool.MaximumIdleConnections\" value=\"5\"/> >> <property name=\"Pool.MaximumWait\" value=\"1000\"/> >> <property name=\"Pool.QuietMode\" value=\"false\"/> >> </dataSource> >> </transactionManager> >> <sqlMap resource=\"maps/Cliente.xml\"/> >> <sqlMap resource=\"maps/Parametro.xml\"/> </sqlMapConfig> >> >> Please help me >> >> >> ------ Mensaje original ------- >> De : [EMAIL PROTECTED] >> Para : [email protected], [EMAIL PROTECTED] Fecha : Mon, 22 >> May 2006 20:30:03 -0500 Asunto : Re: Transaction Ibati MySql don\'t work >> >Please provide how you have proven that the transactions are not >> >working. Also, like Jerome stated, please post all configs and actual >> >java code involved when asking for support. >> > >> >Thanks, >> >Brandon >> > >> >On 5/22/06, Gary Efraín Laredo Chacón <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> >> >> Please help me >> >> >> >> I am used jdk1.5 + MySql 4.1.x + Ibatis 2.0 + JConnector 3.1.12 >> >> (3.1.8a) and don\'t work transactions (allways commit for each >> >> statement), my MySql database is a hosting on the other place, sample of >> code: >> >> >> >> ClienteBean cliente = new ClienteBean(); Reader reader1 = >> >> Resources.getResourceAsReader(\\\"maps/sqlMapConfig.xml\\\"); >> >> SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader1); >> >> >> >> sqlMap.startTransaction(); >> >> sqlMap.update(\\\"updateCorrelativo\\\",\\\"000\\\"); //update table >> >> here allways sqlMap.endTransaction();//but It coult be rollbak >> >> >> >> >> >> >> >> >> >> >> >> ___________________________________________________________________ >> >> Si desea recibir, semanalmente, el Boletín Electrónico de la PUCP, >> ingrese a: >> >> http://www.pucp.edu.pe/boletin/ >> >> >> >> >> > >> >> >> ___________________________________________________________________ >> Si desea recibir, semanalmente, el Boletín Electrónico de la PUCP, ingrese >> a: >> http://www.pucp.edu.pe/boletin/ >> >> > ___________________________________________________________________ Si desea recibir, semanalmente, el Boletín Electrónico de la PUCP, ingrese a: http://www.pucp.edu.pe/boletin/
