Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Martin Gregorie <martin@address-in-sig.invalid>
Newsgroups: comp.lang.java.programmer
Subject: Re: Accessing Access database files
Date: Wed, 2 Jul 2014 21:28:01 +0000 (UTC)
Organization: A noiseless patient Spider
Lines: 37
Message-ID: <lp1th1$1vm$1@dont-email.me>
References: <lounj9$a4g$2@dont-email.me> <0ed8r9tu9n035e6s54u2ptgvlkbqg43cms@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 2 Jul 2014 21:28:01 +0000 (UTC)
Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="2038"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/ff48RM1Mq6GSFKPJW1lCriFjXWaWqDKs="
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock: sha1:tY1SwvpjAwgPYlSBhd1ESlgD6uo=
Xref: csiph.com comp.lang.java.programmer:28919

On Wed, 02 Jul 2014 09:40:30 -0700, Roedy Green wrote:

> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
> someone who said :
> 
>>Is there a JDBC driver or non-JDBC class library that would give a Java
>>program read/write access to the tables and schema in a MS Access
>>database?
> 
> have a look at http://mindprod.com/jgloss/jdbc.html
> 
> under the ODBC bridge.  I that is how you can get at them, not wildly
> efficient, but I doubt you need it.
>
There appear to be better solutions than the ODBC bridge.

I haven't tried using it yet, but UCanAccess + Jackcess + HSQLDB together 
make up a JDBC driver, it says, that can read and write Access databases 
without a byte of Windows code being involved. It appears that the whole 
thing fits together like this:
 - Jackcess 2.0 understands the Access file structure at the 
   schema/table/locking(I think) level
 - HSQLDB 2.25 contributes the SQL engine 
 - UCanAccess 2.x.x binds it all together and turns it into a functional 
   JDBC driver.

I like JDBC: I've been using it for a while now to access a PostgreSQL 
database. Performnance is better than I initially expected and it pretty 
much 'just works' and keeps on doing so despite software, hardware and OS 
upgrades.

 
-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |