Article View: comp.databases.oracle.tools
Article #9Oracle Thin JDBC driver problem
From: Sasu Mattila
Date: Thu, 23 Jul 1998 00:00
Date: Thu, 23 Jul 1998 00:00
52 lines
2533 bytes
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-mailShow 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