Oracle using Web Container Tomcat
edinak Nov 15, 2001 7:24 PMHello all;
I am having a few problems transitioning from a stand-alone Servlet implementation to the Jboss / Tomcat implementation.
I am operating on Solaris 8 (7/10). I am using Jboss 2.4.3 - Tomcat 3.2.3 bundle from jboss.
For a database, I am using Oracle 9i (9.0.1) with the JDBC driver for 9i (classes12.zip).
I am able to connect default datasources to an oracle database for my CMP activities. However, when I use the web container for my legacy JSP applications (until I re-write them in CMP), I am encountering the following error:
Error: 500
Location: /pts/vendor/VendorLogIn.jsp
Internal Servlet Error:
javax.servlet.ServletException: Io exception: End of TNS data channel
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)
at pts.vend_00025r._0002fpts_0002fvendor_0002fVendorLogIn_0002ejspVendorLogIn_jsp_0._jspService(_0002fpts_0002fvendor_0002fVendorLogIn_0002ejspVendorLogIn_jsp_0.java:1001)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
Root cause:
java.sql.SQLException: Io exception: End of TNS data channel
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:334)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at pts.vend_00025r._0002fpts_0002fvendor_0002fVendorLogIn_0002ejspVendorLogIn_jsp_0.cn(_0002fpts_0002fvendor_0002fVendorLogIn_0002ejspVendorLogIn_jsp_0.java:371)
at pts.vend_00025r._0002fpts_0002fvendor_0002fVendorLogIn_0002ejspVendorLogIn_jsp_0._jspService(_0002fpts_0002fvendor_0002fVendorLogIn_0002ejspVendorLogIn_jsp_0.java:951)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
I have checked the url and independently tested it via simple java program for connectivity to the database and it works fine. This only occurs when using the tomcat servlet implementation and the Oracle JDBC driver. We have jsp code running in the container that is connecting to db2 just fine.
Any assistance would be appreciated.
Thank you,
Ed