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
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
 

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