Suspected caching issue with Oracle database connection

[bluto99]

We have a coldfusion web page that does a query on an Oracle database using ODBC connection and tnsnames.ora. When the database is down it the page displayd this information to the screen. However, we often get in the situation that the database is back up again but the coldfusion page still shows it as down. Eventually, after a couple of hours, the database is shown as up again.

I believe the problem may be that coldfusion is caching some information. This is what I found in the coldfusion application.log when the database was up!

"Error","2372","10/04/06","01:29:06",,"ODBC Error Code = S1000 (General error)<P> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-03114: not connected to ORACLE.<P><P> SQL = ""select...etc.

 

[SnakeHollywood]

One of the reasons is using SELECT * in your queries, this causes caching of the results.
If you are doing this, try changing the query to explicitly specify the column names.


Regards
--
Russ Michaels
CFDeveloper.co.uk
ColdFusion Developer community and FREE developer hosting

 

[bluto99]

Thanks, the problem was will the caching of the ODBC connection which can be altered through the ColdFusion administrator.