File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Which driver to use Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Which driver to use" Watch "Which driver to use" New topic

Which driver to use

Neha Sharma
Ranch Hand

Joined: Jul 13, 2001
Posts: 126
I�m doing an application on websphere 4.0 , I want to install oracle JDBC driver on my machine I have oracle 8I on the server while my machine(Client) have Oracle Ver. 7
From the documentation of oracle I cannont make out which JDBC driver I should install.
I�m pasting the Oracle�s document here.
These are the driver versions in the 8.1.7 release:
- JDBC OCI Driver 8.1.7 Client-side JDBC for use on a machine where OCI 8.1.7 is installed.
- JDBC Thin Driver 8.1.7 100% Java client-side JDBC for use in applets and applications.
- JDBC Thin Server-side Driver 8.1.7 JDBC for use by Java Stored Procedures or by Java CORBA objects running in Oracle 8.1.7. This driver is typically used in a middle tier server.
- JDBC Server-side Internal Driver 8.1.7 Server-side JDBC for use by Java Stored procedures or by Java CORBA objects running in Oracle 8.1.7. This driver used to be called the "JDBC Kprb Driver".
Or should I use Oracle 7 JDBC OCI and JDBC Thin Drivers

rajesh purohit
Ranch Hand

Joined: May 02, 2001
Posts: 33
ur jdbc driver will be used which is present on the server (web server) and the server version which supports to that.
so if u have oracle 8i use the oracle 8i driver.

bye for now
Rajesh Purohit
visit me at

Bye for Now<P>Rajesh Purohit<BR>INDIA
Desai Sandeep
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
You should use Oracle thin Drivers unless you want to connect on the server side, in which case you should use Oracle server-side kprb drivers.
Hope this helps,
SCJP2, OCSD(Oracle JDeveloper),OCED(Oracle Internet Platform)
I agree. Here's the link:
subject: Which driver to use
It's not a secret anymore!