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
JDBC Driver (from ColdFusion)
Kevin Kreuter
2007-08-28 23:55:13.0
We are using the latest v3.1 (JDBC2.0 or JDBC3.0) with ColdFusion8. How do you force a disconnect from the datasource. Is there a JDBC connection string parameter that will ensure that a connection is NOT maintained across queries. We need this because the DB files can be deleted and re-created on the fly by another application, but the cannot be deleted if our app still has a connection open. Thanks.
Re:JDBC Driver (from ColdFusion)
HXTT Support
2007-08-29 01:06:45.0
>Is there a JDBC connection string parameter that will ensure that a connection
>is NOT maintained across queries.
If you're using remote connection, you can use maxIdleTime connection property. But I guess that you're using embedded connection. You should call ResultSet.close or Statement.close, or Connection.close to release all unused resouce, otherwise, you need to wait the System.gc run.

>We need this because the DB files can be deleted and re-created on the fly by
>another application, but the cannot be deleted if our app still has a
>connection open.
First, "drop table..." sql can remove an unused db. Secondly, try delayedClose=-1 at here can help you to release an uused db on the fly.



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