This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 1121

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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: oracle 9i - commit dependent on driver ?
 
Similar Threads
Doubt in Transaction
Problem:(Urgent ) 2 Phase Commit by WebSphere on Oracle database and MQ Series
connection object
problem with XA driver
XA vs non-XA