Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
memo file erquired when memo field not specified in table
Pushkarraj Deshpande
2006-09-19 01:20:36.0
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
Re:memo file erquired when memo field not specified in table
HXTT Support
2006-09-19 01:25:46.0
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:)

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap