Implementation of Interfaces

[sridhar lakka]

Hi All,
Thanks a lot in advance.
In java.sql package, we will have almost all are interface like Connection, Statment, ResultSet.
In normal JDBC program we will use directly those interfaces and methods, But where we have the actual implementation?
I have seen rt.jar also, which is contaning just interface, but where is implemented one.

Regards
Sree

[Rahul Bhattacharjee]

The implementation of those interfaces you can find in the driver jar of the respective database.

[Raghavan Muthu]

If at all you don't find the actual source files, try getting the source files ('src' - general term everyone follow) from the respective database driver vendors.

[sridhar lakka]

Thanks a lot for your reply.
However, without setting any classes12.jar or any other jar file a normal JDBC code which uses JdbcOdbcSriver will works fine?
And I tried by extracting the classes12.jar file clasess, there I could not find any implementation, please tell me the exact name of the class which is implemented.

[Rahul Bhattacharjee]

oracle.jdbc.driver.OracleDriver should be the one implementing Driver interface.

[Jan Cumps]

However, without setting any classes12.jar or any other jar file a normal JDBC code which uses JdbcOdbcDriver will works fine?

Yes. It will work.

Prefer to use the vendors driver if it's available.


Regards, Jan

[Paul Sturrock]

Sun don't recommend you use the JDBC-ODBC bridge for much:

The JDBC-ODBC Bridge driver is recommended for use in prototyping efforts and for cases where no other JDBC technology-based driver exists. If a commercial, all-Java JDBC driver is available, we recommend that it be used instead of the Bridge.

(from Sun's JDBC docs)

[sridhar lakka]

Thanks a lot for replies,
However, Where I can find that Implemented class if it allows with normal JdbcOdbcDriver.
I have seen by extracting ojdbc14.jar file.

Regards,
Sreedhar