Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Driver Type

 
Pratik Chhichhia
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi

are you asking the DriverManager Class ??
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic