[OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Shapira, Yoav
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

RE: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Mike Curwen
, 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

RE: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Phillip Qin
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

RE: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Allen Hadden
: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

Re: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Jan Agermose
: 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

RE: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Phillip Qin
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

Re: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Paul
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

RE: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Walker Chris
- 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

Re: [OFF-TOPIC] RE: can resultset object be re-used

2003-10-01 Thread Nikola Milutinovic
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!

can resultset object be re-used

2003-09-30 Thread Paul
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.