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 Thu, 25 May 2006 02:33:43 GMT


Thanks!!!.

My program work rigth with this convination!!!.


Gary


------ Mensaje original -------
De : hans@beemsterboer-software.nl
Para : user-java@ibatis.apache.org
Fecha : Wed, 24 May 2006 18:54:00 +0200
Asunto : Re: Transaction Ibati MySql don\'t work
>Hi Gary,
>
>JDBC transactions should work with MySQL. This is not an iBatis problem.
>
>- InnoDB is the Table engine type:
>
>CREATE TABLE `table` (
>... columns ...
>) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
>I have successfully performed transactions with the following environment:
>- MySQL 5.0.4
>- JDK 1.4
>- iBatis 2.0
>- MySQL Connector-J version 3.2
>
>Use JDBC Driver classname com.mysql.jdbc.Driver
>
>Good luck,
>Hans.
>
>Gary Efraín Laredo Chacón wrote:
>>
>>
>> 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 : n.beekman@wis.nl
>> Para : user-java@ibatis.apache.org
>> 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:laredo.ge@pucp.edu.pe] Sent: 
>>> dinsdag 23 mei 2006 16:05
>>> To: brandon.goodin@gmail.com
>>> Cc: user-java@ibatis.apache.org
>>> 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 : 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 <mrEdmundo@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 <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/


Mime
View raw message