cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic select querry in sender JDBC channel

Former Member
0 Kudos

Hi,

We are working on a scenario where we need to read data from various database tables , we were trying to see if it is possible that the select querry can be set dynamically so that the same channel can be used to read from the various tables.

Request all to please come up with suggestions as to whether this is possible.

Thanks ,

Pravesh Puria.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos
VijayKonam
Active Contributor
0 Kudos

You might want to consider.. having a stored procedure which takes care of this based on a parameter sent from the out bound message type.

VJ

Former Member
0 Kudos

Hi All,

Thanks VJ for your reply.

Let me reframe my question.

I have multiple database instances at source side. On all instances I have same table name.

My requirement is to poll all these instances table and fetch data.

Do I need to create multiple sender agreements or there is a way to dynamically change the datbase name in sender Communication channel.

Any other solution is also appreciated.

Same is the case with JMS adapter, Multiple instances of JMS are there at source side sending similar structure data in there own queue.

Request you to kindly response.

Regards,

Pravesh