Ok, well perhaps I'm narrowing down, or minimizing the errors.
I seem to be having some kind of conflict with the driver class and possibly
as a result from this, the Context for a connection pool I'd built in the
earlier version. From what I can tell, looking at the TC6 docs, the env lookup
ought to be about the same. I'll double check that, but it looked to be about
just like the way I had it before.
Any way, here's the stack trace error.
----------------------------------
org.apache.jasper.JasperException: javax.servlet.ServletException:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class
'oracle.jdbc.OracleDriver'
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
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_005fcondensed_005fchngreq_005fnowork_jsp._jspService(change_005fctrl_005frslts_005fcondensed_005fchngreq_005fnowork_jsp.java:478)
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_005fcondensed_005fchngreq_005fnowork_jsp._jspService(change_005fctrl_005frslts_005fcondensed_005fchngreq_005fnowork_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_005fcondensed_005fchngreq_005fnowork_jsp._jspService(change_005fctrl_005frslts_005fcondensed_005fchngreq_005fnowork_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.
----------------------------------
Does it appear the Oracle driver class and tomcat-dbcp jars have classes that
are conflicting?
Thanks, Chuck.
-----Original Message-----
From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com]
Sent: Friday, February 19, 2010 4:39 PM
To: Tomcat Users List
Subject: RE: DB connection error -Tomcat 6 config
> From: Propes, Barry L [mailto:barry.l.pro...@citi.com]
> Subject: RE: DB connection error -Tomcat 6 config
>
> Should I (not) be rendering some of the particular webapps's info in
> the WEB-INF/web.xml file?
What did you have in mind?
The WEB-INF/web.xml file holds the servlet-spec defined configuration for the
webapp. However, a lot of necessary configuration is left up to the
implementation of the servlet container; Tomcat requires that you supply those
non-spec items primarily in the <Context> element, preferably located as
previously stated.
- 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: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
