Re: I'm losing the data from a ResultSet

From: Kris Jurka <books(at)ejurka(dot)com>
To: Waldomiro <wmiro(at)ig(dot)com(dot)br>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: I'm losing the data from a ResultSet
Date: 2004-01-12 20:59:08
Message-ID: Pine.LNX.4.33.0401121556040.9249-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 12 Jan 2004, Waldomiro wrote:

> hi there,
>
> I have a instance of a ResultSet which I've loaded some data from a table.
>
> sometime later I create a second instance of a ResultSet for some data
> from other table, but the fisrt instance of a ResultSet lost the data.
>

You most likely have reused a Statement object. When you do this the
first ResultSet is discarded. If you want two open ResultSets at the same
time, you need two Statement objects.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Warren Little 2004-01-12 22:11:43 What happens to a ResultSet when statement closed
Previous Message Waldomiro 2004-01-12 20:52:49 I'm losing the data from a ResultSet