ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hilde.DE-GRA...@ext.cec.eu.int
Subject RE: Strange behaviour Ibatis/Oracle 9i
Date Thu, 23 Feb 2006 14:41:28 GMT
Thank you very much for the info. We will do those changes.

Best regards,


-----Original Message-----
From: Sven.Boden [mailto:list123@pandora.be] 
Sent: Thursday, February 23, 2006 3:16 PM
To: user-java@ibatis.apache.org
Subject: Re: Strange behaviour Ibatis/Oracle 9i

>From a mail of Clinton on the list a couple of weeks ago:

iBATIS will do a rollback by default.  Unfortunately this is a hangover for
legacy drivers (e.g. Sybase) that require a rollback to reset the connection
so that it can be reused.  Try using the DBCP connection pool instead.  If
that doesn't help, try using a container managed transaction.  

As a last resort, you can write your own transaction manager and/or
connector to a different 3rd party connection pool to achieve the behaviour
that you want.  You can use the existing implementations as a guide, or even
as a base for developing your own.  You can configure iBATIS to use your
custom implementations by simply replacing JDBC and SIMPLE with the fully
qualified classnames of your implementations.


>----- Oorspronkelijk bericht -----
>Van: Hilde.DE-GRAEVE@ext.cec.eu.int [mailto:Hilde.DE-GRAEVE@ext.cec.eu.int]
>Verzonden: donderdag, februari 23, 2006 02:28 PM
>Aan: user-java@ibatis.apache.org
>Onderwerp: Strange behaviour Ibatis/Oracle 9i
>>We think we found a problem in the api  of Ibatis.
>>Indeed, we have an application which uses the api IBATIS version 2 to
>>record and retrieve information in a data base Oracle 9i. 
>>Fortuitously, our dBa Oracle noticed that this application produced
>>rollbacks (in all circumstances, even for a request of the select type).
>>don't use transactions for those requests.
>>However, coming from the dB, our application receives correct results.No
>>errors are detected on the Java side neither on the Oracle database. In
>>order to test this theory we made some basic test projects and we obtained
>>the same result.
>>This phenomenon observed implies that it is very difficult to detect.
>>If we use Ibatis in partnership with Spring Framework, this phenomenon of
>>roll back is not present any more.
>>Also, if we use an api JDBC instead of Ibatis, we do not have a roll back.
>>According with our DBa, these roll back cause problems of performance.
>>Can you, confirm  us, a possible problem of this kind, between IBATIS and
>>the data base Oracle.
>	Thanks,
>	Hilde

View raw message