>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