Re: CFMX 8 and Oracle RAC database

2008-04-09 Thread AJ Mercer
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


CFMX 8 and Oracle RAC database

2008-04-08 Thread Alex DeMarco
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:302978
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4