I am using Coldfusion 8 which is connecting to SQL Server 2008, the problem is I have updated a table adding a new column in SSMS, but the JDBC connection is still ‘seeing’ the table prior to the change. How can I essentially ‘refresh’ the JDBC connection? Would restarting the cf server work?
Answer
three things to look at:
1) do not use “select *” syntax – query plans get cached.
2) disable “maintain connections” in the CF admin – you’ll take a slight performance hit, but it will help in development.
3) yes, restarting CF will clear it up, but it’s not necessary for every db change.
Attribution
Source : Link , Question Author : cas06d , Answer Author : scrittler
