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

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

Original text of this message