Path: csiph.com!news.swapon.de!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Cecil Westerhof Newsgroups: comp.lang.java.programmer Subject: Re: Which databases are the most used with Java Date: Mon, 14 Aug 2017 10:24:53 +0200 Organization: Decebal Computing Lines: 34 Message-ID: <87o9ripne2.fsf@munus.decebal.nl> References: <87y3qovwjb.fsf@munus.decebal.nl> <87tw1bx2c9.fsf@munus.decebal.nl> <87o9rjqhgt.fsf@munus.decebal.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Injection-Info: mx02.eternal-september.org; posting-host="b5e51ead2eb93bf4772adfe6a7284a95"; logging-data="17596"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+zWNDCHbSu+L+kQECOryeIhZfHfqIsHSE=" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux) Cancel-Lock: sha1:KWUBloO8uEf453BRZO6sRc2cDak= sha1:eD+xcwUhdUbJSL+u/ADuWgWRce4= X-Homepage: http://www.decebal.nl/ Xref: csiph.com comp.lang.java.programmer:37218 Arne Vajhøj writes: > On 8/13/2017 5:35 PM, Cecil Westerhof wrote: >> Arne Vajhøj writes: >>> On 8/13/2017 2:30 PM, Robert Klemme wrote: >>>> 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). >>> >>> There are two ways to handle the database specific stuff: >>> A) Sub-typing >>> B) Utilizing the builtin stuff in JDBC like DatabaseMetaData and >>> escape syntax >>> >>> #A is common but #B is severely underutilized in my opinion! >> >> Can you point me to resources where I can learn about that? > > I think you already found DatabaseMetaData class documentation. > > Escape syntax is actually more tricky to find general information about. > > Some googling found: > > https://docs.oracle.com/javase/1.5.0/docs/guide/jdbc/getstart/statement.html#1006519 Thanks, I will look into it. -- Cecil Westerhof Senior Software Engineer LinkedIn: http://www.linkedin.com/in/cecilwesterhof