I have a program that runs on a server AIX, which retrieves data from an Oracle database for insert into a database Access. The base Access is on another server citrix which is accessed via samba.
The treatment is to send about 15 000 lines of data into a table containing columns of text and boolean. Very often, but not systematically data are inaccessible "Bookmark invalid" in the table Access.
What can I do to solve this problem ?
|
>but not systematically data are inaccessible "Bookmark invalid"
>in the table Access.
Whether that mdb file can be read normally by MS Access after copy to local host?
|
The database is locked, I have to fix it.
Do you think it does not work properly because samba ?
|
>Do you think it does not work properly because samba ?
MS Access and HXTT Access cant do concurrent update on the same mdb file at the same time because they're using different lock mechanism.
|
My treatment runs in the morning at 5am when nobody uses.
It fills an empty table. At 8am an other treatment reads the data and then deletes all
|
First, you shoulduse delayedClose=0 connection property.
delayedClose: Indicates the delayed seconds for close transaction. That option is used to avoid frequent close/open table operations for following sqls. You can use 0~120 seconds. Default: 3.
Secondly, you should remember to close your HXTT Access connection after you commit ted all inserted data.
>The database is locked, I have to fix it.
Then you should avoid a lock database.
After that, please check "Whether that mdb file can be read normally by MS Access after copy to local host?" BTW, please use the latest HXTT Access v3.1 package for test.
|
Main
webmaster@hxtt.com