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
Force Close
Andrew
2015-08-29 09:00:47.0
We are still testing this driver (latest) and having issues.

We only use it for READ ONLY selects on Foxbase 2.10 DOS apps. We use Lucee (Coldfusion/Railo CFML) on Tomcat 8 64bit on Windows Server 2012.

Often our old Foxbase app cannot access certain dbf's (usually when they need to modify a table) and the only resolution is to stop/start Tomcat... so that means it must be that Tomcat/the Hxtt driver are holding some kind of lock/connection to a particular dbf file? We are not using any lock on Hxtt as we are only reading the dbf's (i.e. SELECT)?

This is intermittent, but consistent. We have no ability to modify the Foxbase app legacy code.

As I understand it, read only code (SELECT's) do not use ANY Hxtt locking? So, what are the circumstances that the Hxtt driver will lockup-up a dbf on a read? We do NOT use lockType because we are only reading files.

Also, barring any way to avoid this "lock-up" is there a query or something that can be run to force close all of these Tomcat/Hxtt connections rather than the destructive restarting Tomcat?
Re:Force Close
Andrew
2015-08-29 19:12:57.0
So I can say with certainty that the Hxtt DBF driver "locks" up these DBF files during the course of the SELECT (read-only) query and for a few seconds afterward.

I have tried all kinds of combinations of connection string paremeters I've read about, but still get the dreaded message:

"No database in USE. Enter file name:"

each time I use our Foxpro app while Hxtt is running a simple SELECT on a table needed by the Fox app.

What can we try here?
Re:Re:Force Close
HXTT Support
2015-08-30 05:10:11.0
>Often our old Foxbase app cannot access certain dbf's (usually when they need to modify a table)
Your old Foxbase application should be using exclusive file open mode. So It happen if you has not closed those connection or tables in .

1st. Use delayedClose=0 connection property to avoid the delayed close then your issue will be solved if you close your DBF connection in time.

2nd. com.hxtt.sql.dbf.DBFDriver.releaseAll() can release all resource if you wish to force release all opening table files.
Re:Re:Re:Force Close
Andrew
2015-08-31 09:56:36.0
OK, we will try "delayedClose=0" today, though I am rather certain we had tried this and it did not work...

Re: "com.hxtt.sql.dbf.DBFDriver.releaseAll()" - how does one "call" this? We are using this driver for a datasource in a ColdFusion/Railo/Lucee application.
Re:Re:Re:Re:Force Close
Andrew
2015-09-01 17:23:39.0
Re: "com.hxtt.sql.dbf.DBFDriver.releaseAll()" - how does one "call" this? We are using this driver for a datasource in a ColdFusion/Railo/Lucee application

Any advice on this would be greatly appreciated?
Re:Re:Re:Re:Re:Force Close
HXTT Support
2015-09-02 05:04:47.0
>Re: "com.hxtt.sql.dbf.DBFDriver.releaseAll()" - how does one "call" this?
It's a code line feature:(

>>each time I use our Foxpro app while Hxtt is running a simple SELECT on a table needed by the Fox app.
>Any advice on this would be greatly appreciated?
delayedClose=0 can make sure that HXTT DBF released the file at once if you close that connection or resultSet object. If you met that issue still, it means that your Foxpro applicaiton is using exclusvie table lock, and HXTT DBF is using that file in shared mode too.

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