Yes you can only have one active result set per statement.
--Barry
Felipe Schnack wrote:
> I don't know, maybe I just don't understand something about Prep. Statements, but why they have a reference to a
ResultSetit has created? To me make more sense the opposite, the ResultSets reference the Statement...
> Anyone can confirm I can only have one resultset per statement?
>
> On Fri, 25 Jul 2003 09:06:58 +0100
> Paul Thomas <paul@tmsl.demon.co.uk> wrote:
>
>
>>On 24/07/2003 19:55 Felipe Schnack wrote:
>>
>>> Can I use a single PreparedStatement to create various ResultSets and
>>>get data from all of them at the same time?
>>
>>I don't think so. The Javadoc for Statement says:
>>
>>"By default, only one ResultSet object per Statement object can be open at
>>the same time"
>>
>>To me, this suggests that some db's may allow multiple ResultSets per
>>Statement but that such extensions would be non-portable. Looking at the
>>source for AbstactJdbc1Statement, it has
>>
>>protected java.sql.ResultSet result = null;
>>
>>So it looks like PG has the one ResultSet to one Statement implementation.
>>
>>HTH
>>
>>--
>>Paul Thomas
>>+------------------------------+---------------------------------------------+
>>| Thomas Micro Systems Limited | Software Solutions for the Smaller
>>Business |
>>| Computer Consultants |
>>http://www.thomas-micro-systems-ltd.co.uk |
>>+------------------------------+---------------------------------------------+
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>
>
>
