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
Index
Salvador Garriga
2009-01-19 09:45:58.0
Hi.

I bought the paradox JDBC driver and sometimes it not read all the records from database. I query it with DBD32 and I can show all the records but not all trough the driver. If I reindex the table the driver run correct but a few days later I can't read the new records with jdbc (but I can with dbd32). Are there a way for read the database without use indexs? I ought to rebuild the index each time I read It?
Thanks.

Salvador
Re:Index
HXTT Support
2009-01-20 06:32:08.0
What's your sql? It seems that your index file isn't keep up to date.

>If I reindex the table the driver run correct but a few days later
> I can't read the new records with jdbc (but I can with dbd32).
What applicatio will modify and maintain that table?
Re:Re:Index
Salvador Garriga
2009-01-21 03:07:14.0
I'm reading from a database which is updated by a delphi application. The problem is that it not detect this index up to date and work correctly. I use the paradox driver only for read the tables and when I include the clause "where" (and I suppose the driver uses the index) . I understand it isn't a driver problem because the index is up to date but I don't undersand because the Delphi application with the BDE run correctly and I can't rebuild the indexs every time and I don't know if the records I read are all . Don't worry. I changed my applications and now I don't use 'where' in my sql calls , I read all the records and filter it with code. I can't see another solution.
Thanks.
Re:Re:Re:Index
HXTT Support
2009-01-21 18:00:55.0
>The problem is that it not detect this index up to date and work correctly.
Try delayedClose=0 connection property. Then your issue should disappear.
Re:Re:Re:Re:Index
Salvador Garriga
2009-01-22 01:02:19.0
I've tried

"DriverManager.getConnection("jdbc:paradox:/c:/dades/emelec/ventas/dat/001?delayedClose=0","","")".

and neither works.

Sorry but I didn't tell correctly last mail

The problem is that it (Delphi application) not detect that index IS NOT up to date and work correctly. I use the jdbc paradox driver only for read the tables and when I include the clause "where" (and I suppose the driver uses the index) jdbc don't read some records. I understand it isn't a driver problem because the index is not up to date and when I reindex it the driver run properly.
Re:Re:Re:Re:Re:Index
HXTT Support
2009-01-22 17:26:18.0
Sorry, you should try lockTimeout=-1 connection property. If you failed still, please let us know, then we will try to skip specially that issue for you.

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