ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Efraín Laredo Chacón <laredo...@pucp.edu.pe>
Subject Re: Transaction Ibati MySql don't work
Date Tue, 23 May 2006 14:04:39 GMT


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 : brandon.goodin@gmail.com
Para : user-java@ibatis.apache.org
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 <mrEdmundo@uko2.co.uk> 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:laredo.ge@pucp.edu.pe]
>> Sent: 23 May 2006 06:09
>> To: brandon.goodin@gmail.com
>> Cc: user-java@ibatis.apache.org
>> 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 : brandon.goodin@gmail.com
>> Para : user-java@ibatis.apache.org, laredo.ge@pucp.edu.pe 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 <laredo.ge@pucp.edu.pe> 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/


Mime
View raw message