Data Sources

[PhilRV6]

Can anyone tell me how to get a list of Data Sources from CF server using cfml?

Thanks: Phil

[qateef]

<cfscript>
application.ServiceFactory =
CreateObject("java","coldfusion.server.serviceFact ory");
DSN =
listSort(structKeyList(application.ServiceFactory. DatasourceService.getDatasourc
es()),"textnocase","asc"):
</cfscript>

now you need to query the list and you can do that by doing the following:

<select name="myDSN">
<option value=""></option>
<cfloop list="#dsn#" index="i">
<option value="#i#>#i#</option>
</cfloop>
</select>

Good luck
Mamdoh Al-Habeeb

[PhilRV6]

Thanks for responding. I gave it a try and got this error message:

Error Occurred While Processing Request
Object Instantiation Exception.
Class not found: coldfusion.server.serviceFactory

I'm thinking that I need a Java class called serviceFactory? If so, where can
I find it? Or, what could I be doing wrong?

Thanks again for your help: Phil

[boughtonp]

Yes, it's Java - part of the CFMX core class thingies. (and an 'undocumented
feature', so it might not be in future versions; use at your own risk, etc)
Here's a useful blog entry about it: [url]http://www.petefreitag.com/item/152.cfm[/url]

If you're using CF5 then obviously it wont work. Not sure if there are any
alternative methods.

[qateef]

Dear PhilRV6,

I am sorry, I should mentioned that the code I provided you with ealier is for CFMX and what Mr. Peter said is true that this code will not work for CF5.

[PhilRV6]

I am running 7. Should it work here, or do I need a different class?

Thanks Much: Phil

[boughtonp]

Looks like the name is case-sensitive; you need a capital S on ServiceFactory.

[PhilRV6]

It's working great. Thank you both very much for your help.

Sincerely: Phil Spingola:D

[PhilRV6]

After using the solution that was provided, I realised that it did not return
the Driver type (Access, Oracle, SQL 2000). Does anyone know how to get this
call to do this. I have not been able to find doc on it.

Thanks for any help you can give!

Sincerely: Phil



<cfscript>
application.ServiceFactory =
CreateObject("java","coldfusion.server.serviceFact ory");
DSN =
listSort(structKeyList(application.ServiceFactory. DatasourceService.getDatasourc
es()),"textnocase","asc"):
</cfscript>

[ksmith]

Hi Phil,
Get adventurous and explore the code you have been given. Attached is code
that gives you a table of dsn names and drivers. Below it I dump the structure
returned by the getDatasources method.

<CFOBJECT TYPE="JAVA" ACTION="Create" NAME="factory"
CLASS="coldfusion.server.ServiceFactory">

<cfscript>
DSN =
listSort(structKeyList(factory.DatasourceService.g etDatasources()),"textnocase",
"asc");
</cfscript>
<table border="1" bordercolor="#000000">
<tr><th>DSNname</th><th>Driver</th></tr>


<cfloop index="key" list="#DSN#">

<cfoutput><tr><td>#key#</td><td>#dsnCollection[key].driver#</td></tr></cfoutput

>

</cfloop>
</table>

<br><br>
<cfdump var=#dsnCollection#>