Re: Weired problem when using serializable transaction in 10g

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? Received on Wed Jun 16 2004 - 09:44:39 CDT