Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.137
  HXTT Cobol 5.0.137
  HXTT DBF 7.1.138
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel 6.1.141
  HXTT Json 1.0.109
  HXTT Paradox 7.1.137
  HXTT PDF 2.0.137
  HXTT Text(CSV) 7.1.137
  HXTT Word 1.1.137
  HXTT XML 4.0.138
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
memo file erquired when memo field not specified in table
Pushkarraj Deshpande
2006-09-18 23:44:54.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:02:20.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:)
Re:Re:memo file erquired when memo field not specified in table
Pushkarraj Deshpande
2006-09-19 01:24:47.0
ok.
The error was still appearing after changing the versionNumber to 03. As removing the table will also remove the indexes, i took out the dropping index statement from the code. and am using 03 as a version. It is working.

Thanks much for your response.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap