ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Efraín Laredo Chacón <laredo...@pucp.edu.pe>
Subject Re: Transaction Ibati MySql don't work
Date Tue, 23 May 2006 05:08:36 GMT


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