ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Transaction Ibati MySql don't work
Date Tue, 23 May 2006 12:35:04 GMT
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/
>
>

Mime
View raw message