Subject Re: [Firebird-Java] Re: Firebird JDBC
Author Mark Rotteveel
> 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.

Did you by any chance also close the connection that was used to create the resultset, because when the connection of the resultset is closed, the resultset itself is also closed.

Mark
--
Sensationsangebot verlängert: GMX FreeDSL - Telefonanschluss + DSL
für nur 16,37 Euro/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K1308T4569a