oracle 8i driver for JDBC on sun solaris 8 sparc Platform

Hi guys,
i have a sun ultra 10 sparc platform with solaris 2.8(SUNOS 5.8) and oracle 8i(8.1.7) installed.
we need oracle driver for  JDBC that is compatible with this version.
we've searched the web and couldnt find something useful...also we downloaded some drivers but without any success...
any help will be appreciated.
Who is Participating?
grim_toasterConnect With a Mentor Commented:
You should be able to use the standard, which can be downloaded from the following link for 8.1.7 (although I believe you can use the more recent drivers):

-->also we downloaded some drivers but without any success
What problems were you having?  Exceptions?
you can download all kind of oracle-related stuff from Oracle Technology Network
Oracle JDBC driver comes with Oracle, the file is for Oracle 8i
   and ojdbc14.jar for Oracle 9i (and JDK 1.4). You can also download the drivers
   from (On Oracle's Download page, click on the Oracle JDBC Drivers link
   and select the proper version to download).

   Please note that, for oracle 8.16 or ealier, you must download a updated version
   of; and the ojdbc14.jar driver works only for JDK1.4 or later.
   Here is a possible Exception by using an out-dated dirver:

   java.sql.SQLException: ORA-01009: missing mandatory parameter

   If you use on Oracle 8i databases and Tomcat, you might need rename to classes12.jar, since Tomcat may not classload a zip file.
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

ramooAuthor Commented:
OK friends the drivers are ok i think maybe i'm doing something is what i have in more details.any ideas or clues about what i'm doing wrong?

system properties
Oracle 8i(8.1.7)
Solaris 8 sparc platform(sun ultra 10)
java VM 1.2
I have this zip file "" which is the collection of classes as Oracle Drivers.
I puted it at location /usr/orcldrv
Then using csh shell and defining Environment by setenv command as :
waveiew# setenv CLASSPATH /usr/orcldrv/
This is the related code of establishing the connection with oracle DB  :

      // This is the fragment code of declaration of necessary variables

      String driverName="oracle.jdbc.driver.OracleDriver";
      String ServerName="";
      String portNumber="1521";
      String sID="OMCDB";
      String url = "jdbc::oracle:thin:@"+ServerName+":"+portNumber+":"+sID;

      Connection con;
      Statement stmt, ratesStmt;

      // Now connecting to Oracle Driver

            try {
            } catch(java.lang.ClassNotFoundException e) {
                  System.err.print("ClassNotFoundException: ");
                  con = DriverManager.getConnection(url,"pola", "pola");
            }catch(SQLException ex) {

And this is the exception thrown when running the program :

ClassNotFoundException : oracle.jdbc.driver.OracleDriver
java.sql.SQLException : No suitable driver
      at java.lang.Throwable.fillInStackTrace(Native Method)
      at java.lang.Throwable.fillInStackTrace(Compiled code)
      at java.lang.Throwable.<init>(Compiled Code)
      at java.lang.Exception.<init>(
      at java.sql.DriverManager.getConnection(Compiled Code)
      at java.sql.DriverManager.getConnection(
      ...(my code positions makes excepion )

I then used javac,javah,jdb for the same purpose, and the same exception was thrown.
After it I converted the .zip file to .jar file, and the same problem.

How are you running the program?  You should specify:

java -cp /usr/orcldrv/ ClassName
ramooAuthor Commented:
I'm getting the same error after doing last note,
exception in thread "main" java.lang.NoclassDefFoundError:oracleSql.class.

the class name that i specified is oracleSql.class.
looks that it doesnt recognizes the folder or classes12.jar or cannot read those folders.

The class is incorrectly referenced, it should be "OracleSql" not "oracleSql".
The original question was answered in the first post (by me), I have no idea how to provide you the link to it though!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.