What are you using for your servlet container? iAS and Tomcat I know don't handle zip
files correctly. Try renaming your classes12.zip to classes12.jar
Chris Barran wrote:
> I am trying to create a soap service using apache soap 2.2 that accesses
> a database. However I keep getting ClassNotFoundException when trying to
> load the driver using Class.forName.
>
> My class files are in /common/lib and so are the OracleDrivers
> (classes12.zip). I have no problem accessing the database using this
> driver from a standalone class. I have no problem accessing my soap
> service if I hard code the data. I have no problem using this driver
> from a JSP but trying to use the driver from my soap service fails.
>
> Any ideas ?
>
> Error Encountered: Unable to resolve target object:
> oracle.jdbc.driver.OracleDriver
> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
> at
>
>org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:1127)
> at
>
>org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:992)
>
> public CSWhois() throws SQLException, ClassNotFoundException {
>
> String dbUrl = "jdbc:oracle:thin:@host:1521:DB";
> String dbusername = "usrname";
> String dbpassword = "password";
>
> Class.forName("oracle.jdbc.driver.OracleDriver");
>
> Connection conn = DriverManager.getConnection(dbUrl, dbusername,
> dbpassword);
> Statement stmt = conn.createStatement();
> ResultSet resultSet = stmt.executeQuery("SELECT * FROM CSWHOIS_DATA");
> ...
