I don't think that there is a property like "userID".
Try removing <jsp:getProperty name="conn1" property="userId"/>
and see if it works.
Marius
Aron Kramlik wrote:
>
> Hi,
>
> I just downloaded the JDBC binary distribution (20010410).
> I have created a very simple JSP that tries to access a table.
> I am running on IBM WebSpere (linux) ad Sybase database.
> The JSP is as follows and the exception I get follows that.
> If anyone has any ideas I would be very greatful as I am sure this
> is some simple problem.
>
> Thanks,
> Aron.
>
> --- JSP ---
>
> <html>
> <head>
> <title>Untitled Document</title>
> </head>
>
> <%@ taglib uri="http://jakarta.apache.org/taglibs/jdbc" prefix="sql" %>
>
> <sql:connection id="conn1">
> <sql:url>jdbc:sybase:Tds:lindev3:4100</sql:url>
> <sql:driver>com.sybase.jdbc2.jdbc.SybDriver</sql:driver>
> <sql:userId>user</sql:userid>
> <sql:password>pwd</sql:password>
> </sql:connection>
>
> <jsp:getProperty name="conn1" property="userId"/>
>
> <table>
> <sql:statement id="stmt1" conn="conn1">
> <sql:query>
> select id, name from category1
> </sql:query>
> <sql:resultSet id="rset2">
> <tr>
> <td><sql:getColumn position="1"/></td>
> <td><sql:getColumn position="2"/></td>
> </tr>
> </sql:resultSet>
> </sql:statement>
> </table>
>
> <sql:closeConnection conn="conn1"/>
>
> </body>
> </html>
>
> -- exception --
>
> org.apache.jasper.JasperException: Attempted a bean operation on a null
> object.
> at
> javax.servlet.ServletException.<init>(ServletException.java:107)
> at
> org.apache.jasper.JasperException.<init>(JasperException.java:73)
> at
>
>org.apache.jasper.runtime.JspRuntimeLibrary.handleGetProperty(JspRuntimeLibrary.java:427)
> at
> alerts._summary_5F_sport_jsp_1._jspService(_summary_5F_sport_jsp_1.java:215)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:127)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:381)
> at
> org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:702)
> at
> org.apache.jasper.runtime.JspServlet.service(JspServlet.java:822)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
>com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:626)
> at
>
>com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:160)
> at
>
>com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:287)
> at
>
>com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:105)
> at
> com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:360)
> at
>
>com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:775)
> at
>
>com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:701)
> at
>
>com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:404)
> at
>
>com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:203)
> at
>
>com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:107)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:77)
> at
>
>com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
> at
>
>com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:155)
> at
>
>com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:300)
> at
>
>com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQEventListenerImp.java:230)
> at
>
>com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventListenerImp.java:104)
> at
>
>com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQEventSource.java:212)
> at
>
>com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.notifyService(SQWrapperEventSource.java:353)
> at
>
>com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.run(SQWrapperEventSource.java:220)
> at
>
>com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run(OutOfProcThread.java:248)
> at java.lang.Thread.run(Thread.java:481)
--
------------------
Marius Scurtescu, Software Engineer
Tel: (604) 899-2835 Fax: (604) 899-2899
mailto:[EMAIL PROTECTED]
Multiactive Software Inc. http://www.multiactive.com
------------------
Attract and retain customers with Multiactive Software --
proud winners of PC WEEK's "Best of COMDEX" award.
------------------
