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 ResultSet it 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(at)tmsl(dot)demon(dot)co(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--

/~\ The ASCII Felipe Schnack (felipes(at)ritterdosreis(dot)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(at)ritterdosreis(dot)br
Fone: 51-32303341