i am using cf2021, and i am trying to load datasou...
# cfml-general
g
i am using cf2021, and i am trying to load datasources using following method
Copy code
<cfset objDS = createobject("java","coldfusion.server.ServiceFactory").getDatasourceService().getDatasources() />
<cfdump var="#objDS#" abort>
<cfoutput>
<table border="1" cellpadding="3" cellspacing="0" width="50%">
<tr>
<th><b>DataSource</b></th>
<th><b>Username</b></th>
<th><b>Password</b></th>
</tr>
<cfloop collection="#objDS#" item="Key">
<cfif len(objDS[Key]["password"])>
<cfset password = Decrypt(objDS[Key]["password"],generate3DesKey("0yJ!@1$r8p0L@r1$6yJ!@1rj"), "DESede","Base64") />
<tr>
<td>#objDS[key].name#</td>
<td>#objDS[key].username#</td>
<td>#password#</td>
</tr>
</cfif>
</cfloop>
</table>
</cfoutput>