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).
Any help/tips would be appreciative.
Thank you.
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).
Any help/tips would be appreciative.
Thank you.
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.
dans-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.
You 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.