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/
