All:
Any help rendered would be appreciated. (jdk 1.4.2_06,
Tomcat 4.0,
Oracle DB 9i Windows XP)
I have a web app (Jasper report tool) and I cannot connect to a Oracle 9i database.
1)error received: "Apr 2, 2007 2:05:15 PM com.entDB.Enterprise_db connectToDatabase SEVERE: Function connectToDatabase() - Cannot load the driver, reason:java.sql.SQLException: No suitable driverCheck classpath for driver java.sql.SQLException: No suitable driver
2)CLASSPATH SETTING = C:\tomcat\common\lib\ojdbc14.jar
3)Source code:
protected boolean connectToDatabase() {
try {
// I tried this !!! Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("URL,USER,PASSWORD ");
return true;
}catch (SQLException e) {
logger.error("Function connectToDatabase() - Cannot load the driver, reason:" + e.toString() + "Check classpath for driver ", e);
return false;
}
4.I placed a copy of the jar file in TOMCAT common lib, and server lib.
I have tried various solutions listed at different web sites without success. Has anyone had similiar problems? Can anyone assist?
thanks ......
[edited subject to remove "911" - nothing is on fire]
[ April 02, 2007: Message edited by: Jeanne Boyarsky ]