🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.oracle.tools
Article #9

Oracle Thin JDBC driver problem

#9
From: Sasu Mattila
Date: Thu, 23 Jul 1998 00:00
52 lines
2533 bytes
Any suggestions? Oracle Thin JDBC does not work in some environments.

Three computers:
NT 4 and JDK 1.1.2 Borland (OK)
NT 4 and JDK 1.1.3 Sun (FAIL)
Sun and JDK 1.1.5 Sun (FAIL)

On the machines with the Sun JDK the Oracle supplied Thin JDBC sample
program does not work, even though the classes111.zip is in the
classpath.
On the Borland JDK machine the same sample program works OK.

To add a twist to this - a JBuilder2 application using
Database/QueryDataSet works even on the Sun JDK machines. But not the
Oracle supplied sample program! What does JBuilder2 do differently to
get those Thin drivers working?

The stack trace looks like this:
java.lang.NoClassDefFoundError: oracle/sqlnet/SQLnetPacket
        at oracle.sqlnet.SQLnet.Connect(SQLnet.java:200)
        at oracle.sqlnet.SQLnet.Connect(SQLnet.java:146)
        at oracle.sqlnet.SQLnet.Connect(SQLnet.java:120)
        at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:983)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:158)
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:93)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:146)
        at java.sql.DriverManager.getConnection(DriverManager.java:91)
        ...

The program is here:
import java.sql.*;
class JdbcTest {
  public static void main (String args []) throws SQLException {
    // Load Oracle driver
    DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver());
    // Connect to the local database
    Connection conn =  DriverManager.getConnection
("jdbc:oracle:thin:@db.my:1521:EETU", "user", "password");
    // Query the employee names
    Statement stmt = conn.createStatement ();
    ResultSet rset = stmt.executeQuery ("select * from user");
      // Print the name out
    while (rset.next ())
      System.out.println (rset.getString (1));
  }
}

Many thanks!
sasu
Technical Details
Message-ID: <35B6E489.A40BC6CA@regex.fi>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5464,d376a31d0a4a2863,start
X-Google-Attributes: gidf5464,public
X-Google-Thread: 1073da,d376a31d0a4a2863,start
X-Google-Attributes: gid1073da,public
From: Sasu Mattila <sasu@regex.fi>
Subject: Oracle Thin JDBC driver problem
Date: 1998/07/23
Message-ID: <35B6E489.A40BC6CA@regex.fi>
X-Deja-AN: 374104222
Content-Transfer-Encoding: 7bit
Organization: Telecom Finland News Service
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.tools,borland.public.jbuilder.database