You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@camel.apache.org by "Claus Ibsen (JIRA)" <ji...@apache.org> on 2009/04/16 06:01:32 UTC
[jira] Created: (CAMEL-1534) camel-ibatis - option to filter out
empty select results
camel-ibatis - option to filter out empty select results
--------------------------------------------------------
Key: CAMEL-1534
URL: https://issues.apache.org/activemq/browse/CAMEL-1534
Project: Apache Camel
Issue Type: Improvement
Components: camel-ibatis
Affects Versions: 1.6.0
Reporter: Claus Ibsen
Priority: Minor
Fix For: 2.1.0
The camel-ibatis component routes any result from the database so if a SELECT query returns 0 rows Camel will route an exchange.
We should add an option to iBatis to allow end users to filter out empty results so Camel only route an Exchange if there are > 0 rows.
See nabble:
http://www.nabble.com/IBatis-component-inconsistency-td23045297.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (CAMEL-1534) camel-ibatis - option to filter out
empty select results
Posted by "Claus Ibsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/activemq/browse/CAMEL-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Claus Ibsen resolved CAMEL-1534.
--------------------------------
Resolution: Fixed
Fix Version/s: (was: 2.1.0)
2.0.0
Thanks Joe for the patch. I have applied it.
trunk: 768334.
> camel-ibatis - option to filter out empty select results
> --------------------------------------------------------
>
> Key: CAMEL-1534
> URL: https://issues.apache.org/activemq/browse/CAMEL-1534
> Project: Apache Camel
> Issue Type: Improvement
> Components: camel-ibatis
> Affects Versions: 1.6.0
> Reporter: Claus Ibsen
> Priority: Minor
> Fix For: 2.0.0
>
> Attachments: Camel-1534.patch
>
>
> The camel-ibatis component routes any result from the database so if a SELECT query returns 0 rows Camel will route an exchange.
> We should add an option to iBatis to allow end users to filter out empty results so Camel only route an Exchange if there are > 0 rows.
> See nabble:
> http://www.nabble.com/IBatis-component-inconsistency-td23045297.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (CAMEL-1534) camel-ibatis - option to filter out
empty select results
Posted by "Joe Luo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/activemq/browse/CAMEL-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joe Luo updated CAMEL-1534:
---------------------------
Attachment: Camel-1534.patch
Hi, Claus
Here is the patch for this issue. I added an option "routeEmptyResultSet" onto polling consumer so it will not send an empty resultset to the next hop by default.
However, if an iterator is used ("useIterator=true"), the "routeEmptyResultSet" won't have any effect as the empty list will not contain any individual object at all.
> camel-ibatis - option to filter out empty select results
> --------------------------------------------------------
>
> Key: CAMEL-1534
> URL: https://issues.apache.org/activemq/browse/CAMEL-1534
> Project: Apache Camel
> Issue Type: Improvement
> Components: camel-ibatis
> Affects Versions: 1.6.0
> Reporter: Claus Ibsen
> Priority: Minor
> Fix For: 2.1.0
>
> Attachments: Camel-1534.patch
>
>
> The camel-ibatis component routes any result from the database so if a SELECT query returns 0 rows Camel will route an exchange.
> We should add an option to iBatis to allow end users to filter out empty results so Camel only route an Exchange if there are > 0 rows.
> See nabble:
> http://www.nabble.com/IBatis-component-inconsistency-td23045297.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.