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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle JDBC driver
>Date: Wed, 14 Mar 2001 01:20:23 -0800
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mai huynh
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).