Skip to main content
Participant
November 14, 2019
Question

CF11-setup error page for database not available

  • November 14, 2019
  • 1 reply
  • 345 views

we are using ColdFusion 11 enterprise , every evening our database backup team taking database offline for baclup, unfortunatly some user are trying to access same database, we wanted to setup error page on that datasource availability, need help 

This topic has been closed for replies.

1 reply

BKBK
Community Expert
Community Expert
November 16, 2019

A possible solution:

1) Make sure your Application.cfc file implements the onError eventhandler.

2) Include code in the onError handler to check whether datasources are available. For example, to check whether a datasource, myDSN, is available, you could do something like 

<cffunction name="onError">
<cfargument name="Exception" required=true >
<cfargument name = "EventName" type="String" required=true >

	<!--- Login into Coldfusion Administrator. --->
	<cfset  createObject("component","cfide.adminapi.administrator").login("my_CFAdmin_password")>
	
	<!--- Instantiate the data source object. --->
	<cfset  var datasourceObject = createObject("component","cfide.adminapi.datasource")>
	 
	<!--- Get a structure containing all the data sources --->
	<cfset var datasources = datasourceObject.getDatasources()>
	 
	<cfif structCount(datasources) eq 0 or not structKeyExists(datasources, 'myDSN')>
		Sorry, the data source in unavailable.
	</cfif>

</cffunction>