Are the tables using innodb?
On 5/23/06, Jerome Gagner <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 : [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/
>
>
