Driver Type

[Pratik Chhichhia]

Can anyone please let me know which driver type category "ojdbc5.jar" falls under.
using the DB as Oracle 11g.

Thanks in advance,

Pratik

[prakash pawar]

hi

are you asking the DriverManager Class ??

[Jan Cumps]

Welcome to JavaRanch, Pratik.

It depends on the connection string you are using. Several types are bundled inside this jar.

From Oracle:

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
is installed.

- 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".

Regards, Jan

[Pratik Chhichhia]

Hi jan,

Thanks.

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.

Thanks again,
Pratik

Jan Cumps wrote:Welcome to JavaRanch, Pratik.

It depends on the connection string you are using. Several types are bundled inside this jar.

From Oracle:

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
is installed.

- 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".

Regards, Jan

[Pratik Chhichhia]

Hi prakash,

Thanks for the reply.

Yes, exactly.

I am using following props to connect.
driver.class.name = oracle.jdbc.driver.OracleDriver
url = jdbcracle:thin:@ipaddr:1521:testdb

Can you throw some light relevant to this ?

Thanks again.
Pratik

prakash pawar wrote:hi

are you asking the DriverManager Class ??