aspose file tools*
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
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: 1135

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 agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle 9i - commit dependent on driver ?