Hello all,
I don't have any problems getting the results from a database diplayed in my
browser. However, I am having problems executing 2 different queries from
a single JSP. I have in my page resultset and other variables set to null.
Then I execute the query. This works fine for just one querie. Further down
the page I then reset everything to null and re-assign things and execute the
second query. My goal is to display both results sets in the browser.
I end up getting a NullPointer exception. But when I print out to see what my
variables are they are not null. So the problem seems to be with my connection.
The scope is session so I shouldn't be losing it. My connection and execution
commands are in beans that I call from my page. Does anyone know why trying
to execute two sepearte queries would give my an exception while connecting
to the database? I would greatly appreciate this since I have a very tight
deadline!
Thanks in advance!!!!
Sue
I Khaitan wrote:
> You can access the individual fields in the resultset by calling resultset's
> get mthods eg. getString( ). getString method is overloaded and takes column
> name(String) as well as column index(int). There are other methods as well
> for some data types.
>
> Hope this helps
> -khaitan
>
> ----- Original Message -----
> From: Shrikumar R <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 28, 1999 2:17 AM
> Subject: displaying the contents of a rs
>
> > Thanks all for the help with my previous question. I
> > managed to instantiate my bean, I mean the java bean.
> > Here is another one. I successfully retrieve the data
> > from my database in to the record set in my java bean.
> > Now I am trying to display these data in a html format
> > in my jsp page but am not able to do so properly. Can
> > somebody please tell me how to refer to a specific
> > field in this recordset. for example if I do a select
> > * from... but I want to display only some fields from
> > the result set. Also can somebody tell me where I can
> > find some docs on this database manipulation.
> >
> > Thanks in advance
> >
> > Shri
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Bid and sell for free at http://auctions.yahoo.com
> >
> >
> ===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > FAQs on JSP can be found at:
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
