Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
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 Paradox
Index
Salvador Garriga
2009-01-19 09:45:58
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
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
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
>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
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
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
 

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