These are the driver versions in the 11R1 release:
- JDBC Thin Driver 11R1
100% Java client-side JDBC driver for use in client applications,
middle-tier servers and applets.
- JDBC OCI Driver 11R1
Client-side JDBC driver for use on a machine where OCI 11R1
- JDBC Thin Server-side Driver 11R1
JDBC driver for use in Java program in the database to access
remote Oracle databases.
- JDBC Server-side Internal Driver 11R1
Server-side JDBC driver for use by Java Stored procedures. This
driver used to be called the "JDBC Kprb Driver".
OCUP UML fundamental and ITIL foundation
Joined: Mar 30, 2010
I am using following 2 properties at the time of connecting to oracle.
driver.class.name = oracle.jdbc.driver.OracleDriver
url = jdbcracle:thin:@ipaddr:1521:testdb
Moreover, I referred docs on sun.com which says following:
"A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS.
Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine."
Can you throw some more light on above reference from the doc keeping the url and driver class in the middle.
Jan Cumps wrote:Welcome to JavaRanch, Pratik.
It depends on the connection string you are using. Several types are bundled inside this jar.