I don't think you need to close the statement and result set between queries. In fact, I think you shouldn't. Try just having rs.close() and stmt.close() only once at the end of all the queries.
ChrisC ps. these are not really tomcat questions > -----Original Message----- > From: Nicholas Orr [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 30, 2002 4:22 PM > To: Tomcat Users List > Subject: Having a Newbie Delamere here. > > > Again coming from the ASP world of doing things. > in ASP you can open a connection to a Database (DB) and > execute a bunch of > queries and do whatever you need to then after you have > finished close the > connection. > > Now I have tried to do this in jsp, but not having much luck. > Keep getting > 'Result set type is TYPE_FORWARD_ONLY' > > Cause In ASP when you start a new ResultSet, after you have closed the > previous one, (asp equiv = recordset) It automatically goes > back to the > begining as it should, but in jsp it seems to just hang > around at rs.last(). > > !I don't know! > > Well if you could help, I would appreciate it, Source included. > > Regards, > > Nicholas > > > > > ********************************************************************** > The information contained in this e-mail is confidential and is > intended only for the use of the addressee(s). > If you receive this e-mail in error, any use, distribution or > copying of this e-mail is not permitted. You are requested to > forward unwanted e-mail and address any problems to the > MIM Holdings Limited Support Centre. > > For general enquires: ++61 7 3833 8000 > Support Centre e-mail: [EMAIL PROTECTED] > Support Centre phone: Australia 1800500646 > International ++61 7 38338042 > ********************************************************************** > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
