Hi >can we see the errors?
Wow - fast response. Thank-you. Iactually just noticed that someone else found the exact same thing. He got no replies. http://groups.google.com/groups?q=mod_webapp+JDBC&hl=en&selm=7774774d.0109191826.5240aa0%40posting.google.com&rnum=1 On the web page,I see this; java.lang.NullPointerException at org.apache.jsp.ism$jsp._jspService(ism$jsp.java:123) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHandler.java:215) at org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:194) at java.lang.Thread.run(Thread.java:484) The errors in the apache log file in $CATALINA_HOME/logs are as follows: 2002-02-12 13:10:16 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception java.lang.NullPointerException at org.apache.jsp.ismResult_0005fn$jsp._jspService(ismResult_0005fn$jsp. java:124) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer vlet.java:202) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 82) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline .java:566) Thanks Chris > >-----Original Message----- >From: Chris Faulkner [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, February 12, 2002 7:26 AM >To: Tomcat Users List >Subject: database connect to db overr mod_webapp - possible bug > > >Hi > >I have a JSP which,when called direct into Tomcat (4.0.1) on Linux works >fine. It connects to a database, retrieves results, fine. > >http://host_a:8080/ism/JSP/file.jsp?param1=value¶m2=value > >"host_a" is a vrtual host defined in my apache config and in the DNS servers >on our LAN. > >In the virtual host setting of Apache, I have > >WebAppConnection coni warp localhost:8008 >WebAppDeploy ism coni /ism/ > >Static pages,servlets and JSP are fine across mod_webapp. However, when I >try my database JSP, I get errors. This code is in the JSP when I go through >8080 and it WORKS, it connects to the DB and all goes >OK. So my configuration of the jdbc/IsmDB must be OK. I created the JDBC >datasources as outlined at the Tomcat website. > >Context initCtx = new InitialContext(); >Context envCtx = (Context) initCtx.lookup("java:comp/env"); >javax.sql.DataSource ds = (javax.sql.DataSource)envCtx.lookup("jdbc/IsmDB"); >Connection conn = ds.getConnection(); > >However, when I connect to the page via Apache, the third line fails the >connection to the database fails. I replace those 4 lines with the following >and it works. > >String sConn = "jdbc:oracle:thin:@ip:port:sid"; // connnection string >DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver() ); >Connection conn=DriverManager.getConnection( sConn, "user", "password" ); >Statement stmt = conn.createStatement(); > >So have I missed some configuration to make the database connection work >over mod_webapp or is this a bug ? > >Thanks > > >Chris > > > >-- >To unsubscribe: <mailto:[EMAIL PROTECTED]> >For additional commands: <mailto:[EMAIL PROTECTED]> >Troubles with the list: <mailto:[EMAIL PROTECTED]> > >-- >To unsubscribe: <mailto:[EMAIL PROTECTED]> >For additional commands: <mailto:[EMAIL PROTECTED]> >Troubles with the list: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
