Ok, did all that (removal of all CP variables), and I did find references of
the Oracle jar files ojdbc14.jar and ojdbc14_g.jar in the C:\Program
Files\Oracle\jre\1.1.8\lib folder, so I removed those too (came with the
laptop build, I believe - they were there before I got it).
But I still get the following error.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page
/chngctrl/change_ctrl_rslts_impactidentifier.jsp at line 126
123: DataSource ds = (DataSource)
124: envCtx.lookup("jdbc/myoracle");
125: // Allocate and use a connection from the pool
126: Connection connection = ds.getConnection();
127:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.chngctrl.change_005fctrl_005frslts_005fimpactidentifier_jsp._jspService(change_005fctrl_005frslts_005fimpactidentifier_jsp.java:750)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class
'oracle.jdbc.OracleDriver'
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
org.apache.jsp.chngctrl.change_005fctrl_005frslts_005fimpactidentifier_jsp._jspService(change_005fctrl_005frslts_005fimpactidentifier_jsp.java:192)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
java.net.URLClassLoader$1.run(URLClassLoader.java:202)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(URLClassLoader.java:190)
sun.misc.Launcher$ExtClassLoader.findClass(Launcher.java:229)
java.lang.ClassLoader.loadClass(ClassLoader.java:307)
java.lang.ClassLoader.loadClass(ClassLoader.java:248)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:169)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
org.apache.jsp.chngctrl.change_005fctrl_005frslts_005fimpactidentifier_jsp._jspService(change_005fctrl_005frslts_005fimpactidentifier_jsp.java:192)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache
Tomcat/6.0.24 logs.
-----Original Message-----
From: Caldarale, Charles R [mailto:[email protected]]
Sent: Tuesday, February 23, 2010 2:40 PM
To: Tomcat Users List
Subject: RE: DB connection error -Tomcat 6 config
> From: Propes, Barry L [mailto:[email protected]]
> Subject: RE: DB connection error -Tomcat 6 config
>
> I did have my CLASSPATH referencing the following:
>
> .;C:\Program Files\Java\jre1.5.0_06\lib\ext\QTJava.zip;
> C:\Java\jdk1.6.0_18\bin;
> C:\oracle\ora92\jdbc\lib;
> C:\oracle\ora92\jdbc\lib\nls_charset11.zip;
> C:\oracle\ora92\jdbc\lib\classes111.zip;
> C:\oracle\ora92\jdbc\lib\ocrs12.zip
>
> You're saying remove those? (The last four references I presume).
No, remove all of them. Never, ever have the CLASSPATH variable set.
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you received
this in error, please contact the sender and delete the e-mail and its
attachments from all computers.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
