I have a DBF table with 38761 rows.
select count(*) from history returns this number of rows.
select * from history generates an error messsage 'Statement failed'
SELECT top 2696 * FROM history returns the first 2996 rows but
SELECT top 2697 * FROM history generates the 'Statement failed' error message
The schema for the table (according to Aqua)
DATE DATE(8)
TYPE VARCHAR(1)
FILE_NAME VARCHAR(12)
PROV_GROUP VARCHAR(4)
PROV_NUM VARCHAR(6)
SUBMISSION NUMERIC(9)
ADJUSTMENT NUMERIC(9)
REMITTANCE NUMERIC(9)
C_FLAG VARCHAR(1)
Please let me know....
Thanks,
Martin
|
You can try:
catch (SQLException sqle) {
do {
System.out.println(sqle.getMessage());
System.out.println("Error Code:" + sqle.getErrorCode());
System.out.println("SQL State:" + sqle.getSQLState());
sqle.printStackTrace();
}
while ( (sqle = sqle.getNextException()) != null);
}
to see the detailed exception message.
I tested those sqls with 131072 rows with the same table structure, but failed to recur your issue. It seems that HXTT DBF failed to read the row of 2697 for unknown reason.
|