tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul" <p...@msci.ca>
Subject Re: [OFF-TOPIC] RE: can resultset object be re-used
Date Wed, 01 Oct 2003 14:17:11 GMT
thanks for response Yoav,

i knew message was off topic, but did not realize that such messages should
be marked such.  Thanks for informing me.

your answer to my question is what i would have guessed, but cannot find
anything to that effect in Java Docs on ResultSet interface.

to complicate the matter, i have some code as follows, which works fine
(which is why i posted question in first place, because i would have guessed
what you said):

for (i=0; i < parentTable.size(); i++) {

// note: this stmt executed repeatedly in for loop

rset4 = stmt.executeQuery ("select field1, field2, fieldN from
schema.tblsubj3 where field4 = " + parentTable.get(i) + " order by field1");

if (rset4.next()) {

....

Note that the ResultSet interface, rset4, is re-used repeatedly for changing
values in the array "parentTable", altering only the value for the WHERE
condition in each iteration of the loop.

notes:

rset4 is initialized outside the try-catch block as follows:
ResultSet rset4 = null;

the array parentTable is initialized as follows:

ArrayList parentTable = new ArrayList();

I am not asking a question this time round.   Just thought i would share
this info.  Also wondering if this use of ResultSet could generate
un-reliable results.

-paul.



----- Original Message ----- 
From: "Shapira, Yoav" <Yoav.Shapira@mpi.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Wednesday, October 01, 2003 8:43 AM
Subject: [OFF-TOPIC] RE: can resultset object be re-used


>
> Howdy,
> First, this is off-topic and should be marked as such.
>
> Second, the answer is no: you can't reuse them, it's one per query.  In
> fact, since ResultSet is an interface, you don't even have a constructor
> you can use (although you could always try to reflect the
> implementation).
>
> Yoav Shapira
> Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Paul [mailto:paul@msci.ca]
> >Sent: Tuesday, September 30, 2003 4:21 PM
> >To: Tomcat Users List
> >Subject: can resultset object be re-used
> >
> >jdbc question (tomcat 4.x, java 1.4.2, jdbc 3.0):
> >
> >can the ResultSet object be re-used to retrieve results from altogether
> >different sql query in same .jsp page?  Or does a new ResultSet object
> need
> >to be created for each distinct sql query?
> >
> >-paul lomack.
>
>
>
> This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential, proprietary
and/or privileged.  This e-mail is intended only for the individual(s) to
whom it is addressed, and may not be saved, copied, printed, disclosed or
used by anyone else.  If you are not the(an) intended recipient, please
immediately delete this e-mail from your computer system and notify the
sender.  Thank you.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message