Programmatically disable DSN

[rchinoy]

Hi all,

I have a CF MX 6.1 app that accesses an AS/400 DB2 database, but I need to
make sure ColdFusion disconnects from DB2 at a particular time so a backup can
proceed. I found the following code that is supposed to do this:

<cflock name="serviceFactory" type="exclusive" timeout="10">
<cfscript>
factory = CreateObject("java", "coldfusion.server.ServiceFactory");
ds_service = factory.datasourceservice;
dsources = ds_service.datasources;
dsources["your_dsn"]["disable"] = "Yes/No";
ds_service.restart();
</cfscript>
</cflock>

However, when I test this against a MySQL DSN (after plugging in my DSN name
and using the "Yes" option) and monitor the MySQL connections, it does not
appear that it's breaking the CF-maintained connection.

Anyone have any ideas?

Thanks,
Russ

[Dan Bracuk]

Are you not able to do this at the database end? The way we deal with this is:
1. make the database unavailable when required using database methods.
2. In Cold Fusion, test the database for availability before attempting to
use it. Using Oracle as an example
<cftry>
<cfquery>
select sysdate from dual
</cfquery>
<cfset ok = true>
<cfcatch>
<cfset ok = false>
</cftry>
<cfif ok>
run your page
<cfelse>
explain why not
</cfif>