aspose file tools*
The moose likes JDBC and the fly likes Driver Type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Driver Type" Watch "Driver Type" New topic
Author

Driver Type

Pratik Chhichhia
Greenhorn

Joined: Mar 30, 2010
Posts: 5
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

Joined: Mar 11, 2010
Posts: 42
hi

are you asking the DriverManager Class ??


Regards,
Prakash Pawar.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2499
    
    8

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


OCUP UML fundamental and ITIL foundation
youtube channel
Pratik Chhichhia
Greenhorn

Joined: Mar 30, 2010
Posts: 5
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

Joined: Mar 30, 2010
Posts: 5
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 ??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Driver Type