Go and look at this file, _summary_5F_sport_jsp_1.java, in your work
directory at line 215 and see which object it says is null and then add a
check to your jsp to see if the object is null before you perform the
operation.
-----Original Message-----
From: Aron Kramlik [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 2:06 AM
To: [EMAIL PROTECTED]
Subject: simple select problem
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(JspRuntimeLibr
ary.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.ja
va: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(StrictLifecycl
eServlet.java:160)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java:287)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java:105)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:36
0)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java:775)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java:701)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java:404)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java:203)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java:107)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:77)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:155)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java:300)
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQ
EventListenerImp.java:230)
at
com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventL
istenerImp.java:104)
at
com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQE
ventSource.java:212)
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.notifyService(SQWrapperEventSource.java:353)
at
com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRu
nnable.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)
