Your error messages was not clear, but when I was working with oracle and
jdbc I remember the following:
// You must put a database name after the @ sign in the connection URL.
// You can use either the fully specified SQL*net syntax or a short cut
// syntax as <host>:<port>:<sid>. The example uses the short cut syntax.
Connection conn =
DriverManager.getConnection
("jdbc:oracle:thin:@dlsun511:1721:dbms733",
"scott", "tiger");
However, it seems more like a classpath issue.
> Cheers,
>
>
> Tammam Al-Hamwy
> Software Engineer
> IBM Corp.
>
>
> Felix Guerrero <[EMAIL PROTECTED]> on 04/15/99 10:05:33 AM
>
> Please respond to [EMAIL PROTECTED]
>
> To: [EMAIL PROTECTED]
> cc: (bcc: Tom Al-Hamwy/Toronto/IBM)
> Subject: SOS = JDBC: Problem Loading Driver... HELP NEEDED.. BADLY...
>
>
>
>
>
> Hi,
>
> I am trying to access an oracle database in an Unix Machine from my
> machine. However I keep getting an error message.. the value of the
> message is "oracle.jdbc.driver.OracleDriver" ( the code to instantiate
> the driver an open the connection is below).
>
> My specs are the following:
> 1) OS = Windows 98
> 2) Oracle Client Version = 8.0.5
> 3) Web Server = Sun's Java web Server (the server is running on my
> machine)
> 4) Development tool = Metrowerks Codewarrior 4.0
> 5) JDK = 1.2
> 6) JSDk = 2.0
>
>
> My Questions are:
> 1) Does the driver have to be on my machine or the machine in which the
> database resides (I have installed Oracle again... and selected the
> option of installing the JDBC drivers... so I know they are there... or
> is there any other way in which I can double check?
> 2) Is there something that I have to do with codewarrior? I was
> reading that I had to add the Classes111 file to my Classpath which I
> had done but nothing seems to work.
>
> Please... give me any pointers... Thanks in advance.
>
>
> try {
> //Load(and therefore register the oracle driver
> Class.forName("oracle.jdbc.driver.OracleDriver");
>
>
> // Get a connection to the database
> con =
> DriverManager.getConnection("jdbc:oracle:thin:mydatabase","xx","xxxx");
>
>
> // Create a statement object
> stmt = con.createStatement();
>
> // Execute and SQL query and get a resultSet
> rs = stmt.executeQuery("SELECT NAME,LOGIN FROM MYUSERS");
>
>
>
>
> Thanks.
>
> Felix.
> _____________________________________________________
>
> Felix Guerrero
> Multimedia Technologist
> ITS (Information Technology Services)
> IACC Building Room 246
> North Dakota State University
> Fargo, ND 58105
> Ph. Office: (701) 231 6284
> Fax: (701) 231 8541
> Home: 701 280-1995
> ____________________________________________________
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
