Check for live Data Source Name Before proceeding

Posted by n_kips on Stack Overflow See other posts from Stack Overflow or by n_kips
Published on 2011-01-15T19:47:19Z Indexed on 2011/01/15 19:53 UTC
Read the original article Hit count: 240

Filed under:

coldfusion

|

error-handling

|

coldfusion-8

|

coldfusion-9

Would it be ok to get a CF app to check for a valid database before proceeding to process that request?

This is because there may be instances where the database server may be down or being upgraded, hence an error comes when a db dependant request is made.

If there is no connection to the db server, the user can be safely redirected to a safe page.

Or can cfcatch work?

How can this check be done?

Thank you.

© Stack Overflow or respective owner

Related posts about coldfusion

Coldfusion autorestart

as seen on Server Fault - Search for 'Server Fault'
Coldfusion is automatically restarting, a lot. It comes in waves, everything seems fine for a while then the server struggles for a few minutes, restarts a lot then settles down again. I have Fusion Reactor installed, but when CF goes down FR stops logging so it's not really helping. Looking through… >>> More
How do I change ColdFusion Help to show ColdFusion 8 Documentation, instead of ColdFusion 9 Document

as seen on Stack Overflow - Search for 'Stack Overflow'
I love ColdFusion Builder. But I don't like that the help only has CF9 Documentation. Is there any way to change this to have ColdFusion 8 Documenation? >>> More
Moving from ColdFusion 8 to ColdFusion 10 - Migration Fails

as seen on Server Fault - Search for 'Server Fault'
After having made several attempts to migrate from a ColdFusion 8 Standard server to a ColdFusion 10 Standard server, it feels like I am "almost" there. I'm using the 64 bit installer from Adobe's website. I'm using a Windows Server 2008 (64 bit) server with IIS 7.0. The installation itself goes… >>> More
Unauthorized Sharepoint WSDL from Coldfusion 8

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I solve the error: Unable to read WSDL from URL: https://workflowtest.site.edu/_vti_bin/Lists.asmx?WSDL. Error: 401 Unauthorized. I can successfully view the WSDL from the browser using the same user account. I'm not sure which authentication is being used (Basic or Integrated). How… >>> More
ColdFusion Server crash after thousands of HTTP requests

as seen on Server Fault - Search for 'Server Fault'
We are running ColdFusion 8 on a windows server 2003 VPS with an API that exposes student records to a partner API through a connector. Our API returns around 50k student records serialized in XML format pretty seamlessly. My question originates when something very frightening happened today when… >>> More

Related posts about error-handling

Good SQL error handling in Strored Procedure

as seen on Developer IT - Search for 'Developer IT'
When writing SQL procedures, it is really important to handle errors cautiously. Having that in mind will probably save your efforts, time and money. I have been working with MS-SQL 2000 and MS-SQL 2005 (I have not got the opportunity to work with MS-SQL 2008 yet) for many years now and I want to… >>> More
Error Handling Examples(C#)

as seen on DotNetBlocks - Search for 'DotNetBlocks'
“The purpose of reviewing the Error Handling code is to assure that the application fails safely under all possible error conditions, expected and unexpected. No sensitive information is presented to the user when an error occurs.” (OWASP, 2011) No Error Handling The absence of error… >>> More
Building an Error-Handling Mechanism

as seen on Internet.com - Search for 'Internet.com'
Are errors chasing away your visitors? Let Marc Plotz show you how to handle them effectively. ... >>> More
Building an Error-Handling Mechanism

as seen on Internet.com - Search for 'Internet.com'
Are errors chasing away your visitors? Let Marc Plotz show you how to handle them effectively. ... >>> More
Improving ANTLR DSL parse-error messages

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on a domain-specific language (DSL) for non-programmers. Non-programmers make a lot of grammar mistakes: they misspell keywords, they don't close parentheses, they don't terminate blocks, etc. I'm using ANTLR to generate my parser; it provides a nifty mechanism for handling RecognitionExceptions… >>> More