Re: jdbc: PLEASE HELP

From: <bilal_z_at_my-deja.com>
Date: 2000/03/20
Message-ID: <8b5mro$k7a$1@nnrp1.deja.com>#1/1

The java snippet:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:207.159.74.75:1521:destro",

username,password);

The listener.ora file:

# D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:d:\Oracle\Ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 207.159.74.75)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\Oracle\Ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = destro)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = destro)

    )
  )

I am running my app off Textpad.
Thanks very much for your help.

In article <38D2A313.4C83238C_at_rationalconcepts.com>, "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote:

> Hi,
> please post the java snippet where you are registering the driver and
> making the connection, the listener.ora file for your db, and the
> execution command you are using to start your app (i.e. java
> -classpath...).
>
> cindy
>
> bilal_z_at_my-deja.com wrote:
>
> > I cannot get a jdbc connection to our oracle 8i db. I'm using a thin
> > driver and keep getting:
> >
> > java.sql.SQLException: The Network Adapter could not establish the
> > connection
> >
> > All the connection parameters are correct. I know there has to be a
> > simple solution to this. Can someone please help me?
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 20 2000 - 00:00:00 CST