[jira] [Created] (CAMEL-19327) camel-jpa: Single result

["Jacek Szymański (Jira)" <ji...@apache.org>]

Jacek Szymański created CAMEL-19327:
---------------------------------------

             Summary: camel-jpa: Single result
                 Key: CAMEL-19327
                 URL: https://issues.apache.org/jira/browse/CAMEL-19327
             Project: Camel
          Issue Type: Improvement
          Components: camel-jpa
    Affects Versions: 4.0-M3, 3.20.4
            Reporter: Jacek Szymański


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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)