WSO2 ESB - DBReport Mediator

DBReport Mediator

The dbreport mediator is very similar to the dblookup mediator, but writes information to a Database, using the specified insert SQL statement. For configuration information about db mediators , refer dblookup mediator guide

Syntax

<dbreport>
   <connection>
     <pool>
      (
       <driver/>
       <url/>
       <user/>
       <password/>
     |
       <dsName/>
       <icClass/>
       <url/>
       <user/>
       <password/>
     )
       <property name="name" value="value"/>*
     </pool>
   </connection>
   <statement>
     <sql>insert into something values(?, ?, ?, ?)</sql>
     <parameter [value="" | expression=""] type="CHAR|VARCHAR|LONGVARCHAR|NUMERIC|DECIMAL|BIT|TINYINT|SMALLINT|INTEGER|BIGINT|REAL|FLOAT|DOUBLE|DATE|TIME|TIMESTAMP"/>*
    </statement>+
</dblreport>

UI Configuration

Figure 1: DBReport options

DBReport mediator options field descriptions,

Data sources

Data Source

Existing

If existing data source is choosen, clicking "Load Data Sources" will give the available datasource. Then a data source can be selected.

Inline

Like in Pool connection data source configuration properties should be specified.

Adding properties

Figure 2 shows the screen after clicking Add Property,

Figure 2: Adding a property

Property field descriptions,

Adding SQL statements

  1. Click Add Statement link shown in figure 2 and it'll open up the screen where you could enter SQL statement option. This is shown in figure 3.
  2. More than one statement may be specified.

Figure 3: Adding SQL statements