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");
...
