Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  Buy Now
  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)

Not able to pick up new file update
2009-11-25 22:49:13.0
Dear HXTT tech support,

I posted a quick question earlier and I wasn't sure whether it went through or not. So I'm writing it again, here is a recap of our problem in more details:

We have a DBF file on our system, called show2003.dbf. This file gets overwritten by an external data driver every 5 secs. I've confirmed that the file is also updating (data content) every 5 secs. On the other hand, our in-house Java code uses the HXTT DBF driver to query out the data from this file every 5 secs. Problem is: when we startup our java app, it successfully fetchs the data from the DBF file; but 5 secs later the query still returns the same set of result as before (eventhough the DBF file has been CHANGED !). How does the HXXT DBF driver determines whether the file has been changed or not? why does it return the same query result eventhough the file content has indeed been changed? Any idea?

thx much,
Perry Lau
Re:Not able to pick up new file update
2009-11-27 01:12:48.0
After more testing, I believe the prob is due to the "access time":
File: `/bb/data/show2003.dbf'
Size: 501579 Blocks: 1008 IO Block: 8192 regular file
Device: 1540032h/22282290d Inode: 2631 Links: 1
Access: (0666/-rw-rw-rw-) Uid: ( 2960/ op) Gid: ( 100/ general)
Access: 2009-11-27 03:05:35.562259000 -0500
Modify: 2009-11-27 02:29:53.402577000 -0500
Change: 2009-11-27 02:29:53.405769000 -0500

Looks like when the external source updates the DBF, it updates all "Last access time", "Last Modify time" and "Last Change time". The DBF driver checks the last access time and since it's up-to-late, it doesn't query from the file again. Is there a way to force the DBF driver to re-read the DBF file again regardless of what current file attributes are ?!

Re:Re:Not able to pick up new file update
HXTT Support
2009-11-28 00:09:46.0
>This file gets overwritten by an external data driver every 5 secs.
>How does the HXXT DBF driver determines whether the file has been changed or not?
Don't worry. You can use lockType=VFP connetion property, if that extrernal data driver was written in VFP language. To specify a compatible lock for other applications. You can use DBASE, DBASE4BDE, DBASEIII, DBASEIV, CLIPPER, CLIPPER5.3, PowerPlus, SoftC, FOXBASE, FOXPRO, FOXPRO4UNIX, FOXPRO4BDE, and VFP.

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap