[CAMEL-19304] JPA paging support

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 3.21.0, 4.0-RC1, 4.0.0
• Component/s: camel-jpa
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Jacek Szymański
• Created: 30/Apr/23 16:04
• Updated: 02/May/23 16:39
• Resolved: 02/May/23 16:39

Description

Camel JPA endpoint supports option maximumResults, but this is not enough to implement paging. Also, there is no way to specify offset apart from nativeQuery.

maximumResults is static on the endpoint; it may be specified dynamically only using toD, but this means creating dynamic endpoints.

This PR addresses the above:

• adds support for firstResult
• both maximumResults and firstResult may be specified in message headers, these override values specified on the endpoint, if any

Issue Links

• links to: GitHub Pull Request #9970
• links to: GitHub Pull Request #9976