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
Improper result of search byte value in column of character type
Transer
2009-11-30 06:22:22.0
Hi!
I trying to find data in character column by byte[] parameter, but result depends on applied values. In general SQL SELECT returns ResultSet with proper row, but for several search values ResultSet is empty. For search values was used data from same table.

Table has a type of FoxPro 2.5 for DOS, versionNumber - "F5", code page - CP866.
JDBC driver - evaluation version of DBF_Embedded_JDBC40.jar (Implementation-Version: 4.2.103 on November 05, 2009, Specification-Title: HXTT DBF JDBC 4.0 Embedded Package For Evaluation).
Index file was deleted from FoxPro (delete tag all) to isolate problem.

Test conditions:
1 Source ResultSet with all rows of table was created (by query "select * from table").
2 Run iteration of source ResultSet
3 On each step:
get source value from character field:
byte[] b = rsSource.getBytes("field");
run prepared statement to search by source value in database table:
stmtFind = connection.prepareStatement("select * from table where field=?");
stmtFind.setBytes(1, b);
ResultSet rsFind = stmtFind.executeQuery();

Result: rsFind in general returns data, but did not contains row for several search values taken from same table.

This problem is blocks future licensed use of driver for production system.

Any suggestion?

Thanks.
Re:Improper result of search byte value in column of character type
Transer
2009-11-30 11:35:07.0
Note: character column contains symbols with codes in range 0..255, not only alpha-numeric.
Re:Re:Improper result of search byte value in column of character type
HXTT Support
2009-11-30 16:59:49.0
>Index file was deleted from FoxPro (delete tag all) to isolate problem.
>stmtFind = connection.prepareStatement("select * from table where field=?");
It will use automatic temporary index.

>Note: character column contains symbols with codes in range 0..255, not only
>alpha-numeric.
Failed to recur your issue. Please email your test dbf sample.
Improper result of search byte value in column of character type
Transer
2010-01-05 12:48:27.0
Hi!
Test data for support request with subject "Improper result of search byte value in column of character type" was sent to e-mail support@hxtt.com.
Thanks.
Re:Improper result of search byte value in column of character type
Transer
2010-01-05 13:11:36.0
Sorry, can't comment on initial message.
Re:Re:Improper result of search byte value in column of character type
HXTT Support
2010-01-05 17:58:24.0
It should be resulted by that CDX file is using different collation sequence. What's the program's name and version, which build that CDX file, since HXTT DBF failed to find a collation sequence name, and use default collation sequence to seek?

Re:Re:Re:Improper result of search byte value in column of character type
Transer
2010-01-09 09:49:11.0
Table and compound index were created with FoxPro 2.6a (X) for DOS with CODEPAGE=866 in CONFIG.FP and default collation sequence MACHINE. Machine collation is default for earlier FoxPro versions and was used in legacy system.
Re:Re:Re:Re:Improper result of search byte value in column of character type
Transer
2010-01-09 12:59:39.0
Problem also reproduced if table without CDX is used (no compound or other index files, only .DBF). Finding with CDX gets 636 problem values and 391 if no index file (for sent to support test table). To remove index file FoxPro command DELETE TAG ALL was used and checked that folder didn't contains *.CDX.
Re:Re:Re:Re:Re:Improper result of search byte value in column of character type
HXTT Support
2010-01-12 23:31:57.0
>Problem also reproduced if table without CDX is used (no compound or other index
>files, only .DBF).
Because it's using temporary index. Please download the latest package, which has resolved that issue.
Re:Re:Re:Re:Re:Re:Improper result of search byte value in column of character type
Transer
2010-01-13 03:56:36.0
Driver HXTT DBF 4.2.117 works well (with and without .CDX). Thanks a lot!

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