This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes oracle 9i - commit dependent on driver ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "oracle 9i - commit dependent on driver ?" Watch "oracle 9i - commit dependent on driver ?" New topic
Author

oracle 9i - commit dependent on driver ?

pendse anagha
Ranch Hand

Joined: Mar 09, 2005
Posts: 44
Hello ,
I am using oracle 91 and what I am observing is that I create a Connection object - set autocommit as false

Do some db operation ( insert / update )
without explicit commit - I close the connection

I am actually seeing data to persist

So I conclude that on connection.close - an implicit commit seems to happen

Is this being governed by the jdbc driver ?

Regards ,
-anagha
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138
    
    1

Anagha,
You said:

So I conclude that on connection.close - an implicit commit seems to happen

Correct conclusion.

And you asked:

Is this being governed by the jdbc driver ?

No, this is the behaviour of the Oracle database.

I suggest you refer to the Oracle documentation for more details. The documentation is available from:

http://tahiti.oracle.com

Good Luck,
Avi.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: oracle 9i - commit dependent on driver ?
 
It's not a secret anymore!