I am getting the following exception, the
These are the calls I am making, my other tables are getting created, but this one does not. This table does not have a memo column, but HXTT DBF is throwing a error of that message. e.getSQLState()===>60000 e.getErrorCode()===>393216
java.sql.SQLException: Failed to find or open the relative memo file for E:\UP_SADD.DBF .
Staments
DROP TABLE IF EXISTS UP_SADD
CREATE TABLE UP_SADD ( ORDERNO NUMERIC(7), TRACKINGNO CHAR(8), SA_UNIQUE CHAR(10), ARC_DATE DATE, SA_LINENO NUMERIC(3), SA_ST_NUM CHAR(10), SA_ST_NAME CHAR(30), SA_ST_TYPE CHAR(4), SA_PO_BOX NUMERIC(6), SA_ST_DIR CHAR(2), SA_CODE CHAR(3), SA_COUNTY CHAR(25), SA_CITY CHAR(28), SA_STATE CHAR(2), SA_ZIP CHAR(5), SA_ZIP4 CHAR(4), C_REF CHAR(12), S_REF CHAR(12), R_REF CHAR(12), M_REF CHAR(12), M_MVRNO CHAR(22), SA_CWC BOOLEAN, SA_SWC BOOLEAN, SA_NWC BOOLEAN, SA_CWR BOOLEAN, SA_MVR BOOLEAN, SA_MVP BOOLEAN, SA_STATE_N CHAR(25) );";
INSERT INTO UP_SADD ( ORDERNO, SA_LINENO, SA_ST_NAME, SA_CITY, SA_STATE, SA_ZIP, SA_ZIP4 ) VALUES ( ? , ? , ? , ? , ? , ? , ? );";
DROP INDEX ALL ON UP_SADD ;
CREATE INDEX IF NOT EXISTS ORDERNO , ORDERNO_LN OF UP_SADD.CDX ON UP_SADD ( orderno , STR(orderno,7)+STR(sa_lineno,2) );").toString();
Exception
Failed to load table UP_SADD! For more information, please use SQLException.getNextException().
java.sql.SQLException: Failed to load table UP_SADD! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.i.void(Unknown Source)
at com.hxtt.sql.dbf.i.null(Unknown Source)
at com.hxtt.sql.dbf.d.do(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at aaa.bbb.ccc.transform.PSDFoxproAdapter.dropAndCreateAddressDBF(PSDFoxproAdapter.java:28)
at aaa.bbb.ccc.PSDResultProcessor.main(PSDResultProcessor.java:78)
java.sql.SQLException: Failed to find or open the relative memo file for E:\UP_SADD.DBF .
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.i.void(Unknown Source)
at com.hxtt.sql.dbf.i.null(Unknown Source)
at com.hxtt.sql.dbf.d.do(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at aaa.bbb.ccc.transform.PSDFoxproAdapter.dropAndCreateAddressDBF(PSDFoxproAdapter.java:28)
at aaa.bbb.ccc.PSDResultProcessor.main(PSDResultProcessor.java:78)
e.getSQLState()===>60000
e.getErrorCode()===>393216
|
|
Sorry for the wrong answer int the prior answer. F5 is a version for memo file, and you can't use it. That issue is resulted by versionNumber=F5. You can only use 02 , or 03. The preferable value is 03. We will add support to convert automatically all wrong F5 connection property into 03 in the next minor version:)
|
Main
webmaster@hxtt.com