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

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.

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?

That's certainly what I thought when I studied up on the different autocommit modes and why I was so nervous when I found out that the app server was running with autocommit set to 0.


Options: ReplyQuote

Written By
April 01, 2005 09:53AM
April 01, 2005 10:29AM
Re: autocommit override
April 01, 2005 11:31AM
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.