Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: jdbc: PLEASE HELP
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,
> <br> the connection call is of the format
> <br> DriverManager.getConnection
("jdbc:oracle:thin:<b>@</b><machine
> name>:<port number>:<sid>", dbuser, dbpassword);
> <p>so in your case it should be
> <br> DriverManager.getConnection
("jdbc:oracle:thin:<b>@207.159.74.75:1521</b>:destro",
> username, password);
> <br>
> <p>cheers,
> <br>cindy
> <p>bilal_z_at_my-deja.com wrote:
> <blockquote TYPE=CITE>The java snippet:
> <p>DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver
());
> <br> Connection conn =
DriverManager.getConnection
> <br>("jdbc:oracle:thin:207.159.74.75:1521:destro",
>
<br> &n bsp; &n bsp;
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 20 2000 - 00:00:00 CST