You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@camel.apache.org by "Jacek Szymański (Jira)" <ji...@apache.org> on 2023/05/09 05:44:00 UTC
[jira] [Updated] (CAMEL-19327) camel-jpa: Single result
[ https://issues.apache.org/jira/browse/CAMEL-19327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacek Szymański updated CAMEL-19327:
------------------------------------
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 thehttps://issues.apache.org/jira/browse/CAMEL-19327# 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.
was:
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.
> 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: 3.20.4, 4.0-M3
> Reporter: Jacek Szymański
> Priority: Minor
>
> 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 thehttps://issues.apache.org/jira/browse/CAMEL-19327# 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)