I got this error message: java.sql.SQLException: Can't parse index expression txntype=>"300" when I was trying to run a simple select on a table. I ran the same type of simple select query on a different table and there was no problem. It returned the data properly. I am using your demo HXTT DBF Driver: DBF_JDBC30.jar. Both of the tables have .dbf, .fpt, & .cdx files. The key thing to know is that the field called txntype should not be the index field. I don't know what the index field should be (possibly ORD or FIND or something else).
|
>The key thing to know is that the field called txntype should not be the index
> field. I don't know what the index field should be (possibly ORD or FIND or
> something else).
Please email us the dbf and cdx sample
|
I was able to solve this problem by using the properties to tell the dbf driver to not load the indices:
Properties properties = new Properties();
properties.setProperty("loadIndices", "false");
However, I may still want to fix this problem. If I still need help with this, I will write back at that time. Thank you anyway.
|
Yeah. If we received your dbf and index file sample, we will support it.
|