Millennium ChemInformatics
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
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
, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:44 AM
To: Tomcat Users List
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
Isn't statement.executeQuery?
-Original Message-
From: Mike Curwen [mailto:[EMAIL PROTECTED]
Sent: October 1, 2003 9:58 AM
To: 'Tomcat Users List'
Subject: RE: [OFF-TOPIC] RE: can resultset object be re-used
Well I just gotta say that's not true. You *can* re-use a resultset
object
:58 AM
To: 'Tomcat Users List'
Subject: RE: [OFF-TOPIC] RE: can resultset object be re-used
Well I just gotta say that's not true. You *can* re-use a resultset
object.
ResultSet rs = st.executeQuery(SELECT * FROM FOO);
//code that loops over rs and outputs results...
rs
: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:44 AM
To: Tomcat Users List
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
Isn't statement.executeQuery returning a new ResultSet object?
-Original Message-
From: Phillip Qin [mailto:[EMAIL PROTECTED]
Sent: October 1, 2003 10:00 AM
To: 'Tomcat Users List'
Subject: RE: [OFF-TOPIC] RE: can resultset object be re-used
Isn't statement.executeQuery?
-Original
of ResultSet could generate
un-reliable results.
-paul.
- Original Message -
From: Shapira, Yoav [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:43 AM
Subject: [OFF-TOPIC] RE: can resultset object be re-used
Howdy,
First, this is off-topic
-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:44 AM
To: Tomcat Users List
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
Well I just gotta say that's not true. You *can* re-use a resultset
object.
ResultSet rs = st.executeQuery(SELECT * FROM FOO);
//code that loops over rs and outputs results...
rs = st.executeQuery(SELECT * FROM BAR);
//a re-used ResultSet object.
You're not re-using anything here, pal!
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.
10 matches
Mail list logo