> If you own the server, just look at neo-query.xml.
But that wouldn't be programmatically.
> If you have access to the AdminAPI and on CF7, then yes.
Yeah, that actually works as well as the service factory.
The annoying thing is that if you specify your database in the jdbc url
(like a SeeFusion wrapped data source) then the database name shows up
empty and you apparently have to parse it from the jdbc url yourself.
I even looked at the getmetadata() which had more stuff in it than I
ever know existed, but it didn't seem to have the database name.
function get_database_name_by_data_source(data_source_name)
{
dss = CreateObject("java","coldfusion.server.ServiceFactory");
jbdc_url =
dss.getDataSourceService().getDataSource(data_source_name).getDataSource
Def().geturl();
return jbdc_url;
}
function get_database_name_by_data_source2(data_source_name)
{
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("iamallpowerfuladmin");
myObj =
createObject("component","cfide.adminapi.datasource").getdatasources(dat
a_source_name);
return myObj.url;
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268887
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4