Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle JDBC driver
Instead of using the OCI driver, use the thin driver. Your connect string should be something like this, where you replace the 10.10.0.1 with the IP address or host name of the server that the DB is on:
Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@10.10.0.1:1521:myserver",
"admin", "admin");
The OCI drivers require Net8 to be installed, and require quite a few other entries into your Path. Since you don't want the client install, you must use the thin driver.
Sorry that this is a repetition of what a lot of people have already answered, but I felt a single explanation might help?
Diana
-----Original Message-----
Sent: Wednesday, March 14, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L
Here is the code:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn =
DriverManager.getConnection ("jdbc:oracle:oci8:@myserver", "admin", "admin");
This failed when call DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Now after set the classpath=d:\jdbc\lib\classes111.zip. It gives me the
error ORA805.dll not found in the specified path
>From: "Marin Dimitrov" <marin_at_sirma.bg>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Oracle JDBC driver
>Date: Wed, 14 Mar 2001 01:20:23 -0800
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Wednesday, March 14, 2001 00:06
>
>
> >
> > does anyone can tell me where to install Oracle JDBC driver? I looked
>up
> > oracle web site, but they just let me download the zip file and instruct
>how
> > to set the classpath and i still get the error 'unsuitable ddriver"
>
>
>How do u initialize the driver in your application? How do the class name
>and the url look like?
>
>
> Marin
>
>----
>"When someone is seeking, it happens quite easily that he only sees
>the thing that he is seeking; that he is unable to find anything, unable to
>absorb anything, because he is only thinking of the thing he is seeking,
>because he is obsessed with his goal. Seeking means: to have a goal;
>but finding means: to be free, to be receptive, to have no goal. ..."
>
>
> Herman Hesse, "Siddhartha"
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Marin Dimitrov
> INET: marin_at_sirma.bg
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mai huynh INET: mhuynh5_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diana Duncan INET: dduncan_at_arsenaldigital.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Mar 15 2001 - 10:46:12 CST