Sean's info (if I understood correctly) said that Java DNS caching affects JDBC drivers and all sorts of other things too - it's a global setting. I would expect problems if you haven't reset the caching time using the details in the blog entries he highlighted.
Rebooting CF is supposed to clear the cache. -----Original Message----- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:08 To: CF-Talk Subject: DNS caching likely to affect DSNs? (lots of DSN/DNS in here, read carefully :) ) so a while back the problem with Java caching the IP when you use a CFHTTP call and if the IP changes Java would still use the original IP address and not the new IP was highlighed. We're now using a DNS entry for SQL server addresses on SQL DSNs, would you expect this to exhibit similar behaviour should the IP of the SQL server change? We have two SQL server clusters on different IPs and we're planning on testing our disaster recovery plan, ie a fully failed cluster - so the plan is that should we need to switch between SQL clusters we only (at least, that's the plan) have to change the DNS entry (on our DNS server) to the new cluster and we should switch over to the second cluster. any thoughts..or am i just gonna have to try it? john. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190882 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
