Re: jdbc: PLEASE HELP

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: 2000/03/20
Message-ID: <38D68385.88CC55E7@rationalconcepts.com>

Oh, silly me...I guess my first question should have been, " is the power on?" ;-)

cindy

bilal_z_at_my-deja.com wrote:

> Still getting the same error. It has something to do with the Listener
> on the server not working.
>
> In article <38D665B8.2898D85D_at_rationalconcepts.com>,
> "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote:
> >
> > --------------3F0E060C73D4E8F9B77ACEEC
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > Hi,
> > the connection call is of the format
> > DriverManager.getConnection ("jdbc:oracle:thin:@<machine name>:<port
> > number>:<sid>", dbuser, dbpassword);
> >
> > so in your case it should be
> >
> > DriverManager.getConnection

("jdbc:oracle:thin:@207.159.74.75:1521:destro",
> > username, password);
> >
> > cheers,
> > cindy
> >
> > bilal_z_at_my-deja.com wrote:
> >
> > > 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.
> >
> > --------------3F0E060C73D4E8F9B77ACEEC
> > Content-Type: text/html; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> > <html>
> > Hi,
> >   the connection call is of the format
> >      DriverManager.getConnection
("jdbc:oracle:thin:@<machine
> > name>:<port number>:<sid>", dbuser, dbpassword);
> > so in your case it should be
> >     DriverManager.getConnection
("jdbc:oracle:thin:@207.159.74.75:1521:destro",
> > username, password);
> >  
> > cheers,
> > cindy
> > bilal_z_at_my-deja.com wrote:
> > <blockquote TYPE=CITE>The java snippet:
> > DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver
());
> >      Connection conn =
DriverManager.getConnection
> > ("jdbc:oracle:thin:207.159.74.75:1521:destro",
> >
>            &n
> bsp;           &n
> bsp;       
> > username,password);
> > The listener.ora file:
> > # D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration
> > <a href="File:d:\Oracle\Ora81
> \NETWORK\ADMIN\listener.ora">File:d:\Oracle\Ora81
> \NETWORK\ADMIN\listener.ora</a>
> > # 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 <a

href="http://www.deja.com/">http://www.deja.com/</a>
> > > > Before you buy.
> > >
> > >
> > Sent via Deja.com <a

href="http://www.deja.com/">http://www.deja.com/</a>
> > Before you buy.</blockquote>
> > </html>
> >
> > --------------3F0E060C73D4E8F9B77ACEEC--
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Mar 20 2000 - 00:00:00 CST