Re: Using multiple DataSource's for fail-over.

2009-09-05 Thread Mohit Anchlia
I don't think. Did you try shutting down one node? You can also look at netadmin tutorial to see what "FAILOVER" means. On Fri, Sep 4, 2009 at 11:58 AM, Bill Davidson wrote: > Mohit Anchlia wrote: >> >> Something like this: >> >> >> (DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS

Re: Using multiple DataSource's for fail-over.

2009-09-04 Thread Bill Davidson
Mohit Anchlia wrote: Something like this: (DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=x)(PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=somesid))) I still haven't been able to locate the documentation, but

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Mohit Anchlia
Something like this: (DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=x)(PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=somesid))) On Wed, Sep 2, 2009 at 11:53 AM, Mohit Anchlia wrote: > Did you look at Oracle RAC d

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Mohit Anchlia
Did you look at Oracle RAC docs? On Wed, Sep 2, 2009 at 11:10 AM, Bill Davidson wrote: > Tim Funk wrote: >>I thought the Oracle JDBC driver allowed for all the nodes to be placed >>into the connect string and the driver was smart enough to detect failover. >>[So its a configuration exercise on the

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Bill Davidson
Tim Funk wrote: >I thought the Oracle JDBC driver allowed for all the nodes to be placed >into the connect string and the driver was smart enough to detect failover. >[So its a configuration exercise on the connection string.] I'm having trouble finding documentation for this capability. Can y

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Bill Davidson
Ognjen Blagojevic wrote: IANA-failover-expert, but one question comes to my mind. What happens when the first server is recovered? Some cached connections will still point to second server, while newly created connections will go to the first one? Actually, it doesn't switch which is the prim

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Bap
Bill, If you are using Oracle RAC, then why dont you use a RAC JDBC URL that contains both nodes? A DBCP testOnBorrow will ensure only current transactions on a node will fail if one of the nodes goes down, and all new requests for connections from the pool will "recover". Bap. Quoting

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Tim Funk
I thought the Oracle JDBC driver allowed for all the nodes to be placed into the connect string and the driver was smart enough to detect failover. [So its a configuration exercise on the connection string.] -Tim Ognjen Blagojevic wrote: This is interesting topic. IANA-failover-expert, but o

RE: Using multiple DataSource's for fail-over.

2009-09-02 Thread Jason Pyeron
> -Original Message- > From: Bill Davidson [mailto:bill...@gmail.com] > Sent: Tuesday, September 01, 2009 20:18 > To: 'Tomcat Users List' > Subject: Using multiple DataSource's for fail-over. > > Tomcat 6.0.20 using DBCP DataSource > Java 1.6.0_

Re: Using multiple DataSource's for fail-over.

2009-09-02 Thread Ognjen Blagojevic
This is interesting topic. IANA-failover-expert, but one question comes to my mind. What happens when the first server is recovered? Some cached connections will still point to second server, while newly created connections will go to the first one? Is that acceptable? Regards, Ognjen Bill

Using multiple DataSource's for fail-over.

2009-09-01 Thread Bill Davidson
Tomcat 6.0.20 using DBCP DataSource Java 1.6.0_16 Oracle 10g with RAC. I've got two Oracle RAC nodes, mirroring each other. My current fail-over method if the primary node fails is to shut down the web servers, reconfigure them to use the secondary node and restart the web servers. Not pleasa