I'd have to think that Disable Database Connections would also be
immediate (but I'm honestly not sure). And while it may be more
intrusive then momentarily unlocking the database with a bad query, if
Rick's site is popular, disabling database connections to the db may be
the only way to go because other users may relock the database before he
can initiate / complete his upload. Similarly, if users try to query
his database while he's uploading the database, they will receive an
error. I'd also think that it would be very possible some sort of
corruption or instability to seep into the file he's uploading if
ColdFusion tried to repeatedly open a connection to the database before
the upload has been completed.
- Jay
-----Original Message-----
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 11:05 PM
To: CF-Talk
Subject: Re: Locked Database
> Usually sending a bad query to the data source will break the lock.
> You can also set "disable database connections" in the CF
> Administrator. If you disable db connections, make sure you enable
> them again, otherwise your site won't work :-)
The bogus query is a better option .. it is less intrusive and more
immediate than the "disable database connections" one. The other method
I was refering to in my last post is the CFusion_DBConnections_Flush()
function. That tends to break all DB connections without having to
change anything on the CF server. To use it, set some temp variable to the function
.. .eg: <cfset Variables.uselessTempVariable CFusion_DBConnections_Flush()>
Todd
> Jay Sudowski
> ---------------------
> Handy Networks LLC
> TEL: 877-70-HANDY
> FAX: 888-300-2FAX
> URL: www.handynetworks.com <http://www.handynetworks.com>
> ---------------------
> Providing reseller and dedicated Windows 2000 web hosting solutions.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
