Skip to Content
avatar image
Former Member

Sender JDBC adapter to fetch data from Oracle DB

Sender JDBC adapter is configured to fetch data from Oracle DB tables and sent to different MQ queues using JMS receiver adapter based on some identifier from the tables. Now when the adapter polls it fetches multiple rows/records in a single message.

In this scenario each and every row in the table contains a identifier field which determines the destination.Dynamic routing is configured in PI Mapping and value mapping is used to fetch the corresponding MQ Queue.

During testing we found an issue, if a message with two different identifiers is processed then the dynamic routing to corresponding queues is not happening. In this case both messages are going to same queue.

If a messages has multiple rows/records with same identifier then it works. but the above scenario doesn't work.

Is it possible to make the sender adapter to fetch one row at a time from Oracle db.If yes please describe the configs.

Is there any other option available to solve this.?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers