Hi Yoshihiro,

Responses to your questions are inline below ...


> On 14 Dec 2015, at 00:30, Yamazaki, Yoshihiro <yoshi_yamaz...@jp.fujitsu.com 
> <mailto:yoshi_yamaz...@jp.fujitsu.com>> wrote:
> 
> 
> Questions regarding the 'Fail over' function of Virtuoso Driver for JDBC
> 
> ーーーーー-
> environment
>  OS : CentOS 6.4
>  Virtuoso Version : 7.2.1
> ------
> 
> 1. When the 'Fail over' function is enabled, under what circumstances the
>  JDBC driver switches connections (in Virtuoso)?
> 
>  To be more precise,
>  Consider you have the following connection configuration:
> 
>    jdbc:virtuoso://LOD1:1111,L0D2:1116/CHARSET=UTF-8
> 
>  In what cases the connection is switched from LOD1 to LOD2?
>  For example:
>  - If the connection to LOD1 fails, LOD2 is connected immediately.
>  - If the connection to LOD1 fails, LOD2 is connected after retrying over 
> N-times.
>  ... etc.
> 

[Hugh] If the connection to LOD1 fails, LOD2 is connected to immediately.

> 
> 
> 2. When using the 'Fail over' function, can you specify the number of
> retries or wait-time before switching to a different connection?
> 
>    Again, consider the following configuration:
> 
>    jdbc:virtuoso://LOD1:1111,L0D2:1116/CHARSET=UTF-8
> 
>    Is it possible to specify the wait time(*1) and number of retries(*2)
>    before the connection gets switched to LOD2?
> 
>    (*1) For example an option like [TIMEOUT=xx] where 'xx' is the wait-time.
>    (*2) For example an option like [RETRY =xx] where 'xx' is the number of 
> retries.
> 
>    In the flow below I try to describe what I would like to do.
> 
>    Connect to LOD1 -> (No response) -> Wait 10sec -> Retry connection to LOD1 
> (1st retry) -> (No response) ->
>    Wait 10sec -> ... -> Retry connection to LOD1 (10th retry) -> (No 
> response) -> Connect to LOD2

[Hugh] No, this is not supported it would just switch to the next server in the 
list immediately as indicated in point 1.

> 
> 
> 
> 3. How can I know if the connection has been switched (from LOD1 to LOD2)?
>   Is there any log that shows this information? or any other way?

[Hugh] No there is no logging to show if a connection switch took place.

Best Regards
Hugh Williams
OpenLink Software

> Best Regards
> 
> -- 
> YAMAZAKI Yoshihiro
> 
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net 
> <mailto:Virtuoso-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to