Driver Download For Windows 10
Can anybody please mention the best available opensource odbc:jdbc driver to read / write dbf.?I have a dbf file which I would like to query (select/update) via a web application (Tomcat app).
Foxpro JDBC Driver from DbSchema. Java Driver Class: com.hxtt.sql.dbf. Download Foxpro JDBC Driver. Free download and install DbSchema to get the JDBC driver.
Any help/tips would be appreciative.
Thank you.
pinkbpinkbclosed as not constructive by WillApr 25 '13 at 19:43
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
3 Answers
It works. And I guess there will be no need to explore for other (open/closed) apis as Java has provided an excellent way to read/write dbf.
Thank you all.
pinkbpinkbYou can try to use https://github.com/iryndin/jdbf - a simple Java library to read/write DBF files. I am the author of this library and it works quite good in my production apps. It is very simple.
Please give it a try.
iryndiniryndindans-dbf is a good option to access dbf files, but it has a custom api (ie: not sql).
I would recommend you to dump the dbf files into db tables (mysql with myisam engine will do the trick or innodb if transaction/consistency checking is required).
Then you can dump back to dbf as needed.