--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <roman@...>
wrote:

>
> > I'm developing a application. using a firebird database. While

reading

> > a table i randomly get a resultset already closed error.
> >
> > I'm using the jaybird 2.1.6 jar.
> >
> > Does anyons know why this is happing ??
>
> Very likely you use auto-commit mode and execute a statement using

the

> same connection while looping through the result set.
>
> Roman
>

Roman,

I close the connection after every statement execute.

This happens using a select statement.