I was actually thinking about one step further, where you actually get
the connection from CF's pool, rather than just the connection info.
So you let CF take care of everything (as it does normally), except
that you have complete control over the connection rather than letting
CF manage it. And really, my greater hope would be for that
functionality on BD, because it'd alleviate some of the
transaction-related issues it has (not bugs, per se, just
implementation details that prevent certain solutions from working).
But if it worked cross platform (with a check for the server to tell
how to get the connection, of course), that'd be the best scenario.
cheers,
barneyb
On 10/25/05, Doug Arthur <[EMAIL PROTECTED]> wrote:
> Just to slightly modify what I've already done, is this what you're
> refereing to Barney?
>
> The only downside is that since the password is encrypted in the structure,
> the password would still have to be supplied.
>
> <cffunction name="dump">
> <cfdump var="#Arguments[1]#">
> </cffunction>
> <cfscript>
> namedDatasource = "db";
> password = "password";
>
>
> ServiceFactory = CreateObject("java",
> "coldfusion.server.ServiceFactory");
> datasources =
> ServiceFactory.getDataSourceService().getDatasources();
>
> if(StructKeyExists(datasources, namedDatasource))
> dataSourceStruct = StructFind(datasources, namedDatasource);
>
>
> try {
> Class =
> createObject("java","java.lang.Class").forName(dataSourceStruct.class);
> DriverManager = createObject("java", " java.sql.DriverManager");
> conn = DriverManager.getConnection(dataSourceStruct.url,
> dataSourceStruct.username, password);
> stmt = conn.createStatement();
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 100 invites.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
