Connecting to the Datasource in ColdFusion 8 vs CF 6

Question

Hi all,

I have a CF6 application that is running well. However, I'm in the process of upgrading to CF8, and some of the code no longer works. I've scoured the documentation and haven't found information on the replacement code.

My old code gets a datasource, acquires a database connection, uses the connection, and then closes the datasource.

variables.dsService = CreateObject("java", "coldfusion.server.ServiceFactory").DataSourceService;
variables.dsManager = dsService.getDman();
variables.dataSource = variables.dsManager.getDataSource(<data source name goes here>);
variables.dbConnection = variables.dataSource.getConnection();
<code to use the db connection goes here>
variables.dbConnection.close();

Under CF8, the error message is "The getDman method was not found." So I've been unable to find any code that will let me get access to an object that implements DataSource, so that I can use my connections.

Any advice would be appreciated.

Mike K.


 variables.dbConnection.close();

Under CF8, the error message is "The getDman method was not
found." So I've been unable to find any code that will let me get
access to an object that implements DataSource, so that I can use
my connections.

Any advice would be appreciated.

Mike K.

MKK2 · Accepted Answer

I ultimately discovered that what I needed was pretty simple

variables.dsService = CreateObject("java", "coldfusion.server.ServiceFactory").DataSourceService;
variables.dataSource = variables.dsService.getDataSource(<data source name>);
variables.dbConnection = variables.dataSource.getConnection();
<use the datasource>
variables.dbConnection.close();

Newsgroup_User · Answer

not sure if these help:http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basiconfig_37.htmlhttp://localhost/CFIDE/adminapi/datasource.cfc-- Ken FordAdobe Community Expert - Dreamweaver/ColdFusionFordwebs, LLChttp://www.fordwebs.com"MKK2" wrote in messagenews:g6d5sa$s0q$1@forums.macromedia.com...> Hi all,> > I have a CF6 application that is running well. However,I'm in the process of > upgrading to CF8, and some of the code no longer works.I've scoured the > documentation and haven't found information on thereplacement code.> > My old code gets a datasource, acquires a databaseconnection, uses the > connection, and then closes the datasource.> > > variables.dsService = CreateObject("java", > "coldfusion.server.ServiceFactory").DataSourceService;> variables.dsManager = dsService.getDman();> variables.dataSource =variables.dsManager.getDataSource( name goes here>);> variables.dbConnection =variables.dataSource.getConnection();>

> variables.dbConnection.close();> > Under CF8, the error message is "The getDman method wasnot found." So I've > been unable to find any code that will let me get accessto an object that > implements DataSource, so that I can use my connections.> > Any advice would be appreciated.> > Mike K.>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded