tracker issue : CF-4198287

select a category, or use search below
(searches all categories and all time range)
Title:

How to set up a datasource in 'Application.cfc'

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Evagoras Charalambous / Evagoras Charalambous ()

Created: 01/26/2017

Components: Documentation

Versions: 2016

Failure Type: Others

Found In Build/Fixed In Build: / Documentation improved

Priority/Frequency: Normal /

Locale/System: /

Vote Count: 0

Since ACF11+ it has been possible to create datasources directly in the 'Application.cfc' bootstrap, however I don't see any docs anywhere on how to do that - or samples for that matter. It would be great if you could add those somewhere.

Attachments:

Comments:

Examples I have tried that did not seem to work: this.datasources[ "orders" ] = { "driver"="MSSQLServer", url="jdbc:macromedia:sqlserver://localhost\MSSQL2008;databaseName=orders;sendStringParametersAsUnicode= true;querytimeout=0;MaxPooledStatements=100", "username"="sa", "password"="password" }; nor did this: this.datasources = { "orders" = { database = "orders", host = "localhost", port = "1433", driver = "MSSQLServer", username = "sa", password = "password", blob = true, clob = true } };
Comment by Evagoras C.
1289 | January 26, 2017 04:13:11 PM GMT
Added the required description in: https://helpx.adobe.com/coldfusion/cfml-reference/application-cfc-reference/application-variables.html Please check.
Comment by Saurav G.
1290 | February 07, 2017 09:55:33 AM GMT
Corresponding changes have been done in the documentation .Please let me know if this clarifies your doubt /inquiry .
Comment by Nitin K.
1291 | February 07, 2017 10:32:50 AM GMT
Hope the improved documentation clears your doubt . Thanks for pointing it out . Closing this bug now. Regards, Nitin
Comment by Nitin K.
1292 | March 14, 2017 06:55:54 AM GMT