[SYNAPSE-533] DBLookup extracs only first element from database

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2
• Fix Version/s: FUTURE
• Component/s: Core, Extension Mediators
• Assignee: Hiranya Kasub Jayathilaka
• Reporter: minal sontakke
• Created: 13/Apr/09 09:49
• Updated: 24/Sep/17 20:02

Description

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