permaculture playing cards
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!