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();
}
}
}
Have you looked at the various 'finds' at:
Google Search Results for: java connect to foxpro database