You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@synapse.apache.org by "Vanjikumaran Sivajothy (JIRA)" <ji...@apache.org> on 2017/09/24 20:03:00 UTC

[jira] [Updated] (SYNAPSE-533) DBLookup extracs only first element from database

     [ https://issues.apache.org/jira/browse/SYNAPSE-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vanjikumaran Sivajothy updated SYNAPSE-533:
-------------------------------------------
    Fix Version/s:     (was: 2.1)
                   FUTURE

> DBLookup extracs only first element from database
> -------------------------------------------------
>
>                 Key: SYNAPSE-533
>                 URL: https://issues.apache.org/jira/browse/SYNAPSE-533
>             Project: Synapse
>          Issue Type: Improvement
>          Components: Core, Extension Mediators
>    Affects Versions: 1.2
>            Reporter: minal sontakke
>            Assignee: Hiranya Jayathilaka
>             Fix For: FUTURE
>
>         Attachments: SYNAPSE-533.patch
>
>   Original Estimate: 96h
>  Remaining Estimate: 96h
>
> I just realized that the DBLookup mediator extracts only the first row... :( when i try to use statement like select * from mytable;  and if my table called as mytable contains 3 values like test1, test2 and test 3, when i try to use the same only first element gets displayed ie like test1 and i dont get output as test1,test2, test3.  DBLookup needs to improve this to extract multiple rows if there are multiple rows, in which case the result set will be a list of results which might be a special list that needs to be implement because it can get a XML representation of this list easily.
> Refer discussion at link : http://wso2.org/forum/thread/5181



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@synapse.apache.org
For additional commands, e-mail: dev-help@synapse.apache.org