Topic
3 replies Latest Post - ‏2012-03-14T19:00:59Z by GlenM
GlenM
GlenM
8 Posts
ACCEPTED ANSWER

Pinned topic JDBC inbound adapter to return records as an array

‏2012-03-14T10:33:32Z |
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 ???
Updated on 2012-03-14T19:00:59Z at 2012-03-14T19:00:59Z by GlenM
  • SystemAdmin
    SystemAdmin
    67 Posts
    ACCEPTED ANSWER

    Re: JDBC inbound adapter to return records as an array

    ‏2012-03-14T16:19:50Z  in response to GlenM
    Hi 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
    ftp://public.dhe.ibm.com/software/websphere/integration/wsa/library/pdf7501/IBM_Integration_Designer/jdbc_book.pdf

    Hope above information helps.

    Thanks,
    Vinod
  • SystemAdmin
    SystemAdmin
    67 Posts
    ACCEPTED ANSWER

    Re: JDBC inbound adapter to return records as an array

    ‏2012-03-14T18:15:10Z  in response to GlenM
    Hi GlenM,

    Returning records as an array to target module component is not possible in the above case.

    Thanks,
    Vinod
    • GlenM
      GlenM
      8 Posts
      ACCEPTED ANSWER

      Re: JDBC inbound adapter to return records as an array

      ‏2012-03-14T19:00:59Z  in response to SystemAdmin
      Is 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 ???