ColdFusion pools database connections to improve performance. Data source connections may be dropped as needed using the ColdFusion Administrator (this process also unlocks any locked files, for example, Microsoft Access MDB files), but you can also do this programmatically using the undocumented CFusion_DBConnections_Flush() function. This function, which takes no parameters, will drop all open connections (forcing them all to be reopened when needed). (Applies to: ColdFusion 4.x or 5)
Leave a Reply