> Hey all, > I've been seeing some strange behavior from our CF server > over the past week > and I was hoping someone here could shed some light on > what's going on. > We're currently running CF 7 on a win 2k box attached to a > MS SQL 2000 > database. Periodically our pages will throw an error > saying that a table > does not exist. I can query this table through QA, and > when I restart the > CF service, all returns to normal. Has anyone else > experienced anything > like this?
> Rich Kroll > Application Developer Like this, yes. Have a solution, no. I know that I've seen instances where the JDBC connection will produce an empty resultset when fetching the column information for a table which I know exists. Recreating the JDBC connection object and executing the same statement again with the new object produces the desired results, which I'm guessing is basically what's happening when you restart the CF server service (since as I understand it CF maintains one open connection for each dsn and of course they all go away when the CF service shuts down). If you have any luck isolating your issue, please let me know. :) s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236968 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
