Re: quick question about PreparedStatements

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


--

 /~\ The ASCII        Felipe Schnack (felipes@ritterdosreis.br)
 \ / Ribbon Campaign  Analista de Sistemas
  X  Against HTML     Cel.: 51-91287530
 / \ Email!           Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone: 51-32303341