Okay I am a newbie to this but all the other posts concerning this just say add the classes12.jar to my classpath.
I am using websphere 5.0
connecting to a 9i db.
after trying to find out what my classpath is ( websphere 5.0 makes it difficult to see it) i found this:

<?xml version="1.0" encoding="UTF-8"?>
<classpath>
    <classpathentry kind="var"
        path="SERVERJDK_50_PLUGINDIR/jre/lib/rt.jar"
        rootpath="SERVERJDK_SRCROOT" sourcepath="SERVERJDK_50_PLUGINDIR/src.jar"/>
    <classpathentry kind="src" path="Java Source"/>
    <classpathentry kind="var" path="WAS_50_PLUGINDIR/lib/j2ee.jar"/>
    <classpathentry kind="var" path="WAS_50_PLUGINDIR/lib/servletevent.jar"/>
    <classpathentry kind="var" path="WAS_50_PLUGINDIR/lib/ivjejb35.jar"/>
    <classpathentry kind="var" path="WAS_50_PLUGINDIR/lib/runtime.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/string.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/jaxen-full.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/utility.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/jspsql.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/xercesImpl.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/xalan.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/datetime.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/mailer.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/dom.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/jstl.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/standard.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/jdbc2_0-stdext.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/saxpath.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/sax.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/dbbeans.jar"/>
    <classpathentry kind="lib" path="Web Content/WEB-INF/lib/jaxp-api.jar"/>
    <classpathentry kind="lib" path="C:/oracle/ora92/jdbc/lib/classes12.jar"/>
    <classpathentry kind="output" path="Web Content\WEB-INF\classes"/>
</classpath>


to me it looks like it is in my classpath.. (if thats what this is).

I have imported the classes12.jar file several times through out my project to no avail.

the error i get it here:

Error: It Screwed up agian java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
SystemOut O Connecting ... cisinv
Error: java.sql.SQLException: No suitable driver
SystemErr R Exception: null

from this code:
package Business;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


/**
 * @author jeffreak
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */
public class beanDbConnect {

    /**
     * Constructor for beanDbConnect.
     */
    public beanDbConnect() {
        super();
    }


    private Connection con = null;
    private Statement cmd = null;
    private ResultSet rs = null;

    public Connection connect()
    {
        //Declare variable

        boolean blnSuccessfulOpen = false;
        Driver driver;
        String driverName;
        String serverAddress;

        //Begin try block

        try
        {
            //Load JdbcOdbcDriver

            driverName = "oracle.jdbc.driver.OracleDriver";
                        //oracle.jdbc.driver.OracleDriver
            System.out.println("Loading ..." + driverName);
            //try{
            Class.forName(driverName).newInstance();
                                    //}
            //catch (Exception err)
// {
// System.err.println("Error: new instance: " + err.toString());
// }

        System.out.println("Database loaded successfully");

        }

        //catch (ClassNotFoundException e)
        catch (Exception e)
        {
            System.err.println("Error: It Screwed up agian " + e.toString());
            blnSuccessfulOpen = false;
        }

        try
        {
            //Instantiate connection to bean-defined DSN

            //serverAddress = ("jdbc:oracle:thin:scott/tiger@localhost:1243:" + dbInstance);

            System.out.println("Connecting ... " );

            String serverName = "**********";//changed for post
            String portNumber = "1521";
            String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + "cisinv";

            con = DriverManager.getConnection(url, "scott", "tiger");

            System.out.println("Ready.");

            blnSuccessfulOpen = true;
        }
        catch (SQLException e)
        {
            System.err.println("Error: " + e.toString());
        }

        //End try block

        return con;
    }//end connect()

}

Please help. ive been working on it for days =(.

Add manually to the Web-Inf\lib folder

classes12.jar