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 00:06:55 +0200 Organization: Decebal Computing Lines: 27 Message-ID: <87fucvqg00.fsf@munus.decebal.nl> References: <87y3qovwjb.fsf@munus.decebal.nl> <87tw1bx2c9.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="32231"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/SZ1l0WHmBKelA47BJbxv+GMLlA3BKJHY=" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.5 (gnu/linux) Cancel-Lock: sha1:e7fzzySj0UeJUmcTex2konlswrQ= sha1:jQF4xIChqW0W+vlK6Qz0NTVRusk= X-Homepage: http://www.decebal.nl/ Xref: csiph.com comp.lang.java.programmer:37209 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. >> isDBLocked > > And that can't be done using standard JDBC? Not as far as I know. It is something specifically with SQLite3. Only one program can mutate the database. If you do something with the DBBrowser, but forget to update, that wrecks havoc. That is why I have a cronjob that twice every hour checks all databases on being locked. -- Cecil Westerhof Senior Software Engineer LinkedIn: http://www.linkedin.com/in/cecilwesterhof