Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Cecil Westerhof <Cecil@decebal.nl>
Newsgroups: comp.lang.java.programmer
Subject: Re: Which databases are the most used with Java
Date: Tue, 15 Aug 2017 18:42:06 +0200
Organization: Decebal Computing
Lines: 16
Message-ID: <87mv70n5pd.fsf@munus.decebal.nl>
References: <87y3qovwjb.fsf@munus.decebal.nl> <omovh9$ad2$1@news.albasani.net> <87tw1bx2c9.fsf@munus.decebal.nl> <slrnop0881.o2q.avl@logic.at> <87a833wzcx.fsf@munus.decebal.nl> <evbal8Fs681U1@mid.individual.net> <87pobz9yv5.fsf@munus.decebal.nl> <afdc32bc-17ff-4ee9-ade0-c7345f805585@googlegroups.com> <87h8x9pfi8.fsf@munus.decebal.nl> <omv2lm$f5o$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Injection-Info: mx02.eternal-september.org; posting-host="72fb8bea0235c6b94245dccb186de60d"; logging-data="1655"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18UTfRDpOKR8Qs4ZQ2f+afoTM1h/oRfaBc="
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux)
Cancel-Lock: sha1:fMWnI5Atc/aN9NrPcmFJK4CYwf8= sha1:mY3mjqxvZ6bmB39jgtM5U9wFxRU=
X-Homepage: http://www.decebal.nl/
Xref: csiph.com comp.lang.java.programmer:37249

Arne Vajhøj <arne@vajhoej.dk> writes:

> As long as you complete using a ResultSet before opening the next then
> you can reuse the same Statement.
>
> But if yo do not do that then using same Statement (and same Connection
> - unlike
> it supports something like MARS) will get you in problems.

And that was my use-case: one try with resources with multiple
ResultSets. ;-)

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof