synapse-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ruwan Linton (JIRA)" <>
Subject [jira] Commented: (SYNAPSE-533) DBLookup extracs only first element from database
Date Fri, 11 Sep 2009 08:03:57 GMT


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:
>             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 :

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:
For additional commands, e-mail:

View raw message