I have a java web application that is using the db2jcc driver to get a
connection to a DB2 database that is located on an RS 6000 server.
The here is a portion of the code that is giving me a problem.
rs is an ResultSet object instantiated by the following...
detailStmt = vmCon.prepareStatement(detailSelect);
detailResults = detailStmt.executeQuery();
if (rs.next())
{
do something
}
now when the resultset returns any records the code performs fine.
when it returns an empty resultset it throws the following exception
com.ibm.db2.jcc.a.SqlException: Invalid operation: result set closed
the web app is running on a RS 6000 server as well...
we are running the app in websphere WAS 5.0 environment.
does anyone have any clue as to what could be causing this problem?
Thanks