Path: csiph.com!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: Tue, 15 Aug 2017 11:09:01 -0400
Organization: Aioe.org NNTP Server
Lines: 20
Message-ID: <omv2qa$f5o$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> <afdc32bc-17ff-4ee9-ade0-c7345f805585@googlegroups.com> <87h8x9pfi8.fsf@munus.decebal.nl> <omukv5$m10$1@newsreader4.netcologne.de> <877ey5ngtu.fsf@munus.decebal.nl>
NNTP-Posting-Host: LO3gx2vFpREKIznvPHDlcg.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:37242

On 8/15/2017 8:41 AM, Cecil Westerhof wrote:
> Patrick Roemer <sangamon@netcologne.de> writes:
>> You seem to insist on Statement being an evil ploy designed by the JDBC
>> inventors to force you to write unnecessary boiler plate code when all
>> you want is just a ResultSet. Whatever follows from this line of
>> reasoning is not likely to be correct or useful, I'm afraid.
>
> I do not see Statement as an evil ploy. But I think that with try with
> resources it is something you do not need explicit anymore.

Statement is a bit "thin" in functionality.

But as soon as you move to PreparedStatement then you need that
reference.

And my guess is that you should use PreparedStatement over Statement in 95+%
of cases.

Arne