asked on

What is the best jdbc driver for dbf (foxpro) files?

Hello,
What is the best jdbc driver for dbf (foxpro) files?

ASKER CERTIFIED SOLUTION

Mick Barry

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

ysnky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Farzad Akbarnejad

ASKER

Hi,
Thanks for your reply. What about HTXX?
http://www.hxtt.com/index.html

objects! would you please explain difference between HTXX and JStels. Do you have any reason that you say JStels is the best?

Thanks
-FA

Farzad Akbarnejad

ASKER

http://www.hxtt.com/dbf.html

Farzad Akbarnejad

ASKER

Thanks for your first link ysnky. Is it right that if I want to use FREE driver with no any limitation I must use ODBC-JDBC bridge?

-FA

SOLUTION

ysnky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Farzad Akbarnejad

ASKER

Hi,

I am searching for a free driver also. I want to test the performance in 1,000,000 records table (one dbf file). htxx is good. Also I want to test J-STEL but the performance and a preparing document for it is the first job that I must do it. It's better to find a free driver at first.

-FA

Farzad Akbarnejad

ASKER

Hi,
J-STEL makes swap file and it is very slow to run a query. My DBF file has 1 GB size.

-FA

SOLUTION

ysnky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Farzad Akbarnejad

ASKER

I guess the ODBC Driver for FoxPro by Microsoft don't use index file (*.CDX) file but the hxtt (jdbc type 4) use index if it exists. Is it right?

-FA

SOLUTION

ysnky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Farzad Akbarnejad

ASKER

Thanks for your help.

-FA