RE: WebApp and database not working
Hi Yoav,
Here it the jsp and servlet code I am using, again it
works when accessed directly but via Apache and WebApp
no.
Thanks,
Vid
Here is JSP Page---
<% //@ page errorPage="errPage.jsp" %>
<%
WebSql.GetRec nhdbRec = new WebSql.GetRec();
nhdbRec.init("select field1,field2,field3 from
table");
%>
DB Test
Results
<%
while(nhdbRec.getResultSet1().next())
{
%>
<%=nhdbRec.getResultSet().getString(2)%>
<%
}
%>
--Here is the Servlet-
package WebSql;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;
public class GetRec
{
//create global variables that can be returned via
public get functions
ResultSet rst;
public void init(String sqlStr) {
try{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("Boom - No Context");
DataSource ds =
(DataSource)ctx.lookup(
"java:comp/env/jdbc/dbWeb");
if (ds != null) {
//open connection
Connection conn = ds.getConnection();
//if connecction open create and execute
record sets
if(conn != null) {
Statement stmt = conn.createStatement();
rst = stmt.executeQuery(sqlStr);
connJsp = conn;
}
}
}catch(Exception e) {
e.printStackTrace();
}
}
public ResultSet getResultSet() { return rst; }
--
--- "Shapira, Yoav" <[EMAIL PROTECTED]> wrote:
>
> Howdy,
> Post the relevant code that throws the NPE. ;)
>
> Yoav Shapira
> Millennium ChemInformatics
>
>
> >-Original Message-
> >From: Vid Bijelic [mailto:[EMAIL PROTECTED]
> >Sent: Friday, August 15, 2003 3:13 PM
> >To: [EMAIL PROTECTED]
> >Subject: WebApp and database not working
> >
> >Hi,
> >
> >When I open web page with database connection
> directly
> >(not via Apache and WebApp) it works fine (displays
> >records from database), but when I open the same
> page
> >through Apache using WebApp I got Null Pointer
> >Exception.
> >
> >I hope some one has a suggestion for this.
> >
> >I am using Tomcat4.1, Apache2.0.4, RedHat
> >9.0,j2sdk1.4.2, WebApp, InterClient and InterBase
> 6.0
> >database.
> >
> >Here is the Exception I am getting:
> >--
> >exception
> >
> >org.apache.jasper.JasperException
> > at
>
>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j
> ava:
> >248)
> > at
>
>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295
> )
> > at
>
>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> > at
>
>javax.servlet.http.HttpServlet.service(HttpServlet.java)
> > at
>
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
> atio
> >nFilterChain.java:247)
> > at
>
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
> terC
> >hain.java:193)
> > at
>
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
> ve.j
> >ava:260)
> > at
>
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invo
> >keNext(StandardPipeline.java:643)
> > at
>
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 480)
> > at
>
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > at
>
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
> ve.j
> >ava:191)
> > at
>
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invo
> >keNext(StandardPipeline.java:643)
> > at
>
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 480)
> > at
>
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > at
>
>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:24
> 15)
> > at
>
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
> a:18
> >0)
> > at
>
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invo
> >keNext(StandardPipeline.java:643)
> > at
>
>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV
> alve
> >.java:170)
> > at
>
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invo
> >keNext(StandardPipeline.java:641)
> > at
>
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav
> a:17
> >2)
> > at
>
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.
> invo
> >keNext(StandardPipeline.java:641)
> > at
>
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
> 480)
> > at
>
>org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > at
>
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve
> .jav
> >a:174)
> > at
>
>org.apache.catalina.core.StandardPipeline$StandardP
RE: WebApp and database not working
Howdy, Post the relevant code that throws the NPE. ;) Yoav Shapira Millennium ChemInformatics >-Original Message- >From: Vid Bijelic [mailto:[EMAIL PROTECTED] >Sent: Friday, August 15, 2003 3:13 PM >To: [EMAIL PROTECTED] >Subject: WebApp and database not working > >Hi, > >When I open web page with database connection directly >(not via Apache and WebApp) it works fine (displays >records from database), but when I open the same page >through Apache using WebApp I got Null Pointer >Exception. > >I hope some one has a suggestion for this. > >I am using Tomcat4.1, Apache2.0.4, RedHat >9.0,j2sdk1.4.2, WebApp, InterClient and InterBase 6.0 >database. > >Here is the Exception I am getting: >-- >exception > >org.apache.jasper.JasperException > at >org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j ava: >248) > at >org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295 ) > at >org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > at >javax.servlet.http.HttpServlet.service(HttpServlet.java) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic atio >nFilterChain.java:247) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terC >hain.java:193) > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal ve.j >ava:260) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:643) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480) > at >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal ve.j >ava:191) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:643) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480) > at >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at >org.apache.catalina.core.StandardContext.invoke(StandardContext.java:24 15) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav a:18 >0) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:643) > at >org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV alve >.java:170) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:641) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav a:17 >2) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:641) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480) > at >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve .jav >a:174) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:643) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480) > at >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at >org.apache.catalina.connector.warp.WarpRequestHandler.handle(Unknown >Source) > at >org.apache.catalina.connector.warp.WarpConnection.run(Unknown >Source) > at java.lang.Thread.run(Thread.java:534) > > >root cause > >java.lang.NullPointerException > at >org.apache.jsp.index1_jsp._jspService(index1_jsp.java:61) > at >org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > at >javax.servlet.http.HttpServlet.service(HttpServlet.java) > at >org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j ava: >204) > at >org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295 ) > at >org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > at >javax.servlet.http.HttpServlet.service(HttpServlet.java) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic atio >nFilterChain.java:247) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terC >hain.java:193) > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal ve.j >ava:260) > at >org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invo >keNext(StandardPipeline.java:643) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480) > at >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal ve.j >ava:191) > at >org.apac
