JDBC Troubles ORA-12222: TNS:
From: Benjamin Leonard <bln_at_info.fundp.ac.be>
Date: Mon, 11 Jan 1999 14:42:16 -0100
Message-ID: <369A1BD8.E9CF71C7_at_info.fundp.ac.be>
here is my code for the connection
import symantec.itools.awt.*;
import emim.bci.dataObjet.*;
public class BCI
{
protected Connection conn;
*constructeur de l'objet bci reprenant la connection
}
Date: Mon, 11 Jan 1999 14:42:16 -0100
Message-ID: <369A1BD8.E9CF71C7_at_info.fundp.ac.be>
here is my code for the connection
package emim.bci;
import java.lang.*; import java.sql.*; import java.security.*;
import symantec.itools.awt.*;
import emim.bci.dataObjet.*;
public class BCI
{
protected Connection conn;
/**
*constructeur de l'objet bci reprenant la connection
- à la base de donnée
*/
public BCI () { try{ // Load Oracle driver DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); // Connect to the remote database conn = DriverManager.getConnection ("jdbc:oracle:oci8:_at_(description=(address=(host=138.22.90.173)(protocol=tcp)
(port=1521))(connect_data=(sid=BCI1)))", "user1", "sfksdk");
} catch (SQLException E) {System.out.println ("error on bci creation:"+E); }
}
/** *constructeur de l'objet bci reprenant une ancienne connection
- à la base de donnée
*/
public BCI (Connection c) { conn = c; }
}
here is the message i receive when i create the object :
error on bci creation:java.sql.SQLException: ORA-12222: TNS: cet
adaptateur
de protocole n'existe pas
I have no problemes for a connection with a oracle client like pl/sql 8 or shéma manager......
i work with oracle 8 Entreprise edition on win nt 4 and client on Win 95 Received on Mon Jan 11 1999 - 16:42:16 CET