OracleTNSListener80 on 8.03 kicks out with JDBC

OracleTNSListener80 on 8.03 kicks out with JDBC

Post by patrick.stden.. » Wed, 29 Apr 1998 04:00:00



Folks,

The TNSListener80 service in NT4.0 keeps stopping.  I start the
service, connect with SQLplus just fine, then I try to connect with
either the JDBC thin driver or the JDBC-ODBC bridge and I get errors
like:

For the ODBC...

C:\JavaDev>java Olink
java initiated
SQL Problem
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12224: TNS:no listener
        at java.lang.Throwable.<init>(Compiled Code)
        at java.sql.SQLException.<init>(Compiled Code)
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(Compiled Code)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:3822)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:1037)
        at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:153)
        at
sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:173)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at
java.sql.DriverManager.getConnection(DriverManager.java:134)
        at Olink.main(Olink.java:19)

for the thin driver...

C:\JavaDev>java Olink
java initiated
SQL Problem
java.sql.SQLException: Connection refused
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at java.sql.SQLException.<init>(SQLException.java:90)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:228)
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:100)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:147)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at
java.sql.DriverManager.getConnection(DriverManager.java:134)
        at Olink.main(Olink.java:20)

I am using the new JDBC drivers for Oracle8.  This problem just
started happening.  Any ideas?

Patrick St. Dennis


 
 
 

OracleTNSListener80 on 8.03 kicks out with JDBC

Post by Toru Okumu » Thu, 30 Apr 1998 04:00:00


Please show the line of programme including DriverManager.getConnection.
It helps people to point where is problem.

Thanks,

Quote:>   The TNSListener80 service in NT4.0 keeps stopping.  I start the
>   service, connect with SQLplus just fine, then I try to connect with
>   either the JDBC thin driver or the JDBC-ODBC bridge and I get errors
>   like:

---(cut below)---
--

                                          Toru  Okumura

 
 
 

OracleTNSListener80 on 8.03 kicks out with JDBC

Post by patrick.stden.. » Thu, 07 May 1998 04:00:00


The code looks loke this:

import java.io.*;
import java.sql.*;
import java.lang.*;
import java.net.*;
import java.math.*;

public class Olink{

        public static void main(String argv[]) throws IOException{
                System.out.println("java initiated");
      try{

                Class.forName("oracle.jdbc.driver.OracleDriver");
        try{

                        Connection con =

"scott", "tiger");
                        con.close();
                        }
                catch(SQLException ex){
                        System.out.println("SQL Problem");
                        ex.printStackTrace();
                }
                }
      catch(ClassNotFoundException x){
       System.out.println("did not find jdbc");
        x.printStackTrace();
           }

Quote:}
}

I am using the new Oracle8 JDBC thin driver.  I have a hunch that it
has something to do with that since they are just in beta release.  I
don't actually have any applications running on this yet.  The
applications that I am developing are going to use JDBC.

Thanks again,

Patrick St. Dennis



>Please show the line of programme including DriverManager.getConnection.
>It helps people to point where is problem.

>Thanks,

>>   The TNSListener80 service in NT4.0 keeps stopping.  I start the
>>   service, connect with SQLplus just fine, then I try to connect with
>>   either the JDBC thin driver or the JDBC-ODBC bridge and I get errors
>>   like:

>---(cut below)---
>--

>                                          Toru  Okumura

 
 
 

1. OracleTNSListener80 on 8.03 kicks out with JDBC

Folks,

The TNSListener80 service in NT4.0 keeps stopping.  I start the
service, connect with SQLplus just fine, then I try to connect with
either the JDBC thin driver or the JDBC-ODBC bridge and I get errors
like:

For the ODBC...

C:\JavaDev>java Olink
java initiated
SQL Problem
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12224: TNS:no listener
        at java.lang.Throwable.<init>(Compiled Code)
        at java.sql.SQLException.<init>(Compiled Code)
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(Compiled Code)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:3822)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:1037)
        at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:153)
        at
sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:173)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at
java.sql.DriverManager.getConnection(DriverManager.java:134)
        at Olink.main(Olink.java:19)

for the thin driver...

C:\JavaDev>java Olink
java initiated
SQL Problem
java.sql.SQLException: Connection refused
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at java.sql.SQLException.<init>(SQLException.java:90)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:228)
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:100)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:147)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at
java.sql.DriverManager.getConnection(DriverManager.java:134)
        at Olink.main(Olink.java:20)

I am using the new JDBC drivers for Oracle8.  This problem just
started happening.  Any ideas?

Patrick St. Dennis


2. Paradox8 and Windows XP?

3. Paradox lock files and kick outs

4. Data/information [resource] management/administration newsgroup/list

5. Oracle 8.03, ODBC, and VB5.0

6. onbar onarchive or ontape which one??

7. Delphi4 - Oracle 8.03 connect

8. Database Consultant Needed

9. Delphi 3 and Oracle 8.03???

10. converting from paradox to oracle 8.03

11. genrl advice on setup of test server 8.03

12. Pro*c/C++ 8.03 Dynamic SQL Method 4