WSO2 ESB DBLookup 中介查询多行 [英] WSO2 ESB DBLookup mediator query multiple rows

问题描述

正如 DBLookup Mediator 的文档中所说，它只返回查询的第一行，其他结果如果是，则被忽略.

As it says in the documentation of the DBLookup Mediator it only returns the first row of the query, the other results if they are, were ignored.

我想知道是否有一种最佳方法"来运行返回多条记录然后处理它们的查询 (SELECT * FROM X).现在，我们正在实现axis2 服务，但还有另一种方法使用wso2 esb 提供的中介来实现该要求??

I want to know if there is a "best way" to run a query (SELECT * FROM X) that return multiple records and then process them. Now a days we are doing that implementing axis2 services but there is another way using a combination of the mediators provided by wso2 esb to accomplished that requirement??

提前致谢.

圣地亚哥.

推荐答案

是 DBlookup 中介器不会返回多行.您可以使用两种替代方法.

Yes DBlookup mediator will not return multiple rows. You can use two alternatives.

1) 使用 WSO2 数据服务服务器创建数据服务，并使用调出中介从 ESB 调用该服务.

1) Use WSO2 Data services Server to create a data service and invoke that service from ESB using call out mediator.

2) 您可以编写一个类中介器来查询数据库中的数据，然后从中创建一个有效负载，然后通过序列发送它.

2) You can write a class mediator to query data from database and then create a the payload from that and then send that through the sequence.

这篇关于WSO2 ESB DBLookup 中介查询多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！