Friday, August 9, 2002 04:43 AM
This depends upon whether you are trying to keep open multiple result sets and process them. JDBC 2.0 doesn't allow this, but I think JDBC 3.0 does (We haven't implemented any 3.0 compliant drivers, yet).
I have had to get the information from the first result set, put it in a Collection. Close the result set AND the statement. Then, open a new statement and result set....
Anyone else have any other solutions?