hey all,
just wondering if anyone has had a similar issue with getting the ol
SQLException: Exhausted ResultSet, even though i have a while(rs.next()).
running tomcat4 (4.0 and 4.1)
oracle 9i
using the commons dbcp as the connection pool as described in the tomcat
conn pool FAQ
classes12.zip (oracle 9i thin driver)
here's the code snippet thats barfing. there is not a pattern to how many
times through the while loop it goes before it fails and spits up the
SQLException. anyone have any thoughts on the matter?
some more info: i printed out the value of rs.next() and its "true" right
before i get the Exhausted ResultSet exception. fairly interesting...
thanks in advance
t
----------
rs = DBU.executeQuery(SQL, args);
while (rs.next())
{
...
currIntID = rs.getString(1); // this statement throws an exception after
N(unknown)
// times through the while() loop
...
}
...
rs.close(),ps.close(),conn.close(),etc.
------------
--
Takeshi L Toyohara
Cauldron Solutions
Solutions Developer
212.696.1600x20 (office)
212.696.2336 (fax)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
