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/
