Re: autocommit override
Posted by: John McGowan
Date: April 01, 2005 11:47AM

John McGowan wrote:
> I looked into the various isolation levels when I
> first discovered the problem I had, but didn't
> know for sure if it would solve the problem that I
> was having.
>
> I will try setting my server to use READ COMMITTED
> instead of the default.

Initial testing shows that this change was exactly what I needed.

> In the meantime I have a question.
>
> If the app server opens up a connection and sets
> autocommit to 0, Then uses it in a pool and lots
> of various statements are sent to the server. Am
> I missing something here, or is it true that if
> there aren't any commit's done, all those
> statements running the risk of being lost (rolled
> back) if the connection is severed before it is
> allowed to close down cleanly?

I'm now guessing that the different isolation levels would have a differnt effect on how much data you would lose in a situation like this. I think I need to do some more reading on the subject before I know exactly what is going on.

I appreciate any direction you can give me on good sources for this information.

Options: ReplyQuote


Subject
Written By
Posted
April 01, 2005 09:53AM
April 01, 2005 10:29AM
April 01, 2005 11:31AM
Re: autocommit override
April 01, 2005 11:47AM
April 01, 2005 11:57AM
April 01, 2005 02:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.