Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
JDBC for DBF?
Message
From
05/05/2014 16:19:48
 
 
To
05/05/2014 14:27:01
General information
Forum:
Java
Category:
Databases
Title:
Miscellaneous
Thread ID:
01599577
Message ID:
01599582
Views:
39
>Had recently noticed that ODBC-JDBC bridge is unavailable with Java 8 (it works in Java 7 and earlier). Are there any JDBC libraries/classes for accessing FoxPro DBF/FPT files that you would recommend?


Sheesh! I just worte a long response and it didn't post.

I'd be very careful. I was involved in 2001 in a Java rewrite and we were totally dependent on a FREE Java/FoxPro JDBC driver that was completely bogus under the covers. I used FileMon to see what it was doing and why it was so slow. Well, it would look for an IDX file, but when it didn't find one it would not look for a CDX file. It had no concept of what a CDX file was. So, right there you've got severe performance issues and, worse, CORRUPTION.

After 1.5 man years of effort, the project was abandoned and written in VFP.

Keep in mind that a VFP ODBC driver has to support a lot of native VFP functions since a lot of them can be part of the index expression. Who is going to write all of those in their driver?
Previous
Reply
Map
View

Click here to load this message in the networking platform