I would strongly encourage you to learn about MySQL when you plan to use it ;-).
MySQL has different table formats. The two most popular are MyISAM and InnoDB. InnoDB supports transactions. MyISAM does NOT support transactions. However, if you are using MyISAM it will not tell you that it does not support transactions. It simply acts as though it does and then doesn't do it. Here as a couple links that will assist you: http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html Brandon On 5/23/06, Gary Efraín Laredo Chacón <[EMAIL PROTECTED]> wrote:
Hellow, I am trying this, but don\'t work, the sqlMapConfig 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=\"true\"/> <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.com:3306/data_base\"/> <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. What is InnoDB? Thanks. ------ Mensaje original ------- De : [EMAIL PROTECTED] Para : [email protected] Fecha : Tue, 23 May 2006 16:54:07 +0200 Asunto : RE: Transaction Ibati MySql don\'t work >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/ > ___________________________________________________________________ Si desea recibir, semanalmente, el Boletín Electrónico de la PUCP, ingrese a: http://www.pucp.edu.pe/boletin/
