• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle 9i - commit dependent on driver ?

 
pendse anagha
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic