Can we configure the dynamic IP address in receiver JDBC channel

[Former Member]

Hello,

Can we configure the dynamic IP address in receiver JDBC communication channel at runtime.

Thanks,

Soorya.

[Former Member]

No, that is not possible.

The simplest solution would be to define a service and communication channel for each server and then use the receiver determination to determine which service to send to.

The only other way would be to use a receiver java proxy where you would have to code in the JDBC request yourself.

Regards,

Yaghya

[Former Member]

Hi Yagya,

So you mean to say using Java Proxy we have to configure our own code to connect to all the databases using some switch-case statement in the logic.

Thanks,

Soorya

[Former Member]

Yes, exactly. You will be able to interrogate the incoming payload to determine where the database is located and then connect to the respective database to update/read data.

The problem is that you will have to code the access to the databases.

Regards,

Yaghya

[Former Member]

Hi,

I'd say it would much much easier just to use receiver determination conditional switch. quick & reliable.

So do as suggested, create 3 different CCs and set up correct receiver determination. No coding needed in this case.

Peter

[Former Member]

Hello Peter,

I agree with you. But then you have to use both JDBC adapter and Java Proxy at a time.

But with the switch-case logic in the code at Java Proxy receiver its easy to connect to the databases.

Thanks,

Soorya