Re: I'm losing the data from a ResultSet - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: I'm losing the data from a ResultSet
Date
Msg-id Pine.LNX.4.33.0401121556040.9249-100000@leary.csoft.net
Whole thread Raw
In response to I'm losing the data from a ResultSet  ("Waldomiro" <wmiro@ig.com.br>)
List 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



pgsql-jdbc by date:

Previous
From: "Waldomiro"
Date:
Subject: I'm losing the data from a ResultSet
Next
From: Warren Little
Date:
Subject: What happens to a ResultSet when statement closed