I'm trying to create a Coldfusion datasource on the fly using the
RDSInvoker method in the CFIDE.adminapi.base component. Here's what
I've got for the creation code:
<cfscript>
dbname = "thenewdsn";
dsnArgs.name = dbname;
dsnArgs.url = application.jdbcURL & dbname;
dsnArgs.class = application.dbdriver;
dsnArgs.driver = "Postgres Driver";
dsnArgs.username = application.dbowner;
dsnArgs.password = application.dbownerpass;
</cfscript>
<cfset newDSN = createObject
("component","CFIDE.adminapi.base").RDSInvoker
("datasource","setOther",dsnArgs,"myRDSPassword")/>
The adminapi.base doesn't seem to accept my calling the datasource
method, however the inheritance of the CFIDE.adminapi.datasource
should allow it.
A dump of #newDSN# provides this response: "Only ADMINAPI
componenets may be invoked through RDS."
Here's the cfcexplorer text of the RDSInvoker method:
RDSInvoker
public RDSInvoker ( required service, required method, required args,
required adminPassword )
Used internally to invoke the Administrator API
Output: suppressed
Parameters:
service: any, required, service - Name of service.
method: any, required, method - Name of method to invoke.
args: any, required, args - Arguments for remote method.
adminPassword: any, required, adminPassword - RDS password for
authentication
I'm guessing it's a syntax issue in my service argument. Does
anyone have any thoughts on what I need to do differently? I've
tried "CFIDE.adminapi.datasource" but it will only accept a string
variable.
When you call CFIDE.adminapi.datasource directly, it throws a
permissions error.
Also, I'd be open to using another method apart from RDS, if anyone
has any suggestions.
Thanks,
Jon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258046
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
