Re: Weired problem when using serializable transaction in 10g

From: Oliver Zeigermann <oliver_at_zeigermann.de>
Date: Wed, 16 Jun 2004 16:59:32 +0200
Message-ID: <2jb5kgFvbbviU1@uni-berlin.de>

Bricklen wrote:

> Jim Kennedy wrote:
> 

>> You don't need to close the statement and reissue it. You can just
>> update
>> the bind variable and execute it again. Much more efficient. Since you
>> can't reproduce this in SQLPlus then the problem is probably in the Java.
>> Are you using connection pooling from some application server so that
>> each
>> statement is a different connection? That might give you odd results.
>> Since you didn't commit the delete then another session wouldn't see the
>> rows deleted.
>> Jim

> 
> 
> I haven't been following this thread so this may or may not be relevant, 
> but in perl's DBI autocommit option is (by default) turned on. Perhaps 
> the statement is (or isn't, depending) autocommitting between executions?

Connection is set to autocommit false, but this should not make any difference for the problem, am I wrong?

Thanks for helping!

Oliver Received on Wed Jun 16 2004 - 09:59:32 CDT