Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Andreas Leitgeb <avl@logic.at>
Newsgroups: comp.lang.java.programmer
Subject: Re: it's Closeable, but I don't want to close() it yet.
Date: Fri, 1 Mar 2019 08:47:53 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 10
Message-ID: <slrnq7hsdp.cfl.avl@logic.at>
References: <slrnq7dcgo.cfl.avl@logic.at> <709a1f3b-fc99-4bd0-a8b8-866092bb7ae9@googlegroups.com> <slrnq7dnnu.cfl.avl@logic.at> <8e1597a2-5c18-4fd1-83a4-7667e4d11e77@googlegroups.com> <slrnq7fkg8.cfl.avl@logic.at> <23a8128b-5c54-45ba-bfd0-2f7dda078517@googlegroups.com> <fdb81cf4-61e8-4b09-a62f-c97253f23550@googlegroups.com> <f71c1d05-cc27-4ecb-bea0-c32f03cd698e@googlegroups.com> <692da128-9302-41cf-a8f7-2a2a5903bf82@googlegroups.com> <3a4ed199-10a5-4ea3-882e-8d598a82dccf@googlegroups.com> <ab24ddfd-0235-4d43-8b9c-20cb8083df28@googlegroups.com> <6f5e7b36-af8f-4f1b-b7fe-f53305b8d591@googlegroups.com> <263782da-7ef6-466c-8cb3-da394bef0501@googlegroups.com> <c2f2bba3-b6af-4c7b-9a9d-a39e7c7bae0f@googlegroups.com> <da8a7268-740d-494e-a980-c4105c8133b4@googlegroups.com>
Reply-To: avl@logic.at
Injection-Date: Fri, 1 Mar 2019 08:47:53 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="c144b748bf03aa5835b53744c000c08a"; logging-data="17840"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+VBKRkD4IrIVIQR1xQ9N4u"
User-Agent: slrn/1.0.3 (Linux)
Cancel-Lock: sha1:59RpKOi6c7GAL4og464GSU2933U=
Xref: csiph.com comp.lang.java.programmer:38772

Eric Douglas <e.d.programmer@gmail.com> wrote:
> I see some old stackoverflow threads that say if you don't
> explicitly close the ResultSet and keep creating new ones
> it had a problem with a "too many open cursors" error.
> Is that still true?

I'd suspect that the respective asker misrepresented the
situation. Maybe they really created new PreparedStatements,
without close()ing, rather than new ResultSets.