I ma not sure if it has changed in CF8, but this is what our CF702 connect string looks like
jdbc:macromedia:oracle://mustang-vip:1522;serviceName=iprod;alternateServers=(cougar-vip:1522);loadBalancing=true This seems to be doing the trick. On Wed, Apr 9, 2008 at 2:43 AM, Alex DeMarco <[EMAIL PROTECTED]> wrote: > Using this type of connect string: > > jdbc:oracle:thin:@(description=(address_list= (LOAD_BALANCE=ON) > (address=(host=server1) > (protocol=tcp)(port=1521))(address=(host=server2)(protocol=tcp) > (port=1521)))(connect_data=(service_name= servicename))) > > What should be the expected behavior? When a node in the cluster comes > down should the CFMX throw and error or automatically switch to the other > node? We are doing some testing and when a node comes down we get a cfquery > error. However, wait a minute and hit refresh and the page continues to > work.. Is this the correct behavior? I guess I was expecting a slight > delay in response time while cfmx tried the other node... > > Am I off base here? Or is there something else I am missing? > > thanks! > > - Alex > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
