Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Paradox
Hxtt Paradox jdbc drivers for Corel paradox - Missing records in ResultSet
Stupar
2007-03-16 05:58:03.0
Hi,
Before buying a hxtt paradox server license I'm evaluating the trial version (v3.1) and have noticed the two following problems that are annoying for me.
I'm working with an old paradox 4 database created with Borland BDE 16 bits.

First : the maximum number of rows in a ResultSet is 1000 : is it a limitation of the trial version ?
(Remark : i have noticed that .setMaxRows(int) has no effects even with lesser values)

Second : I've noticed that a randomly number of records are missing in a ResultSet after executing a (simple) query on some tables (select * from table) and without any error message. After investigating it appears that it is due to a secondary index defined in those tables : if I delete the secondary index, the execution is OK. I take your attention on the fact that I DON'T needed to delete ALL secondary indexes from the table, only one. I think it could be a bug.

If I can deal with the second problem, I cannot with the first, so, before buying I need to know if it's due to a limitation in the trial version.
Thanks for responding to my questions
Best regards

Re:Hxtt Paradox jdbc drivers for Corel paradox - Missing records in ResultSet
HXTT Support
2007-03-16 06:41:00.0
>First : the maximum number of rows in a ResultSet is 1000 : is it a limitation
> of the trial version ?
Yeah. It's descripted at Introduction of HXTT Paradox Packages

>Second : I've noticed that a randomly number of records are missing in a
> ResultSet after executing a (simple) query on some tables (select * from
> table) and without any error message. After investigating it appears that it
> is due to a secondary index defined in those tables : if I delete the
> secondary index, the execution is OK. I take your attention on the fact that
> I DON'T needed to delete ALL secondary indexes from the table, only one.
> I think it could be a bug.
It's no bug. One of your index contains old row information. You can run once REINDEX {ALL | indexFileName[,...]} ON table_name sql, then your issue will disappear.

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