I know we've been having intermittent problems with the standard MM JDBC drivers that shipped with CF. In random spots it would choke on <cfqueryparam> tags (from what I've been able to google anyhow). I'm hoping that when we move to the MS JDBC drivers that it will clear up this issue as well, I'll let you know.
Rich Kroll Application Developer -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 5:49 PM To: CF-Talk Subject: Re: CF not seeing tables > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236969 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
