Subject Closed ResultSet issue
Author Hagerty, Tim
Hi,

I'm using Tomcat 4.01, jdk 1.4, firebird 1.0.0.796, interclient 2.01 and
im having an issue with the following error message,

"interbase.interclient.InvalidOperationException: [interclient] Invalid
operation on a closed result set."

heres my code:

public java.sql.Statement stmt;
public String query;
public ResultSet resultSet;
public ResultSetMetaData metaData;

query = "SELECT * FROM REQUIREMENTS WHERE RPO_ID = " + rpo_id + " ORDER
BY REQ_ORDER";
resultSet = stmt.executeQuery(query);

It bombs on the following line:
metaData = resultSet.getMetaData();

I know its not the metadata statement itself since it will bomb on any
action preformed on resultSet since it thinks its closed.

If I refresh my jsp page the transaction goes thru just fine.

Any ideas?
Tim