synapse-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajika Kumarasiri (JIRA)" <>
Subject [jira] Updated: (SYNAPSE-533) DBLookup extracs only first element from database
Date Sun, 27 Dec 2009 08:51:29 GMT


Rajika Kumarasiri updated SYNAPSE-533:

    Attachment: SYNAPSE-533.patch

Here is a patch which fix the problem.
Now the result element has an optional rowIndex attribute which you can specify the row of
the result set  to get the required result when there are more than one entry. 
<result name="company_id" column="id" />
<result name="company_price_0" column="price" rowIndex="2"/>
<result name="company_price_1" column="price" rowIndex="4"/>


> 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
>         Attachments: SYNAPSE-533.patch
>   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