George McKinney,
Thank you. Your reply realy helped me. Now the jdbc works fine.
Thanks again,
Jack Li
-----Original Message-----
From: George McKInney [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 12:28 PM
To: [EMAIL PROTECTED]
Subject: RE: oracle JDBC doesn't work
I think that (not being a DB guru):
> Connection con =
> DriverManager.getConnection("jdbc:oracle:thin:storedb",
> "username", "password");
> }
should be more like:
...
DriverManager.getConnection("jdbc:oracle:thin:@storedb",
...
note the '@' between "thin:" and "storedb" (and the colon is necessary)
Our setup uses (though the format above may work for you):
"jdbc:oracle:thin:@abc.def.com:1521:SID"
where:
abc.def.com is the machine name
1521 is the port to connect to
SID is the database identifier.
Hope this helps.
George McKinney, Developer
tantalus communications inc.
500-1122 Mainland Street
Vancouver, BC, Canada V6B 5L1
[EMAIL PROTECTED]
Direct 604.726.6753
Main 604.609.0700
Fax 604.609.0705
www.tantalus.com
"When eBusiness experience counts."
> -----Original Message-----
> From: Jack Li [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 7:32 AM
> To: [EMAIL PROTECTED]
> Subject: oracle JDBC doesn't work
>
>
>
> I got message "Connection refused: no further information".
> Here are the
> settings:
>
> 1. We are using Oracle 7.3. The database server name is storedb.
> 2. I downloaded oracle jdbc driver from Oracle.com. The
> downloaded driver is
> Oracle 7 driver for NT. It has classes102.zip and
> classes111.zip and two
> dlls.
> 3. I put calsses111.zip into c:\jdk1.3\bin and add "c:\jdk1.3\bin" to
> CLASSPATH and PATH
> 4. test the connection in jsp as:
> try{
> DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());
> Connection con =
> DriverManager.getConnection("jdbc:oracle:thin:storedb",
> "username", "password");
> }
> catch(SQLException e){
> out.println(e.getMessage());
> }
>
> The username and password are good. I can make connection
> using jdbc-odbc
> bridge.
> What's the problem do I have with oracle JDBC?
>
> Thanks,
> Jack Li
>
> -----Original Message-----
> From: Bryant, William [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 9:21 AM
> To: [EMAIL PROTECTED]
> Subject: RE: JDBC driver for oracle
>
>
>
>
> You can get the JDBC drivers from Oracle.com. Select
> download, then choose
> 'JDBC drivers' from teh drop down list. You will need a free
> oracle technet
> login.
>
> ... Mike
>
> -----Original Message-----
> From: Jack Li [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 9:11 AM
> To: [EMAIL PROTECTED]
> Subject: JDBC driver for oracle
>
>
> Hi,
>
> Where can I have a free JDBC driver for oracle?
>
> Thanks,
> Jack
>
>
>
