Thank you very much for the info. We will do those changes. Best regards,
Hilde -----Original Message----- From: Sven.Boden [mailto:[EMAIL PROTECTED] Sent: Thursday, February 23, 2006 3:16 PM To: [email protected] 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. Regards, Sven >----- Oorspronkelijk bericht ----- >Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Verzonden: donderdag, februari 23, 2006 02:28 PM >Aan: [email protected] >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). We >>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 > > >
