In Oracle there a few things that could affect you: 1) You never see data outside of your own session which is not committed 2) The moment the query is opened determines the result you will see. I open a query, wait for 5 minutes. In these 5 minutes someone erases all rows in my table and commits. After that I start reading rows from my query and I still see all rows. This last thing probably hits you.
Regards, Sven >----- Oorspronkelijk bericht ----- >Van: cmose [mailto:[EMAIL PROTECTED] >Verzonden: woensdag, augustus 2, 2006 01:43 AM >Aan: [email protected] >Onderwerp: Re: Phantom data results?? > > >Gwyn, >that's an interesting insight regarding isql*plus, I'll have to look into >that. I was under the impression that the inserts are "committed" in fairly >short order, e.g., I think in the past I've done some similar tests with >ibatis that involved prepopulating some tables using isql*plus and I had no >problems. > >I'm positive that login information, tables, and etc., are all identical >between using isql*plus and ibatis. >-- >View this message in context: >http://www.nabble.com/Phantom-data-results---tf2036087.html#a5605220 >Sent from the iBATIS - User - Java forum at Nabble.com. > > >
