ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Boden <list...@pandora.be>
Subject Re: MS Access LDB locks using JDBC-ODBC bridge and iBATIS
Date Thu, 03 Aug 2006 15:32:33 GMT

You might also consider Kettle ;-) http://kettle.javaforge.com ... but 
this is getting pretty OT.

Regards,
Sven

Brandon Goodin wrote:
> 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