Hi all, were having a small issue in attempting to create CFMX datasources
programatically. Has anyone managed to do this? Were running Win2k Adv
Server on MX with Updater 2 applied.
Using the following code where.....
* sample_ds is the database used to clone a new database
* #cf_ds_name# is the name of the new cf database
* #odbc_ds_name# is name of the ODBC DSN, which references an
Excel spreadsheet
Result...
* Datasource appears in Cold Fusion administrator
* The correct ODBC DSN is shown
* All variables are correct
But ....
* Datasource does not verify, you get this beauty..
Connection verification failed for data source: xl_ds_2119962272
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.
And...
* When you change the name of the datasource, and Submit, it is
verified correctly (presumably having forced some code to execute)
* Still works when you then change the datasource name back to the
original
* <dump>ing the datasource structure before and after gives an
identical result
So....
* Is there some additional code required to boot the datasource ?
Code...
<!--- Create Cold Fusion Datasource --->
<cflock name="serviceFactory" type="exclusive" timeout="10">
<cfscript>
// Get a handle on datasources structure
objFactory = CreateObject("java",
"coldfusion.server.ServiceFactory");
objService = objFactory.getDataSourceService();
dsources = objService.getDatasources();
// Get a copy of the generic ds, configure, add to
datasources
local_ds = Duplicate(dsources['sample_ds']);
local_ds.name = "#cf_ds_name#";
local_ds.url = Replace(ds_copy.url,"sample_ds",cf_ds_name);
local_ds.urlmap.datasource = "#odbc_ds_name#";
local_ds.urlmap.connectionprops.datasource =
"#cf_ds_name#";
local_ds.valid = "YES";
dsources["#cf_ds_name#"] = Duplicate(local_ds);
objService.restart();
</cfscript>
</cflock>
Any advice on how to procede further would be cool :)
Mikey
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
