Ok, Chris -- I blew away the new version I'd made, and recreated the webapps
ensuring I went in this order.
I'm still getting an error, but now it seems confined to the jdbc/env lookup
reference I'd earlier tried to make.
I've put that reference, as noted below in your email, in the appropriate
webapp folder, /META-INF/context.xml.
Now my stack trace appears like so:
-------------------------------------------------------------
message
description The server encountered an internal error () that prevented it from
fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page
/chngctrl/change_ctrl_rslts_condensed.jsp at line 115
112: Context envCtx = (Context) initCtx.lookup("java:comp/env");
113: // Look up our data source
114: DataSource ds = (DataSource)
115: envCtx.lookup("jdbc/myoracle");
116: // Allocate and use a connection from the pool
117: Connection connection = ds.getConnection();
118:
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: javax.naming.NameNotFoundException: Name jdbc
is not bound in this Context
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_jsp._jspService(change_005fctrl_005frslts_005fcondensed_jsp.java:428)
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
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
org.apache.naming.NamingContext.lookup(NamingContext.java:770)
org.apache.naming.NamingContext.lookup(NamingContext.java:153)
org.apache.jsp.chngctrl.change_005fctrl_005frslts_005fcondensed_jsp._jspService(change_005fctrl_005frslts_005fcondensed_jsp.java:181)
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.
----------------------------------------------------------
Thanks, Chris
>>>>>>>Barry,
>>>>>>0. Install Tomcat 6.0.x
1. Copy yourapp.war from tomcat4/webapps/yourwpp.war to tomcat6/webapps 2. Copy
JDBC driver to tomcat6/lib 3. Create
tomcat6/webapps/yourwebapp.war/META-INF/context.xml containing:
<Context ...>
<Resource
name="jdbc/resourcename"
type="javax.sql.DataSource"
..
/>
</Context>
>>>>>>That should be about it. If you want logging, too, that's a different
>>>>>>story :)
- -chris
---------------------------------------------------------------------
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]