Hello,
After an update to a DBF file, the index is adjusted.
However, if I want to work in the dBase tool always comes DBFCDX/8009 file error. When I work on my old tool reorganize this table everything works again.How Can I initiate using the JDBC driver, which he executes the index on the entire table? or is there another possibility?
|
First, backup your table file, then run once "reindex all on yourTable" through HXTT DBF, then check whether your dBase tool can read it normally. If failed, you can use lockType=Alaska connection property, then run once "reindex all on yourTable" through HXTT DBF, then check whether your dBase tool can read it normally. If failed still, you should use your dBase tool to reindex your table file, then email us your databases file sample.
|
where exactly should I use the locktype?
jdbc: dbf :/ / / / / path / CharSet = cp850?
|
jdbc:dbf:////path?charSet=Cp850;lockType=Alaska
|
If I use the JDBC URL so eingebe. Can I use the program that uses the dBASE database, this can not create more records. There is always hanging. Are there other versions of the lockType?
|
>Can I use the program that uses the dBASE database, this can not create more records. There is always hanging.
You should use lockType=DBASE . It's listed at here.
lockType: To specify a compatible lock for other applications. You can use DBASE, DBASE4BDE, DBASEIII, DBASEIV, CLIPPER, CLIPPER5.3, PowerPlus, Alaska, SoftC, FOXBASE, FOXBASE4UNIX, FOXPRO, FOXPRO4UNIX, FOXPRO4BDE, and VFP.
BTW, if your index file can be read nomally after run ONCE "reindex ...", then you need only the correct lockType connection property to let HXTT DBF and your dBase tool to begin concurrent data modification in future operation.
|