Get all DSN Settings at Once

CFDBINFO is the tag available to know about DSN with which Coldfusion interacts. This tag actulally gives you whole idea about any specific db or table or it can be a single column but It does not have much to show. Lets have a look at that tag.

[code:cf]
<cfdbinfo datasource="cfartgallery" table="art" type="columns" name="resultGallery">
<cfdump var="#resultGallery#">
[/code]

Guys, i have a piece of code which gives you all information about all databases just at once. I hope you would like it.

[code:cf]
<cfset servicefact = CreateObject("java", "coldfusion.server.ServiceFactory")>
<cfdump var="#servicefact.DataSourceService.getDatasources()#" expand="true">
[/code]