Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 90745 invoked from network); 16 Sep 2009 10:41:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 16 Sep 2009 10:41:17 -0000 Received: (qmail 30018 invoked by uid 500); 16 Sep 2009 10:41:17 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 29972 invoked by uid 500); 16 Sep 2009 10:41:17 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 18574 invoked by uid 99); 16 Sep 2009 10:29:25 -0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: unknown (nike.apache.org: error in processing during lookup of nranade@gemstone.com) X-Virus-Scanned: amavisd-new at gir.gemstone.com Message-Id: <200909161028.n8GASnce015641@mail.pune.gemstone.com> From: "Nilesh Ranade" To: Subject: multiple host/port with network client Date: Wed, 16 Sep 2009 15:58:48 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0071_01CA36E6.93EA3C20" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512 Thread-Index: Aco2uHnSrlgut44bSHiqDWzulowjCw== X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_0071_01CA36E6.93EA3C20 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi, I am using the later derby 10.5.1 version. I read about the replication & failover mechanisms in the product manuals. I had a few queries regarding the network client usage. 1. I tried multiple host/port pairs in the connection string. My connection string looks like the following jdbc:derby://host1:1534/sample1, host2:1534/sample2; create=true; Derby did accept such a connection string and established connection with the first entry. What I would like to know is in case node "host-1" goes down will the network client failover to the "host-2" database. I was looking for the auto failover capability rather than the "warm standby" mentioned in the manuals. 2. In the above connection string representation, if "host-1:1534/sample1" is non rechable at the time of client connection. Will the client move to the 2nd entry and try to establish connection with "host2:1534/sample2" 3. If point 2 can be accomplished can I simulate the auto failover using reconnect timeout ie to say that once host-1 goes down the client will try to establish connection again and connect with the second entry ( "host2/sample2) as the first entry is unreachable. Regards, Nilesh Ranade ------=_NextPart_000_0071_01CA36E6.93EA3C20 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hi,

I am using the later derby 10.5.1 version. I read = about the replication & failover mechanisms in the product manuals. =

I had a few queries regarding the network client = usage.

 

  1. I tried multiple = host/port pairs in the connection string. My connection string looks like the following

jdbc:derby://host1:1534/samp= le1, host2:1534/sample2; create=3Dtrue;

         =   

         =    Derby did = accept such a connection string and established connection with the first entry. What = I would like to know is in case node “host-1” goes down will the = network client failover to the “host-2” database. I was looking for = the auto failover capability rather than the “warm standby” = mentioned in the manuals.

 

  1. In the above = connection string representation, if “host-1:1534/sample1” is non = rechable at the time of client connection. Will the client move to the = 2nd entry and try to establish connection with = “host2:1534/sample2”
  2. If point 2 can be = accomplished can I simulate the auto failover using reconnect timeout ie to say = that once host-1 goes down the client will try to establish connection = again and connect with the second entry ( “host2/sample2) as the = first entry is unreachable.

 

Regards,

Nilesh Ranade

 

------=_NextPart_000_0071_01CA36E6.93EA3C20--