Switchyard camel-sql-binding

[jcoders]

Good evening,

                    We are using camel-sql-binding in a services project we have here at our company and the details are as follows

<dependency>

  <groupId>org.switchyard.components</groupId>

  <artifactId>switchyard-component-camel-sql</artifactId>

  <scope>provided</scope>

  </dependency>

Switchyard version -1.1.1-p5-redhat-1

Camel version the above release uses i believe is - 2.10.0

I was hoping there is a way to set maxMessagesPerPoll (according to camel this is available in 2.11 - http://camel.apache.org/sql-component.html) when getting data from the database instead of getting all the results, tried using the jpa endpoint but was getting 1 row at a time and doesnt satisfy the use case we have.

Thanks in advance

Regards

Rajat

[jorgemoralespou_2]

Hi,

I guess that you can still make your SQL to limit the number of messages to return with native SQL.

See this for Oracle DB: http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering

[jcoders]

Yea that was my plan b, if there wasn't a camel based solution for the camel version i have.

[tcunning]

Shouldn't limiting the number of results with SQL be the first option though?   That would mean less rows retrieved at the SQL level rather than the client level (camel).    Seems like performance-wise that would be the better choice.