User Close

Search

THE DEVELOPER PORTAL FOR SOA

Understanding the SQL syntax in DB Lookup Mediator

davea's picture

Submitted by davea on June 22, 2009 - 16:47

I have esb 2.02 installed locally on my Centos workstation. I have created a data source from my local mysql db. Now I am using the ESB Mediator to create a web service but I cannot determine the syntax needed. Any help greatly appreciated! Dave

indika's picture

Hi Please look at

Submitted by indika on June 22, 2009 - 21:36.

Hi Please look at configuration_language.html from ESB documentations (You can download as a separate pack) Look at configuration_language.html#dblookup and DB-report There are three samples 360 , 361, 362 and 363 (this use data sources) Before run samples you have to look at samples_setup_guide.html on topic 'Setting up Derby database server' and Setting up Synapse DataSources' Thanks Indika

Login or register to post comments

davea's picture

Thanks for that information

Submitted by davea on June 23, 2009 - 03:35.

I will look a the docs now. Dave

Login or register to post comments

library project main code

Featured

In your cloud environment, if a user is consuming too much of your resources, either you have to control the user's behavior or scale up your resources to cater the situation and charge the user for consuming resources. If you decide to control the user, then, throttling is the answer for you...

WSO2 StratosLive is the public Platform as a Service (PaaS) from WSO2. With its lean, complete and 100% open source model, StratosLive holds key attributes to become competitively prominent in the enterprise cloud space...

Messaging is used with distributed computing to achieve asynchronous communication. An Event is a change of state in a software system. Eventing is referred to as propagating messages which contain those event information through publish and subscribe...

Patterns are essential ingredients for architects when building solutions since patterns make solutions more stable as well as clean. It is important to pick the correct pattern based on the problem or the use-case that is implemented by a solution...

WSO2 Carbon Studio immensely simplifies SOA development by providing a complete Eclipse IDE for service/application development, deployment and execution. This article explains Carbon Studio and its benefits...

Popular Content

Developing Web Services Using Apache Axis2 Eclipse Plugins - Part 1 (456056 reads)
How to Embed an Axis2 based Web Service in your Webapp? (104719 reads)
Hello World with Apache Axis2 (102570 reads)
Web Services Security with Apache Rampart – Part 1 ( Transport Level Security ) (96134 reads)
Downloading a Binary File from a Web Service using Axis2 and SOAP with Attachments (91210 reads)
Developing Web Services Using Apache Axis2 Eclipse Plugins - Part 2 (84671 reads)
Writing Your Own services.xml for Axis2 Web Services (80074 reads)
Reference Guide to Apache Axis2 Client API Parameters (72620 reads)

Learn Cloud

Learn

Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar

Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..

Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)

Tags

WS-* WS-PolicyAttachment WS-Policy WS-Security WS-Eventing Web services WS-Trust WS-ReliableMessaging WS-Policy transports