Hi
You don't need to declare the database name after @ bec's @
automatically recognise the database by default. You may use the db name if
you want to.
Try out.
Neeraja
-----Original Message-----
From: Doody, John <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, April 15, 1999 12:33 PM
Subject: Re: SOS = JDBC: Problem Loading Driver... HELP NEEDED.. BADLY...
>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
___________________________________________________________________________
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
