ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: MS Access LDB locks using JDBC-ODBC bridge and iBATIS
Date Thu, 03 Aug 2006 00:32:21 GMT
I ran across this library and thought it might be useful in dealing with
your MS Access data imports.

http://jackcess.sourceforge.net/

Brandon Goodin

On 7/29/06, AlexeyG <agorokhov@z-techcorp.com> wrote:
>
>
> Thanks for your responses!
>
> MS Access is used only for data import...  admin uploads the MS Access DB
> and I import records.  Successfully imported records get deleted, failed
> records remain.  Admin can then download the DB back and fix failed
> records.
>
> I need that lock released so that I can "compact" the Access DB by
> launching
> "access.exe *db path* /compact...  Without compacting the Access DB
> remains
> the same size even if all but few records are deleted...  It is a bit of a
> pain, but I'm pretty much stuck with that process..  At least I do not
> have
> to deal with tables to store failed import data, or write an interface to
> allow admin to fix it.
>
> Sounds like getting a good driver or using JDBC straight up and releasing
> connections is the way to go...  Thanks!
> --
> View this message in context:
> http://www.nabble.com/MS-Access-LDB-locks-using-JDBC-ODBC-bridge-and-iBATIS-tf2017245.html#a5558867
> Sent from the iBATIS - User - Java forum at Nabble.com.
>
>

Mime
View raw message