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
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users