JDBC not seeing updated table structure

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?

If you disable "Maintain Connections" on the DSN in the CF Admin you should have better luck.

Restart ColdFusion.

If you add columns to the end of the table, then you won't see this problem. If you add columns or rearrange other columns, then you may need to restart CF to see the change.