Path: csiph.com!news.redatomik.org!aioe.org!.POSTED!not-for-mail
From: =?UTF-8?Q?Arne_Vajh=c3=b8j?= <arne@vajhoej.dk>
Newsgroups: comp.lang.java.programmer
Subject: Re: Which databases are the most used with Java
Date: Sun, 13 Aug 2017 16:43:27 -0400
Organization: Aioe.org NNTP Server
Lines: 28
Message-ID: <omqdld$1ksm$2@gioia.aioe.org>
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> <evbju8Fuap3U1@mid.individual.net> <87d17zs1sx.fsf@munus.decebal.nl>
NNTP-Posting-Host: 5VufzpQaY1AiVRqLF21lbg.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0
X-Notice: Filtered by postfilter v. 0.8.2
Xref: csiph.com comp.lang.java.programmer:37198

On 8/13/2017 3:30 PM, Cecil Westerhof wrote:
> Robert Klemme <shortcutter@googlemail.com> writes:
>> On 13.08.2017 19:11, Cecil Westerhof wrote:
>>> Robert Klemme <shortcutter@googlemail.com> writes:
>>>> On 13.08.2017 12:12, Cecil Westerhof wrote:
>>>>> Andreas Leitgeb <avl@logic.at> writes:
>>>>>> And if I ever need ten bricks, I'll just call it ten times...
>>>>>
>>>>> If you need 10 ResultSets, you also need 10 Statements.
>>>>
>>>> This is wrong.
>>>
>>> What is wrong about that? A Statement can only have one ResultSet. So
>>> if you have 10 (independent) ResultSets you have 10 Statements.
>>
>> There are several ways to get more than one ResultSet from a Statement.
>> The simplest is to invoke executeQuery(String) multiple times.  There
>> are more fancy approaches like the batch processing.
>
> Then you need several try with resources, or risk a resource leak.

Yes.

:-)

Arne