jacekszymanski opened a new pull request, #10045: URL: https://github.com/apache/camel/pull/10045
# Description A common use case is that a query (or a find) should return exactly one object, and any other result is to be considered an error. camel-sql supports the outputType=SelectOne option which will cause the component to throw an exception if the query does not return a single row. camel-jpa does not have such an option and thus user must manually check for body size. This PR addresses that. It adds a boolean option ```singleResult```, which, if set to true: - in case of a query will cause the component to put the single fetched object into the message body, not in a List, or throw an exception otherwise - in case of a find, if no object is found the component will throw an exception rather than put null into the body it has no effect on updates, and doesn't alter the consumer. <!-- - Write a pull request description that is detailed enough to understand what the pull request does, how, and why. --> # Target - [x] I checked that the commit is targeting the correct branch (note that Camel 3 uses `camel-3.x`, whereas Camel 4 uses the `main` branch) # Tracking - [x] If this is a large change, bug fix, or code improvement, I checked there is a [JIRA issue](https://issues.apache.org/jira/browse/CAMEL) filed for the change (usually before you start working on it). <!-- # *Note*: trivial changes like, typos, minor documentation fixes and other small items do not require a JIRA issue. In this case your pull request should address just this issue, without pulling in other changes. --> # Apache Camel coding standards and style - [x] I checked that each commit in the pull request has a meaningful subject line and body. <!-- If you're unsure, you can format the pull request title like `[CAMEL-XXX] Fixes bug in camel-file component`, where you replace `CAMEL-XXX` with the appropriate JIRA issue. --> - [x] I formatted the code using `mvn -Pformat,fastinstall install && mvn -Psourcecheck` <!-- You can run the aforementioned command in your module so that the build auto-formats your code and the source check verifies that is complies with our coding style. This will also be verified as part of the checks and your PR may be rejected if the checkstyle does not pass. You can learn more about the contribution guidelines at https://github.com/apache/camel/blob/main/CONTRIBUTING.md --> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@camel.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org