When the JDBC inbound adapter is configured to read database events, the records are polled one-at-a-time and sent to the target module component.
Is there a way to send the polled events to be sent as a list (object array) to the target module component ???
This topic has been locked.
3 replies Latest Post - 2012-03-14T19:00:59Z by GlenM
Pinned topic JDBC inbound adapter to return records as an array
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-03-14T19:00:59Z at 2012-03-14T19:00:59Z by GlenM
SystemAdmin 110000D4XK67 PostsACCEPTED ANSWER
Re: JDBC inbound adapter to return records as an array2012-03-14T16:19:50Z in response to GlenMHi GlenM,
To deliver multiple events to the export, you can set Delivery type (DeliveryType) Activation Spec property to "UNORDERED". The adapter will then delivers all events to the export at once. If you set this to UNORDERED, you must specify multiple connections for the event delivery to allow the adapter to deliver events to the end-point correctly. To specify multiple connections, edit the export file and specify appropriate values for the “Minimum connections (MinimumConnections)” and “Maximum connections (MaximumConnections)” properties.
You can also control how often the adapter polls for events and how many records are delivered to the export at one time by configuring the PollQuantity activation spec property. This property specifies the number of events that the adapter delivers to the export during each poll period.
For more detailed information on this you can refer to the below JDBC adapter userguide
Hope above information helps.
SystemAdmin 110000D4XK67 Posts
GlenM 110000S9DC8 PostsACCEPTED ANSWER
Re: JDBC inbound adapter to return records as an array2012-03-14T19:00:59Z in response to SystemAdminIs there no way to execute the export to return an array set of records to the target module as I've defined the polling freq and max events to be picked for every poll ???