Listing 1
<!--- Verify a datasource is working --->
<CFFUNCTION NAME="VerifyDSN" RETURNTYPE="boolean">

<CFARGUMENT NAME="dsn"
TYPE="string"
REQUIRED="yes">

<!--- Init local variables --->
<CFSET VAR dsService="">
<CFSET VAR result="true">

<!--- Try/catch block --->
<CFTRY>
<!--- Get "factory" --->
<CFOBJECT ACTION="CREATE"
TYPE="JAVA"

CLASS="coldfusion.server.ServiceFactory"
NAME="factory">
<!--- Get datasource service --->
<CFSET dsService=factory.getDataSourceService()>
<!--- Validate DSN --->
<CFSET result=dsService.verifyDatasource(dsn)>

<!--- If any error, return FALSE --->
<CFCATCH TYPE="any">
<CFSET result="false">
</CFCATCH>
</CFTRY>

<CFRETURN result>

</CFFUNCTION>