Receiver JDBC Adapter

[Former Member]

Hi all,

I am using Receiver JDBC adapter in my scenario for update the different tables in one Database.

I am using proxy to JDBC scenario, I got 13 interfaces like this.

1) Can I use same receiver JDBC CC for all 13 interfaces or should i nedd to create 13 communication channels for this.

Kind Regards.

Kiran

[Former Member · Accepted solution]

i think you can use one communication channel for all these 13 interfaces

[Former Member]

Hi,

If my understanding is correct..

You can use same CC for different tables.....

All u need to do is create different mappings and give different table names in mapping,as per the requirement.

Regards.

[Jitendra_Jeswan]

Hi chaitanya -

I guess giving diff. table names in mapping is not Possible as Table name in Receiver JDBC format is part of the Message Type field Name but not the field value..

Regards.

[Jitendra_Jeswan]

Hi -

I guess You will have to create 13 different CC for this as this is being used in different Interfaces.

[Former Member]

Hi,

if the data is not same from proxy and u need to update the different tables with different data in different interfaces then it will not be possible to use the same JDBC channel. as ur sql query will change.

Thnx

Chirag

[Former Member]

Hi All,

Thanks for your quick reply.

In receiver CC we only enter Database name, user name and password. Table name and fields to update and action(Insert or update) we mentioned in Inbound Interfaces.

I already used one CC for all interfaces but performence isuues or other issues is it correct way to do this???

Kind Regards,

Kiran.

Edited by: Kiran Kumar on Feb 25, 2008 10:28 AM

[Former Member]

Hi,

I dont think it will be a performance problem.But monitoring one JDBC channel in respect to 13 channel will be eaisy.

Thnx

Chirag.