Dear Sirs, I have Oracle 7.2 on a Solaris machine and I have installed Oracle's JDBC Thin Driver for Solaris (http://technet.oracle.com/software/index.htm). In some of your documentation "Oracle7 JDBC Drivers" you stated that all the distribution forms of the JDBC Thin and the JDBC OCI drivers produce the same contents of the jdbc directory: readme.txt doc/ samples/ lib/ But neither one (Solarid and NT) produced these contents. When I unzipped the JDBC THIN for Solaris it produced: jdbc/classes102 jdbc/classes111/oracle/gss jdbc/classes111/oracle /jdbc jdbc/classes111/oracle /sqlnet jdbc/liboci73jdbc.so When I log in into Oracle I'm in the directory /antw01. As you instructed I created a directory /antw01/local/jdbc Now I've tried two things: 1. I've unzipped your distribution file in this directory 2. And I've created the directory /antw01/local/jdbc/lib and put the unzipped classes111.zip file in this directory. In my /antw01/.profile file my settings were as follow: CLASSPATH=/antw01/local/jdbc/lib/classes111.zip:/antw01/local/jdbc/or acle:/antw01/local/jdk1.1.4-solaris2-sparc.bin LC_LIBRARY_PATH=/antw01/jdbc/lib Now ready to get to work I've tried several Java codes: import java.sql.*;^M ^M class JdbcTest^M { public static void main (String args[]) throws SQLException^M { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@antw:1521:orcl", "developer","developer");^M Statement stmt = conn.createStatement();^M ResultSet rset = stmt.executeQuery("select sysdate from dual");^M while (rset.next());^M System.out.println(rset.getString(1));^M stmt.close(); }^M } I get the following result: $ javac JdbcTest.java JdbcTest.java:5: Class oracle.jdbc.driver.OracleDriver not found in type declar. { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); I've also tried: import java.sql.*;^M ^M public class sqlselect^M { public static void main (String args[]) throws SQLException^M { try{^M try{ Class.forName("oracle.jdbc.thin.OracleDriver");^M }^M catch (Exception e)^M {System.out.println ("\n Class not found exception");^M }^M Connection conn = ^M DriverManager.getConnection("jdbc:oracle:thin:@antw:1521","develope r","developer");^M Statement stmt1 = conn.createStatement();^M ResultSet rs1 = stmt1.executeQuery("select table_name from all_tables");^M while (rs1.next());^M System.out.println(rs1.getString(1));^M }^M catch (SQLException exception)^M { System.out.println ("\n SQL Exception " + exception.getMessage() + "\n"); }^M }^M First I compiled it and tried to run it, but this was the result. $ javac sqlselect.java $ java sqlselect Class not found exception SQL Exception No suitable driver I'M IN DESPERATE NEED OF HELP. DO YOU HAVE SOME ADVISE FOR ME. BEST REGARDS, Marian Lieuw A Soe Marian B. Lieuw A Soe Email: [EMAIL PROTECTED] [EMAIL PROTECTED] =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff JAVA3D-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
