Hey,
I'm attempting to access a DBF/flexFile III datasource via the HXTT DBF 5.2 but am getting an error:
java.sql.SQLException: Failed to get an int value from [B: '
meta data from the HxttRowSet shows the flexfileIII column as LONGVARCHAR, not sure if that is correct or not. I am also able view the DBF data if I leave the flexFile III column out of the select statement.
Any help/tips would be very appreciated.
Thanks,
Alex
|
|
You should email us your dbf/dbt sample. If your table contains sensitive data, you should backup it, and delete other rows except for the row which results that issue, and pack it.
|
|
I can't really do this as the sensitive data is in both the DBF and DBV and I cannot access the DBV to remove this data. Are there any other options that I can do on this end?
|
|
Youre mem file is .dbv suffix?
|
|
You can backup your dbf/dbv file, then zap it(which will result an empty table file), then insert a test row which contains value for your flexfileIII column, then email it.
|
I believe I have the issue figured out. It appears this is using flexfile II and the contents with in the memo field are compressed, hence why I was seeing the 'garbled' text and the exception didn't make sense.
So I assume HXTT DBF doesn't support FlexFile II and/or compressed memo files?
|
|
Yeah. FlexFile3 is supported, but we haven't see any FlexFile II sample. If you can provide such a sample, then we can try to support it.
|
Main
webmaster@hxtt.com