You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Hi...@ext.cec.eu.int on 2006/02/23 14:28:29 UTC

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