Path: csiph.com!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 03:12:40 +0200 Organization: Decebal Computing Lines: 35 Message-ID: <87shgvostz.fsf@munus.decebal.nl> References: <87y3qovwjb.fsf@munus.decebal.nl> <87tw1bx2c9.fsf@munus.decebal.nl> <87fucvqg00.fsf@munus.decebal.nl> <87bmnjqeou.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="25212"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX181gaSuR2Gy9Vk9GjrAOKxqozoh4F8KJS4=" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux) Cancel-Lock: sha1:peG6c6lE/CUmQqp0bEtdsKCgd/Y= sha1:O/uiNRdfFUAtW1SnWuFU36JIWFE= X-Homepage: http://www.decebal.nl/ Xref: csiph.com comp.lang.java.programmer:37214 Arne Vajhøj writes: > On 8/13/2017 6:35 PM, Cecil Westerhof wrote: >> Cecil Westerhof writes: >>> Arne Vajhøj writes: >>>> On 8/13/2017 5:07 AM, Cecil Westerhof wrote: >>>>> I also created some SQLite3 specific methods: >>>>> getSQLiteVersion >>>> >>>> And what is wrong with con.getDatabaseMetaData().getDatabaseMajorVersion() >>>> and getDatabaseMinorVersion()? >>> >>> The getDatabaseMetaData needs to be getMetaData. >>> >>> This gives 3 and 0, while the correct version is: 3.16.1. > > I would tend to consider that a bug in the drivers getDatabaseMinorVersion() > implementation. Agreed. H2 (I implemented it) does give correct results. But less as getDatabaseProductVersion (1.3 -> 1.3.176 (2014-04-05), so it is better to use that. Both H2 and SQLite3 give the correct information. >> MetaData is something I should look into. > > There is a ton of useful information including some about the > SQL dialect supported. I do not have to be afraid that I will get bored. ;-) -- Cecil Westerhof Senior Software Engineer LinkedIn: http://www.linkedin.com/in/cecilwesterhof