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

["Rajika Kumarasiri (JIRA)" <ji...@apache.org>]

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

Rajika Kumarasiri commented on SYNAPSE-533:
-------------------------------------------

I suggest we set the whole result set as a message context property and we provide another XPath extension function for GetPropertyFunction.java class to retrieve the required information form the results set, passing row and the column  index  to the function. 

> DBLookup extracs only first element from database
> -------------------------------------------------
>
>                 Key: SYNAPSE-533
>                 URL: https://issues.apache.org/jira/browse/SYNAPSE-533
>             Project: Synapse
>          Issue Type: Bug
>          Components: Extension Mediators, Script mediator
>    Affects Versions: 1.2
>            Reporter: minal sontakke
>             Fix For: 1.2
>
>   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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


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