Change the host name of communication channel at runtime

[Former Member]

Hi,

I am connecting to an SQL server using a JDBC receiver communication channel.

The vendor who is managing this SQL server says that he has a primary server with the ip <IP1> and a secondary server with ip <IP2>.

He wants me to switch to IP2 when IP1 is down.

Is there any possibility of to achieve this ?

regards,

Piyush

[Former Member · Accepted solution]

I dont think there is any options available in JDBC adapter to change the host name dynamically...

what u can do is - u create a dummy scenario which will just check whether the database is up or not and store the flag values in PI ABAP stack..

Now before u send data to JDBC u do look up and check which server is up...and based on that u divert ur message to required system.

thats what I can think of now...

chirag

[Former Member · Accepted solution]

You can't do this by using a web dispatcher? Is it a possible option?

[Former Member · Accepted solution]

afaik, sap wd does not support JDBC protocol and JDBC adapter does not have ASMA feature (like HTTP adapter has for instance) ... Anyway, the failover logic you would have to implent would be quite complicated (your custom JDBC adapter with failover feature, ie polling, switch, etc) ! Instead, try to ask your partner to use a logical IP/URL that would switch from IP1 to IP2 seamlessly (clustering, network balancing/failover should be able to do such thing)

Chris

Edited by: Christophe PFERTZEL on Mar 23, 2011 3:34 PM