File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Regarding the Connection interface Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Regarding the Connection interface" Watch "Regarding the Connection interface" New topic

Regarding the Connection interface

nandy desikan

Joined: Apr 02, 2007
Posts: 10
Hi ,

I have been a java developer for long and yet there is one question that struck my mind today.
The java.sql.Connection is an interface. Agreed. There is a method named commit() which explicitly commits all transactions made(considering autocommit is false).
This commit() in the connection interface does not implement anything, I am very curious to know what happens when this commit() is called.

There is something called System Global Area(SGA) which is a shared random access memory (RAM) allocated by oracle to manage connection pooling, caching ,etc.
So, when we call the commit method of the connection interface, does any thing happen in the java pool in the sga I mentioned above.

This question may be trivial to many experts, but I am found searching for an answer. If anyone finding time , can you please answer this.

Jan Cumps

Joined: Dec 20, 2006
Posts: 2562

Connection is an interface,
but the class you get from your JDBC jars when you get a connection is (has the type of) a concrete Java class.
And you call the commit() method of that concrete Java class.

and then I have to admit that I know nothing whatsoever of the SGA

OCUP UML fundamental and ITIL foundation
nandy desikan

Joined: Apr 02, 2007
Posts: 10
Thanks a lot for clarifying!!
so an object reference of type Connection interface will be type cast over the implementation class (Oracle connection)_plain old java principle
Cool!! Thanks. This was digging my mind since Friday ...


Prashanth Mohan

Joined: Apr 10, 2010
Posts: 1
This is a very helpful thread..Came to know a very Important point from this..Thanks Guys..
jQuery in Action, 3rd edition
subject: Regarding the Connection interface
jQuery in Action, 3rd edition