You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Gary Efraín Laredo Chacón <la...@pucp.edu.pe> on 2006/05/22 23:30:32 UTC
Transaction Ibati MySql don't work
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/
Re: Transaction Ibati MySql don't work
Posted by Jerome Gagner <ph...@gmail.com>.
What's in y our SqlMapConfig
On 5/22/06, Gary Efraín Laredo Chacón <la...@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/
>
>
Re: Transaction Ibati MySql don't work
Posted by Larry Meadors <lm...@apache.org>.
Are the tables using innodb?
On 5/23/06, Jerome Gagner <ph...@gmail.com> wrote:
> What version of the MySQL JDBC driver are you using? Try turning on
> debug for java.sql and see what you're really getting.
>
> On 5/23/06, Gary Efraín Laredo Chacón <la...@pucp.edu.pe> wrote:
> >
> >
> > 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 <mr...@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 <la...@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/
> >
> >
>
Re: Transaction Ibati MySql don't work
Posted by Jerome Gagner <ph...@gmail.com>.
What version of the MySQL JDBC driver are you using? Try turning on
debug for java.sql and see what you're really getting.
On 5/23/06, Gary Efraín Laredo Chacón <la...@pucp.edu.pe> wrote:
>
>
> 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 <mr...@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 <la...@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/
>
>
Re: Transaction Ibati MySql don't work
Posted by Gary Efraín Laredo Chacón <la...@pucp.edu.pe>.
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 <mr...@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 <la...@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/
Re: Transaction Ibati MySql don't work
Posted by Brandon Goodin <br...@gmail.com>.
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 <mr...@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 <la...@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/
>
>
RE: Transaction Ibati MySql don't work
Posted by mrEdmundo <mr...@uko2.co.uk>.
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 <la...@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/
Re: Transaction Ibati MySql don't work
Posted by Gary Efraín Laredo Chacón <la...@pucp.edu.pe>.
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 <la...@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/
Re: Transaction Ibati MySql don't work
Posted by Brandon Goodin <br...@gmail.com>.
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 <la...@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/
>
>