I've done my searching online, throughout several groups, and now I turn to
you guys.
I've been having trouble figuring out how to detect, from within my
ColdFusion application, whether or not my database connection is valid.
The DB setup is valid, but my goal is to automatically detect when the
database server is temporarily down/unavailable in order to display an
automatic "maintenance" message in the case of a crash or true maintenance
when the database is offline.
I've tried to put a simple query into my Application file and use CFQUERY's
Timeout to force a quick (5 second) error within a CFTRY, but I'm inclined
to think that it only has an affect on SQL Server when it's up and running,
but taking too long to return a result. With my current attempt, it's taking
up to 18 seconds to fail, which is just too long. Even using CFSETTING to
set RequestTimeout to a lower value doesn't seem to have an affect.
This was my attempt:
<CFTRY>
<CFQUERY datasource="#DBDATASOURCE#" username="#DBUSERNAME#"
password="#DBPASSWORD#" name="testConnection" timeout="5">
SELECT TOP 1 THEME_ID FROM TBL_THEME
</CFQUERY>
<CFCATCH>
<!-- DB Connection failed -->
<cfinclude template="Maint.cfm">
<CFABORT>
</CFCATCH>
</CFTRY>
If it matters, we're using MSSQL now, though we're planning to switch to
MySQL eventually. I know there are timeout differences with CFQUERY's
Timeout in conjunction with different DB drivers and I'd like to come up
with a single, generic solution.
I appreciate any feedback.
Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275850
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
