Re: Pooling Prepared Statements

>You are right. It's  1 statement -> 1 resultset at a time.
>
>As Dave said: "A ResultSet object is automatically closed when the 
>Statement object
>that generated it is closed, re-executed, or used to retrieve the next 
>result from a sequence of multiple results. "
>
>My mistake.

It is still a good idea to close result sets after use. If you 
rely on automatically closing them you might have some wasted 
resources lying around because you might execute a statement 
and never reuse it.

It is also a good idea to explicitly close statements and 
connections.

Best regards
Rainer Klute

                           Rainer Klute IT-Consulting GmbH
  Dipl.-Inform.
  Rainer Klute             E-Mail:  klute@rainer-klute.de
  Körner Grund 24          Telefon: +49 172 2324824
D-44143 Dortmund           Telefax: +49 231 5349423