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

Ruwan Linton commented on SYNAPSE-533:
--------------------------------------

Rajika, I think it is better to register this as a different extension to the 
SynapseXPathFunctionContext, may be called get-result(), please have a look at 
the way that the get-property function has been registered on the SynapseXPath 
and write a new class called GetResultFunction to provide this functionality.

> 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to