displaying top 100 results
Bug 86955:There is no way to "get" the default datasource set in the application
Tracker Issue How to set up a datasource in 'Application.cfc'
How to set up a datasource in 'Application.cfc'
Bug 79268:I have a application which runs multiple datasources
Portal Topic Guide to configure JNDI datasource in ColdFusion
Guide to configure JNDI datasource in ColdFusion appeared first on ColdFusion. Adobe ColdFusion 10,Adobe ColdFusion 11,Adobe ColdFusion 2016,Adobe ColdFusion 2018,Application Datasource,Data Source,JNDI,Question,Uncategorized,coldfusion 10,coldfusion 11,coldfusion 2016,coldfusion 2018,data source
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Portal Topic No more data availabel to read.
cal_btwynn No more data availabel to read. Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read.
The post No more data availabel to read. appeared first on ColdFusion. Application Datasource,Blog,Data Source,Question,application datasource
Comment on How to set up a datasource in 'Application.cfc' by Saurav G.
Tracker Issue Adding a new datasource parameter in CFTRANSACTION tag
2610248 CF-3715031 Database Sathish Kumar Adding a new datasource parameter in CFTRANSACTION tag Hi,
Although there is the new provision to set an application wide datasource using the Application's settings in the Application.cfc since version 10.0, I wonder if it would be good enough to have
Tracker Comment Comment on Bug 79268:I have a application which runs multiple datasources by External U.
Comment on Bug 79268:I have a application which runs multiple datasources by External U.
Comment on How to set up a datasource in 'Application.cfc' by Nitin K.
Comment on How to set up a datasource in 'Application.cfc' by Nitin K.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on REST services cannot make use of Application-specific mappings by External U.
2613693 CF-3184303 External U. It's worth noting that they seem to be able to use an application-specific datasource (this.datasource). If they have access to the dsn, why not the mappings?
Tracker Issue CFUPDATE requires DATASOURCE parameter
2948249 CF-4198427 Language : Tags Kevin Krzyzanski CFUPDATE requires DATASOURCE parameter Problem Description:
Although CFQUERY and CFINSERT no longer require DATASOURCE to be defined, if it was defined in application.cfc, CFUPDATE still does.
Steps to Reproduce:
Define a datasource
2609656 CF-3814079 Language Adam Cameron datasource attribute on should no longer be required It should use the application-wide DSN if it's set.
Same should apply to all DB-using functionality.
This issue probably predates CF11, but that's the version I'm working with.
--
Adam
Datasource to Application.cfc / Instance config to Application.cfc
Comment on How to set up a datasource in 'Application.cfc' by Evagoras C.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Issue Add onMissingDatasource support to application.cfc
Add onMissingDatasource support to application.cfc
other threads have to wait. This implenation slowdown the complete application if the establishing new connection is slow. Using JNDI, we can switch to datasource implementation with are non blocking.
Thanks,
Tracker Comment Comment on Application.cfc-set mappings don't work in onApplicationEnd() by External U.
2612969 CF-3358817 External U. Have also had issues with the application property this.datasource not being available when calling aplicationStop() with CF11.
Comment on Add ability to define datasources within Application.cfc by Rupesh K.
Tracker Issue Administrator API setMySQL5() throws error if user is logged into a ColdFusion application
2671796 CF-4198041 Administrator Mikel Goicoechea Administrator API setMySQL5() throws error if user is logged into a ColdFusion application Problem Description: cfide.adminapi.datasource.setMySQL5() only works if the user is not logged into a ColdFusion application
Steps to Reproduce:
run
Bug 73801:(Watson Migration Closure)In the server administrator AIR application if you highlight multiple datasources (which it let's you do by holding ctrl down) and right click and choose 'Apply to Selected Servers' only the row that
Comment on Add onMissingDatasource support to application.cfc by Nimit S.
Comment on Adding a new datasource parameter in CFTRANSACTION tag by Rupesh K.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
coldfusion application server crashes on clear query cache
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Administrator API setMySQL5() throws error if user is logged into a ColdFusion application by Amy O.
Comment on Administrator API setMySQL5() throws error if user is logged into a ColdFusion application by Amy O.
other than the default application datasource. If this feature is employed while second-level caching is enabled, the application will not start as it attempts to create a new cache with the same name as the cache specified in the EHCache configuration.
This does not occur in CF10 but does occur in CF
Tracker Issue Improve Application.cfc datasources
Improve Application.cfc datasources
Comment on Add ability to define datasources within Application.cfc by External U.
Comment on Add ability to define datasources within Application.cfc by External U.
Tracker Comment Comment on ColdFusion is inconsistent in the way it handles data of BIT type within a query by A. B.
5160232 CF-4203676 A. B. I assume you have defined your SQL Server datasource in Application.cfc
Tracker Comment Comment on Administrator API setMySQL5() throws error if user is logged into a ColdFusion application by External U.
2671796 CF-4198041 External U. This bug existed in a slightly different form in CF10. In CF10, the datasource would be created, but the user would be logged out of the ColdFusion application. The CF2016 version of the bug seems worse, because it's not very intuitive that you have to log out
the default application datasource
*/
public string function getDefaultDatasource() {
// get application metadata
if( listFirst(server.coldfusion.productVersion,",") gte 10 ) {
var settings = getApplicationMetadata();
} else {
var settings = application.getApplication
Comment on Guide to configure JNDI datasource in ColdFusion by Priyank Shrivastava
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by External U.
Stop() and THIS.datasources should follow suit IMO (Brad's idea should be used for THIS.datasources). Otherwise, Carl's idea of a boolean flag should be used. And applicationStop() shouldn't simply be ignored.
* - https://wikidocs.adobe.com/wiki/display/coldfusionen/Defining+the+application+and+its+event+handlers+in+Application
Tracker Comment Comment on Improve Application.cfc datasources by Himavanth R.
Comment on Improve Application.cfc datasources by Himavanth R.
Tracker Issue Add ability to define datasources within Application.cfc
Add ability to define datasources within Application.cfc
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by Nimit S.
2609167 CF-3916906 Nimit S. I have tried the steps mentioned above and I need not to restart CF server after changing the datasource/datasources name, calling applicationStop() function is working fine for me.
Can you please share the build number using which you are facing this issue?
I have
Comment on Add onMissingDatasource support to application.cfc by Nimit S.
Tracker Comment Comment on Application.cfc-set mappings don't work in onApplicationEnd() by External U.
2612969 CF-3358817 External U. Have also had issues with this.datasource being missing during the end of the application lifecycle. Good time to get this into CF12 before it ships aye.
Tracker Comment Comment on coldfusion application server crashes on clear query cache by External U.
Comment on coldfusion application server crashes on clear query cache by External U.
Comment on Guide to configure JNDI datasource in ColdFusion by mohit1984
Tracker Issue Bug 80235:If you use a cfstoredproc tag with no datasource="" attribute the script blows up
2599399 CF-3040245 Language : Tags Jared Rypka-Hauer Bug 80235:If you use a cfstoredproc tag with no datasource="" attribute the script blows up Problem:
If you use a cfstoredproc tag with no datasource="" attribute the script blows up.
Method:
Create an application.cfc with this.datasource
Tracker Issue Bug 80519:the cfapplication tag is throwing an error in cf9 when I try to put in the datasource attribute
2599298 CF-3040362 Language : Tags Matthew Graff Bug 80519:the cfapplication tag is throwing an error in cf9 when I try to put in the datasource attribute Problem:
the cfapplication tag is throwing an error in cf9 when I try to put in the datasource attribute
Method:
in the application.cfm set
Datasource to Application.cfc / Instance config to Application.cfc
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by External U.
2609167 CF-3916906 External U. So are you telling me, given this code in Application.cfc:
this.mappings = {"/foo", "c:\foo};
this.datasources = {/*stuff here*/};
Then:
this.mappings gets loaded every request
this.datasources does not?
Tracker Issue Bug 77370:cfquery will use "this
2600797 CF-3038644 Database : CFDBINFO John Whish Bug 77370:cfquery will use "this Problem:
cfquery will use "this.datasource" set in the Application.cfc, so shouldn’t cfdbinfo also be able to use it?
Example:
SELECT * FROM EMPLOYEES
Works.
Fails.
Method:
In Application.cfc add:
this.datasource
Tracker Issue Bug 75920:[JFERNANDES][Server Manager] The application should be more intuitive the way it works
Bug 75920:[JFERNANDES][Server Manager] The application should be more intuitive the way it works
2609167 CF-3916906 Database Aaron Neff [ANeff] Bug for: THIS.datasources changes ignored until CF restart Changes to THIS.datasources are ignored until CF restart
Repro:
Application.cfc
---------------
component {
THIS.name = "myApp";
THIS.datasources.myDSN = {driver="MSSQLServer", database
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Comment on Datasource to Application.cfc / Instance config to Application.cfc by External U.
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by External U.
is not writable from outside the pseudoconstructor?
Maybe a better solution is to add an optional boolean flag to the this.datasources setting to force it to be processed on each request. The flag would default to FALSE, but when set to TRUE it would force the application to reinitialize the datasources on each
Tracker Issue Bug 73864:(Watson Migration Closure)It'd be nice if we could include parts of the admin in the application setup wizard
Bug 73864:(Watson Migration Closure)It'd be nice if we could include parts of the admin in the application setup wizard
2599751 CF-3039759 Core Runtime : Application David McGuigan Bug 79564:(Watson Migration Closure)Add support for per-app, code-only volatile datasources that remain private to the app that defines them Problem:
Add support for per-app, code-only volatile datasources that remain private to the app
Tracker Comment Comment on Improve Application.cfc datasources by Rupesh K.
Comment on Improve Application.cfc datasources by Rupesh K.
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by Nimit S.
Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by Nimit S.
Tracker Comment Comment on Using clientInfo attribute with cfquery does not pass this metadata to MS SQL server by Nimit S.
and it is cached at the database driver level.
If you want to store application name into master..sysprocesses table, then set the ApplicationName at the datasource level.
I hope this answer your query, If you have any further doubt please reach out to us.
Tracker Comment Comment on Improve Application.cfc datasources by Rupesh K.
Comment on Improve Application.cfc datasources by Rupesh K.
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by Nimit S.
2609167 CF-3916906 Nimit S. That was my bad. I meant "datasources" struct gets loaded only once during the application initialization because it is an expensive task to re-create or check for any change in the data sources with every request.
Comment on Add onMissingDatasource support to application.cfc by Nimit S.
Comment on Add onMissingDatasource support to application.cfc by External U.
that within its body calls any cffunction that itself runs a cfquery, the containing cfquery will use the function’s query’s datasource and ignore the one passed to it as an attribute.This can cause various problems, specifically in applications and systems that leverage more than one datasource, one of Cold
://blog.getrailo.com/post.cfm/railo-4-1-explicit-datasources-in-application-cfc
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3656754
External Customer Info:
External Company:
External Customer Name: bradwood.com
External Customer Email:
Tracker Issue Local Application setting randomly lost
2608652 CF-4033856 General Server benoit plessis Local Application setting randomly lost Problem Description:
With a Application.cfc defining a default datasource and/or local CustomTag path CF11 randomly trigger 'CustomTag Not found" or "invalid cfquery attribute value "" for datasource"
Steps
by providing two more granular forms of defaults for datasourcing before 9 launches and legacy Luddites can argue backwards compatibility issues.
to override the application default on a per-request basis and
( and similarly attributes.datasource where appropriate ( cfthread, etc. ) ) to override both
Tracker Comment Comment on Improve Application.cfc datasources by Rupesh K.
Comment on Improve Application.cfc datasources by Rupesh K.
2673042 CF-4155300 External U. This would be useful for applications that are not built on frameworks such as FW/1, ColdBox, and others (which provide tooling to configure things like datasource names based on environment).
.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Application.cfc:
----------------------
component {
THIS.name = "ticket_CF-3634391";
THIS.datasource = "MyDSN";
THIS.ormEnabled="true";
boolean function onRequestStart() {
writeDump(getApplicationMetadata().datasource);
return true
Tracker Comment Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by External U.
Comment on [ANeff] Bug for: THIS.datasources changes ignored until CF restart by External U.
Tracker Comment Comment on logging and try / catch has a flaw by External U.
getDefaultDatasource(){
var settings = application.getApplicationSettings();
// check orm settings first
if( structKeyExists( settings,"ormsettings") AND structKeyExists(settings.ormsettings,"datasource")){
return settings.ormsettings.datasource;
}
// else default to app datasource
Tracker Comment Comment on Improve Application.cfc datasources by External U.
Comment on Improve Application.cfc datasources by External U.
Tracker Comment Comment on Improve Application.cfc datasources by External U.
Comment on Improve Application.cfc datasources by External U.
Tracker Issue Looping over a query resultset in CFscript using for-in loop produces different result than traditional loop
" to NO/YES when you perform a for-in loop over the query
Steps to Reproduce:
// Simply modify this simple script to use any table in your DB. Replace table name and field names to suit.
service = new Query(datasource=Application.Datasource);
result = service.execute(name="getPages",sql="select top 10
Tracker Issue ByteArray Objects conversion to Strings Error
Field#
---------------------------------------------------------
Result:
Giving "ByteArray Objects conversion to Strings" error.
Expected:
As cfquery code without CAST was was working working in CF 7 so it should also work in CF 10.
Workaround:
Client needs workaround for this issue at application/datasource level, not for coding level workaround as CASTING
Tracker Comment Comment on [ANeff] Bug for: OnSessionEnd() never runs after ApplicationStop() by External U.
/reset the application. More specifically, we are wanting to reset things such as THIS.javaSettings (and, previously, THIS.datasources) (and any settings CF adds later that would require an application reset to re-evaluate) and have OnApplicationEnd() and OnApplicationStart() run again. That's all. We don't want
Tracker Comment Comment on Improve Application.cfc datasources by External U.
Comment on Improve Application.cfc datasources by External U.
Tracker Issue Issue while creating application-specific data source using lowercase alphabet only in format.
2609408 CF-3849591 Database : General ext-user Issue while creating application-specific data source using lowercase alphabet only in format. Problem: Issue while creating application-specific data source using lowercase alphabet only in format.
Method:
see notes
this.datasources = { "mysql5_DD
:
Application.cfc:this.ormsettings.ormenabled=true;this.ormsettings.datasource=;this.ormsettings.eventhandling=true;MyCFC.cfcindex.cfm:
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3039960
External Customer Info:
External Company:
External
Tracker Issue Bug 82825:ORM Annotations don't work in one-to-many
2598362 CF-3041419 ORM Support Pedro Claudio Bug 82825:ORM Annotations don't work in one-to-many Problem:
ORM Annotations don't work in one-to-many
Method:
download files http://blog.pcsilva.com/enclosures/prerelase_orm_04212010.zip Create datasource coldfusion and edit Application.cfc ( this.datasource
Tracker Issue Bug 80422:check out the following code samples
Path("./appconfig.json.cfm");//this["name"] = "AppCfcTest";// this.datasource ="MavResource";// this.applicationTimeout="";// this.clientManagement="";// this.clientStorage="";// this.customTagPaths={};// this.loginStorage="";// this.mappings={};// this.sessionManagement="";// this.sessionTimeout="";// this.setClientCookies="";// this
Tracker Comment Comment on Local Application setting randomly lost by Piyush K.
Comment on Local Application setting randomly lost by Piyush K.
Tracker Comment Comment on CF Application Oracle clientstorage crash by Nimit S.
Comment on CF Application Oracle clientstorage crash by Nimit S.
Tracker Issue Wishlist
else - particularly JavaScript (where it is most used)
Support for null literals (see Lucee)
Ability to generate Application.cfc from instance settings for portability (see Lucee)
Ability to generate datasource settings on a per-datasource basis for use in Application.cfc for portability (see Lucee
path seem to be the missing trigger of the problem, it look like it reset the application setting "in flight" of the currently running pages, so that two requests on the same page will react differently (first one can work while the second one fail for missing the default datasource setting).
I
2599168 CF-3040508 ORM Support Andrew Scott Bug 80978:When trying to write a log out inside an event it doesn't write Problem:
When trying to write a log out inside an event it doesn't write.
Method:
Application.cfcthis.ormsettings = {datasource=this.databaseName, dbcreate
Tracker Comment Comment on CFUPDATE requires DATASOURCE parameter by Ashudeep S.
Comment on CFUPDATE requires DATASOURCE parameter by Ashudeep S.
2611175 CF-3634391 External U. I can easily reproduce this error on CF10 Update 13. -I created a folder with two files:
Application.cfc
component {
this.name="test";
this.ormEnabled="true";
this.datasource="test123";
}
index.cfm
I pointed 10 JMeter threads at it and within a minute had
when trying to do something similar using the queryExecute method in cfscript:
queryExecute(
"SQL STATEMENT",
{ myValue: { value: myValue, cfsqltype: "cf_sql_varchar", null: len(myValue) == 0 } },
{ datasource: myDatasource }
);
Throws something along these lines:
{"STACKTRACE
Tracker Issue MSSQL 2012 Support
Intent=ReadOnly" or "ApplicationIntent=ReadWrite" to the datasource connection string and have it route to a SQL ReadOnly or ReadWrite database, but it does not. This is specifically related to the MSSQL driver provided by Adobe (Datadirect), the JDBC driver supplied by Microsoft has this functionality. This functionality
Tracker Issue Bug 79924:this
2599536 CF-3039989 Database : General Douglas Knudsen Bug 79924:this Problem:
this.datasource was added to Application.cfc, very nice. Many shared hosts or Enterprise setups require username and password to be added to EVERY CFQUERY call. Applicaiton.cfc does not currently provide for this