Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Cecil Westerhof <Cecil@decebal.nl>
Newsgroups: comp.lang.java.programmer
Subject: Re: Which databases are the most used with Java
Date: Mon, 14 Aug 2017 00:35:13 +0200
Organization: Decebal Computing
Lines: 33
Message-ID: <87bmnjqeou.fsf@munus.decebal.nl>
References: <87y3qovwjb.fsf@munus.decebal.nl> <omovh9$ad2$1@news.albasani.net> <87tw1bx2c9.fsf@munus.decebal.nl> <omqet1$1mvv$1@gioia.aioe.org> <87fucvqg00.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="4272"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18OC4Z0XYxvvpIGXOrhve31D6mONT5/vhc="
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux)
Cancel-Lock: sha1:f0Dv3lzxte7crWI7iiuU9MWxOSw= sha1:iGZfAXyisIQpHP0QYUgizzhgHWw=
X-Homepage: http://www.decebal.nl/
Xref: csiph.com comp.lang.java.programmer:37210

Cecil Westerhof <Cecil@decebal.nl> writes:

> Arne Vajhøj <arne@vajhoej.dk> 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.

getDatabaseProductVersion() does give 3.16.1.


MetaData is something I should look into. In my abstract class I
added:
    void displayMetaData() throws SQLException {
        DatabaseMetaData dbmd = conn.getMetaData();

        System.out.println("driver version = " + dbmd.getDriverVersion());
        System.out.println("driver name    = " + dbmd.getDriverName());
        System.out.println("db name        = " + dbmd.getDatabaseProductName());
        System.out.println("db ver         = " + dbmd.getDatabaseProductVersion());
    }

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof