So far your code doesn't look thread safe, therefore not appropriate for
use in a servlet. If this code is in an object created per thread it might
be ok, otherwise you should make all the variables (including the not shown
Connection) local to the method.

If this doesn't work you might try the client-java driver, you are more
likely to get answers about driver issues.

david jencks

On 2002.09.05 08:30:55 -0400 "Hagerty, Tim" wrote:
>
> 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
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>