synapse-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajika Kumarasiri (JIRA)" <j...@apache.org>
Subject [jira] Commented: (SYNAPSE-533) DBLookup extracs only first element from database
Date Fri, 11 Sep 2009 06:32:58 GMT

    [ 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


Mime
View raw message