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");
%>
<html>
<head>
<title>DB Test</title>
</head>
<body>
<h2>Results</h2>
<select name="Test">
<%
while(nhdbRec.getResultSet1().next())
{
%>
<option><%=nhdbRec.getResultSet().getString(2)%><br></option>
<%
}
%>
</select>
</body>
</html>
------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$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.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
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
