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> <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:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>