Mailing-List: contact dev-help@synapse.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@synapse.apache.org
Date: Sun, 4 May 2014 14:51:15 +0000 (UTC)
From: "Yusuf Khan (JIRA)" <jira@apache.org>
To: dev@synapse.apache.org
Message-ID: <JIRA.12422688.1239616166797.227235.1399215075344@arcas>
In-Reply-To: <JIRA.12422688.1239616166797@arcas>
References: <JIRA.12422688.1239616166797@arcas>
Subject: [jira] [Commented] (SYNAPSE-533) DBLookup extracs only first
 element from database
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/SYNAPSE-533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13989004#comment-13989004 ] 

Yusuf Khan commented on SYNAPSE-533:
------------------------------------

Hi ,

Is there any update or alternate to be provided for this issue?

Thanks,
Yusuf

> 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: Extension Mediators, Script mediator
>    Affects Versions: 1.2
>            Reporter: minal sontakke
>            Assignee: Hiranya Jayathilaka
>             Fix For: 2.1
>
>         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.2#6252)

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