Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Usins JDBC to connect to Oracle 8

Usins JDBC to connect to Oracle 8

From: Mike Ryan <mryan_at_blue.ocn.ne.jp>
Date: Wed, 15 Apr 1998 08:57:50 +0900
Message-ID: <3533F7FE.2A56E891@blue.ocn.ne.jp>


I can connect Ok to Oracle 8 using the THIN driver like

Class.forName("oracle.jdbc.driver.OracleDriver"); DriverManager.getConnection("jdbc:oracle:thin:@111.112.113.114:1521:oracle",
"username", "password");

but when I try to use the Oci7 driver I cant connect

Class.forName("oracle.jdbc.driver.OracleDriver"); DriverManager.getConnection("jdbc:oracle:oci7:@Alias", "username",
"password");

Alias is defined in the network/admin/tnsnames.ora and tnsping alial can locate the servet, also sqlplus can connect using the alias.

Another problem, I cant find Oci8 anywhere, does anyone know where I can get it ?

Thanks,
Mike.



Mike Ryan,
TNF Lab.,
416 SoftTown Aoyama,Jingumae,                Tel: 81-3-5413-7235
Shibuya,Tokyo.                               Fax: 81-3-5413-7236
Japan. Received on Tue Apr 14 1998 - 18:57:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US