tracker issue : CF-3040438

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

Bug 80755:(Watson Migration Closure)Not 100% sure if this is a bug or some setting that just needs to be changed somewhere

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/

Reporter/Name(from Bugbase): Roman Smolkin / Roman Smolkin (pixelwiz19801)

Created: 11/20/2009

Components: Database, CFQuery

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Win All

Vote Count: 2

Problem:

Not 100% sure if this is a bug or some setting that just needs to be changed somewhere.  If I do a CFQUERY to get some data from an MS SQL DB, all is fine.  But then if I have to change the name of a column in the DB, when I dump the query, the data gets updated but the column names do not.  Somehow ColdFusion is caching the column names in the query, and if they change in the DB, the change is not reflected in ColdFusion.  We have to stop and start the ColdFusion server in order to get the updated column names to be recognized.
Method:

Do a simple select query from an MS SQL 2005 DB.  Then change a column name in SQL Server Manager on the table the select was from.Then run the query again, the column names will not be updated.
Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3040438

External Customer Info:
External Company:  
External Customer Name: Roman Smolkin
External Customer Email: 52B0693546A4D14B992015C2
External Test Config: 11/20/2009

Attachments:

Comments:

[Sankaram 12/02/2009]: verify [Gaurav 04 December 2009]: This is occurring when we use cfqueyparam. This can be resolved when put max pooled statement to 0. Do we need to fix this? Sanjeev please clarify. I don't think this is a bug. Please put your comments and transfer this to me so that I can close the bug. Hemant 2/10/10: Gaurav to provide details for doc. Gaurav 2/11/2010: We are not going to fix this bug. Transferring this to Sanoj for documentation. This has to be noted or commented in live docs : Issue: If we do a simple select query from an MS SQL 2005 DB. Then change a column name in SQL Server Manager on the table the select was from.Then run the query again, and dump the result the column names will not be updated. Reason: This is happening because pooling is enabled in CF server (i.e. max pooled statement > 0 ). The column names are internally cached. This is to increase the performance. Workaround: Put Max pooled statement to 0. In development environment where the column names are prone to changes use max pooled statement = 0. In production environment put back the value. Bug History Timestamp|name|field|from value|to value| 20 Nov 2009 01:33:07 GMT | Roman Smolkin | Bug Submitted | | | 20 Nov 2009 04:17:04 GMT | System System | Severity | | 6-Low (Easy workaround & only affects small group) | 20 Nov 2009 04:17:04 GMT | System System | Class Type | | Bug | 1 Dec 2009 20:24:40 GMT | Sankaram Tata | Priority | | B | 1 Dec 2009 20:24:40 GMT | Sankaram Tata | Queue Transfer | | gaurav | 1 Dec 2009 20:24:40 GMT | Sankaram Tata | Target Fix Milestone | | | 1 Dec 2009 20:24:40 GMT | Sankaram Tata | Target Fix Release | | ColdFusion 9.0 | 4 Dec 2009 00:14:59 GMT | Gaurav Tiwari | Queue Transfer | gaurav | sakumar | 13 Dec 2009 19:24:42 GMT | Gaurav Tiwari | Verified | No | Yes | 9 Feb 2010 16:56:47 GMT | Hemant Khandelwal | Queue Transfer | sakumar | gaurav | 11 Feb 2010 01:34:31 GMT | Gaurav Tiwari | Queue Transfer | gaurav | sanoj |
Comment by Kunal S.
22516 | November 10, 2011 10:12:30 PM GMT
Are your queries SELECT *? If so, this bug has been around for an age, and it's about time it got fixed. +1 vote. -- Adam
Vote by External U.
22517 | November 11, 2011 12:38:48 AM GMT
+1 - Verified this issue w/ SELECT *. Changing to column list or restarting MSSQL server, or restarting CF resolves this. Seems a bug that should be fixed.
Vote by External U.
22518 | November 11, 2011 12:38:50 AM GMT