Search code examples
javadatabaseseleniumfoxpro

Reading DBF file in java/selenium


I'm trying to read a FoxPo .dbf file, but getting below error for line:

while ((rowObjects = reader.nextRecord()) != null)

ERROR:

com.linuxense.javadbf.DBFException: Failed to parse Number: empty String at com.linuxense.javadbf.DBFReader.nextRecord(DBFReader.java:310) at datamigration.DataMigration.main(DataMigration.java:34)

Your help will be appreciated.

Thanks,

Below if my code:


package datamigration;

import java.io.*;
import com.linuxense.javadbf.*;

public class DataMigration {

    public static void main(String args[]) {

        try {

            InputStream inputStream = new FileInputStream("D:/projects/DataMigration/data/customer.dbf");

            DBFReader reader = new DBFReader(inputStream);

            reader.setCharactersetName("gbk");
            int numberOfFields = reader.getFieldCount();

            for (int i = 0; i < numberOfFields; i++) {

                DBFField field = reader.getField(i);

                System.out.println(field.getName());
            }

            Object[] rowObjects;

            while ((rowObjects = reader.nextRecord()) != null) {

                for (int i = 0; i < rowObjects.length; i++) {

                    System.out.println(rowObjects[i]);
                }
            }
            inputStream.close();

        } catch (DBFException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }
}

Solution

  • Have you looked at the various 'finds' at:
    Google Search Results for: java connect to foxpro database