We are using the newest DBF_JDBC30 and see that it is writing corruped dbf files. The files are corrupt in the sense that neither Excel 2000 nor certain other apps, like ESRI ArvView can read them. The problem seems to surround writing a BigDecimal
We are wrting a testcase to demonstrate it but I think if you just read the attached dbf file, which is good, and write it back out to a new file (table), you will see the problem.
You can download the good dbf input file at:
http://www0.drillinginfo.com/poly.dbf
|
Passed test with "create table test1 select * from poly".
>The files are corrupt in the sense that neither Excel 2000 nor certain other apps,
It's normal, because Excel 2000 supports only dbase III format, and doesn't know VFP format. You can use versionNumber=03 connection property, then your issue will disappear:)
|