Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.java.programmer > #28919
| From | Martin Gregorie <martin@address-in-sig.invalid> |
|---|---|
| Newsgroups | comp.lang.java.programmer |
| Subject | Re: Accessing Access database files |
| Date | 2014-07-02 21:28 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <lp1th1$1vm$1@dont-email.me> (permalink) |
| References | <lounj9$a4g$2@dont-email.me> <0ed8r9tu9n035e6s54u2ptgvlkbqg43cms@4ax.com> |
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 |
Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 16:28 +0000
Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 09:55 -0700
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 17:29 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:49 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:03 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:06 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 09:48 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-03 16:31 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 22:03 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:01 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 16:42 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:45 -0400
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:47 -0400
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:47 -0400
Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 20:11 -0700
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:05 -0400
Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-02 16:57 +1000
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:20 +0000
Re: Accessing Access database files Robert Klemme <shortcutter@googlemail.com> - 2014-07-02 20:22 +0200
Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-02 09:40 -0700
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 21:28 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:09 -0400
Re: Accessing Access database files Jeff Higgins <jeff@invalid.invalid> - 2014-07-02 17:08 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 22:39 +0000
Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-05 16:28 -0700
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 08:51 +0000
Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-06 19:01 +1000
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 17:11 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:17 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 19:30 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:10 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:26 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:27 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 22:37 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:06 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:45 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 17:50 -0400
Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 22:34 +0000
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 19:24 -0400
Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 11:55 -0400
csiph-web