wood burning stoves 2.0*
The moose likes JDBC 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
Bookmark "Which driver to use" Watch "Which driver to use" New topic
Author

Which driver to use

Neha Sharma
Ranch Hand

Joined: Jul 13, 2001
Posts: 126
Hi,
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
Thanks
Neha


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 www.geocities.com/rajesh_purohit

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,
Sandeep
SCJP2, OCSD(Oracle JDeveloper),OCED(Oracle Internet Platform)


<b>Sandeep</b> <br /> <br /><b>Sun Certified Programmer for Java 2 Platform</b><br /> <br /><b>Oracle Certified Solution Developer - JDeveloper</b><br /><b>-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java </b><br /><b>-- Object-Oriented Analysis and Design with UML</b><br /> <br /><b>Oracle Certified Enterprise Developer - Oracle Internet Platform</b><br /><b>-- Enterprise Connectivity with J2EE </b><br /><b>-- Enterprise Development on the Oracle Internet Platform </b>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which driver to use
 
Similar Threads
JDBC code for oracle RAC
read from tnsnames.ora file
which JDBC driver to use
thin and oci
Driver Type