We noticed as we have been testing the JDBC DBF Driver that when we initially created our working directory, loaded and started running our code that our CDX (index) files were not being updated.

In our first attempt we laid our directories out as follows :

/pinnacle/systema (containing the tables we wanted to update)
/pinnacle/systema/ebay (containing our java code which was to update the tables)

each time we ran the code using these directories the .dbf files were updated, but the .cdx files were not (and we received no exceptions).

we then took the java code and moved it to another directory - initially /tmp (the data remained in the same directory), and ran it. Running from this new directory both the .dbf and .cdx files were now updated (the code was exactly the same as before -- we had not changed it in any way).

we then moved the same code to /pinnacle/ebay and tried the same again,
and again it worked just fine..

we found the same results on machines running Fedora Core 3, and SCO OpenServer.

Re:Directory problems

HXTT Support

2006-04-10 02:21:47.0

What's your jdbc url? What're the table file name and cdx file name?

Re:Re:Directory problems

tony burgess

2006-04-10 02:29:45.0

workord.dbf + cdx
wodetail.dbf + cdx

JDBC Url: jdbc:dbf:////pinnacle/systema

Re:Re:Re:Directory problems

HXTT Support

2006-04-10 04:13:29.0

Recurred and supported. Please download the latest package.

BTW, you need to run "reindex all on workord;reindex all on wodetail;" sql once to fixe those inconsistent update in your "/pinnacle/systema/ebay" test.