0 Replies Latest reply on Nov 15, 2001 7:24 PM by Edward Knoch

    Oracle using Web Container Tomcat

    Edward Knoch Newbie

      Hello 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