Path: csiph.com!usenet.pasdenom.info!aioe.org!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: Sun, 6 Jul 2014 08:51:04 +0000 (UTC)
Organization: A noiseless patient Spider
Lines: 37
Message-ID: <lpb2ln$j4$2@dont-email.me>
References: <lounj9$a4g$2@dont-email.me> <6d2hr9pqv6rsreb625hdirnlvvuh3t8cpl@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 6 Jul 2014 08:51:04 +0000 (UTC)
Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="612"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18eMWS2fy43LgWcY7kgpAHxfMRp5dvYikE="
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock: sha1:sihqLH8nswh7Lb/rdbT9ZOW0tFA=
Xref: csiph.com comp.lang.java.programmer:28957

On Sat, 05 Jul 2014 16:28:02 -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?
> 
> Would a solution of this form be feasible?
> 
> 1. Persuade Access to export its data in some simple form, e.g. CSV 2.
> import into some more tractable database like PostGre.

Thats not needed: just install the UCanAccess JDBC driver.

There can be major problems with moving data from one RDBMS to another. 
While its relatively simple to do if the source schema was fully 
normalised, i.e. all tables are in 3NF, there are still potential 
problems that arise from differences between SQL dialects since very few 
RDBMSs implement fully standards-compliant SQL: PostgreSQL is one of the 
better ones. Common problem areas include migrating schemas between RDBMSs 
that implement auto-incrementing data types and those that use sequences 
and there can be problems with BLOBs and CLOBs.

A big issue with Access databases is that they have often been cobbled 
together by a non-specialist who have never heard of normalisation, 
referential integrity or prime keys and who think that tables containing 
arrays and lots of derived values are the bee's knees. Don't ask me how I 
know.....
   

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