Extracting datasource information with CFML ( with javas help )

Ran into this a few days back and I though it was quite interesting. From within CFML code you can extract information about the datasources. I guess a possible use for this is compatible code ie if(mySQL) do MySQL else do MSSQL.

It works with Coldfusion 7 and 8 and it also works on the latest stable release of Railo with slightly less detail then Coldfusion. It didn’t work on Open Bluedragon though.


<br />// This will dump all of the services in CFMX/CF8<br /><cfobject type="JAVA" action="Create" name="factory" class="coldfusion.server.ServiceFactory"><br /><cfdump var="#factory#"><br /><br />// This will dump the datasources and drivers manipulating <br />// datasources is as simple as modifying<br />// the structure datasources below<br /><cfobject type="JAVA" action="Create" name="factory" class="coldfusion.server.ServiceFactory"><br /><cfset sqlexecutive=" factory.getDataSourceService()"><br /><br /><cfset drivers="sqlexecutive.drivers"><br /><cfset datasources="sqlexecutive.datasources"><br /><br /><cfdump var="#sqlexecutive#" label="DataSource Factory"><br /><cfdump var="#datasources#" label="DataSources"><br /><cfdump var="#drivers#" label="Database Drivers"><br /><br />

Original source: Brandon Purcell.