Subject | Closed ResultSet issue |
---|---|
Author | Hagerty, Tim |
Post date | 2002-09-05T12:30:55Z |
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
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