Access Pervasive/Btrieve DB (DDF + DAT files) from Java

Question

I have a folder with *.DDF and *.DAT files that are a pervasive/btrieve database. I am able to open and see the content of the database with DDF Periscope (ddf-periscope.com).

I can export data from each table individually using ddf periscope, and I would like to do the same thing using Java. Access the data in the DB and export them to a CSV file, POJOs or any way I can manipulate the data.

Is this possible?

Answer 1

You can use either JDBC or the JCL interfaces to access the data. You do still need the Pervasive engine but you can use Java. Here is a simple sample for the JDBC driver. I don't have a JCL sample but there should be one in the Pervasive / Actian Java Class Library SDK.