RE: NullPointerException Error
You are getting positions 2,3,4 my first guess would be to check
if they are correct.
-Original Message-
From: Zvolensky, Thomas J {PDBI~Nutley}
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:05 AM
To: '[EMAIL PROTECTED]'
Subject: NullPointerException Error
Hi,
I'm a JSP newbie and am having trouble using the DBTags library.
I have a simple page which is intended to open an MS Access database and
display three columns of information from one table.
I'm getting a NullPointerException when the page compiles:
java.lang.NullPointerException
at
org.apache.taglibs.dbtags.connection.ConnectionTag.doEndTag(ConnectionTag.ja
va:221)
at org.apache.jsp.Phone1$jsp._jspService(Phone1$jsp.java:86)
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.ja
va: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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
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.ja
va:201)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
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:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
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:5
66)
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.http.HttpProcessor.process(HttpProcessor.java:
1011)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106
)
at java.lang.Thread.run(Thread.java:484)
The page code is as follows:
++
%@ taglib uri=http://jakarta.apache.org/taglibs/dbtags; prefix=sql %
html
head
meta http-equiv=Content-Language content=en-us
meta http-equiv=Content-Type content=text/html; charset=windows-1252
meta name=GENERATOR content=Microsoft FrontPage 4.0
meta name=ProgId content=FrontPage.Editor.Document
style
a{font-family:verdana; font-size:8pt; color:blue; text-decoration:none;
font-weight:bold;}
a:hover{color:red; text-decoration:underline;}
td{font-family:verdana; font-size:8pt; font-weight:bold;}
/style
titleUser Activity/title
/head
body
!-- Open database connection --
sql:connection id=conn1 dataSource=PhoneList
/sql:connection
!-- This is the database query --
sql:statement id=stmt1 conn=conn1
sql:query
SELECT * FROM LIST ORDER BY Name
/sql:query
h1 align=centerbPDBI Phone List/b/h1
div align=center
center
table border=0 width=75%
tr
td width=30% style=background-color:#6699CC;Name/td
td width=30% style=background-color:#6699CC;Room/td
td width=20% style=background-color:#6699CC;Phone/td
/tr
!-- Loop through the rows of the query and display in the table --
sql:resultSet id=rs
tr
NullPointerException Error
Hi,
I'm a JSP newbie and am having trouble using the DBTags library.
I have a simple page which is intended to open an MS Access database and
display three columns of information from one table.
I'm getting a NullPointerException when the page compiles:
java.lang.NullPointerException
at
org.apache.taglibs.dbtags.connection.ConnectionTag.doEndTag(ConnectionTag.ja
va:221)
at org.apache.jsp.Phone1$jsp._jspService(Phone1$jsp.java:86)
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.ja
va: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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
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.ja
va:201)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
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:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
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:5
66)
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.http.HttpProcessor.process(HttpProcessor.java:
1011)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106
)
at java.lang.Thread.run(Thread.java:484)
The page code is as follows:
++
%@ taglib uri=http://jakarta.apache.org/taglibs/dbtags; prefix=sql %
html
head
meta http-equiv=Content-Language content=en-us
meta http-equiv=Content-Type content=text/html; charset=windows-1252
meta name=GENERATOR content=Microsoft FrontPage 4.0
meta name=ProgId content=FrontPage.Editor.Document
style
a{font-family:verdana; font-size:8pt; color:blue; text-decoration:none;
font-weight:bold;}
a:hover{color:red; text-decoration:underline;}
td{font-family:verdana; font-size:8pt; font-weight:bold;}
/style
titleUser Activity/title
/head
body
!-- Open database connection --
sql:connection id=conn1 dataSource=PhoneList
/sql:connection
!-- This is the database query --
sql:statement id=stmt1 conn=conn1
sql:query
SELECT * FROM LIST ORDER BY Name
/sql:query
h1 align=centerbPDBI Phone List/b/h1
div align=center
center
table border=0 width=75%
tr
td width=30% style=background-color:#6699CC;Name/td
td width=30% style=background-color:#6699CC;Room/td
td width=20% style=background-color:#6699CC;Phone/td
/tr
!-- Loop through the rows of the query and display in the table --
sql:resultSet id=rs
tr
td align=leftsql:getColumn position=2//td
td align=leftsql:getColumn position=3//td
td align=leftsql:getColumn position=4/
sql:wasNullNo records returned/sql:wasNull/td
/tr
/sql:resultSet
/sql:statement
