[prev in list] [next in list] [prev in thread] [next in thread]
List: taglibs-user
Subject: RE: NullPointerException Error
From: "Modha Kumar" <mkumar () sentius ! com>
Date: 2002-01-29 19:19:34
[Download RAW message or body]
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:THOMAS_J.ZVOLENSKY@ROCHE.COM]
Sent: Tuesday, January 29, 2002 11:05 AM
To: 'taglibs-user@jakarta.apache.org'
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>
<title>User 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="center"><b>PDBI 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="left"><sql:getColumn position="2"/></td>
<td align="left"><sql:getColumn position="3"/></td>
<td align="left"><sql:getColumn position="4"/>
<sql:wasNull>No records returned</sql:wasNull></td>
</tr>
</sql:resultSet>
</sql:statement>
</table>
</center>
</div>
<!-- Close the Db connection -->
<sql:closeConnection conn="conn1"/>
</body>
</html>
Can anybody tell me what the source of the problem is?
TIA.
Tom Zvolensky
Hoffmann-La Roche, Inc.
--
To unsubscribe, e-mail: <mailto:taglibs-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:taglibs-user-help@jakarta.apache.org>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic