Path: csiph.com!aioe.org!.POSTED!not-for-mail From: =?UTF-8?Q?Arne_Vajh=c3=b8j?= Newsgroups: comp.lang.java.programmer Subject: Re: Which databases are the most used with Java Date: Wed, 16 Aug 2017 21:21:15 -0400 Organization: Aioe.org NNTP Server Lines: 39 Message-ID: References: <87y3qovwjb.fsf@munus.decebal.nl> <87tw1bx2c9.fsf@munus.decebal.nl> <878tins1li.fsf@munus.decebal.nl> NNTP-Posting-Host: PBuS014lhzVyHjLbXmo/ZQ.user.gioia.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 Content-Language: en-US X-Notice: Filtered by postfilter v. 0.8.2 Xref: csiph.com comp.lang.java.programmer:37257 On 8/13/2017 4:24 PM, Sebastian wrote: > Am 13.08.2017 um 21:35 schrieb Cecil Westerhof: >> Robert Klemme writes: >>> Another aspect of the original question that puzzled me right from the >>> start: why does it matter at all what JDBC driver is really used. Since >>> all the types are interfaces anyway _any_ JDBC driver should work with >>> the wrapper library (except vendor specific things which require >>> specific types anyway). >> >> The only things that differs (as long as you only use generic >> functionality) is the URLPrefix. That is why I think it is not much >> work to generate the other concrete classes when the abstract and >> first concrete class are finished. >> > That's a bit optimistic. JDBC as a standard is a little vague, Better than most database API's. I really like the capabilities in the DatabaseMetaData. > and > surprising things can happen, starting with your mapping from database > types to Java SQL types (NUMERIC?, REAL?, DECIMAL?... - and this can > change even when updating from version of a driver to another of the > same vendor). ???? JDBC defines mapping for standard types. NUMERIC and DECIMAL maps to BigDecimal. REAL maps to float or Float depending on context. > Then there are the peculiarities of caching, dealing with > cursors, how to write your queries they are optimized etc. Portable code can not always be max optimized. Arne