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,
Connection Information - Specify whether the connection is taken from a
connection pool or from a data source
Driver - Database driver
Url - JDBC URL of the database that data will be looked up.
User - Username that's used to connect to the database.
Password - Password used to connect to the database.
Data sources 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,
autocommit = true | false
isolation = Connection.TRANSACTION_NONE |
Connection.TRANSACTION_READ_COMMITTED |
Connection.TRANSACTION_READ_UNCOMMITTED |
Connection.TRANSACTION_REPEATABLE_READ |
Connection.TRANSACTION_SERIALIZABLE
initialsize = int
maxactive = int
maxidle = int
maxopenstatements = int
maxwait = long
minidle = int
poolstatements = true | false
testonborrow = true | false
testwhileidle = true | false
validationquery = String
Adding SQL statements
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.
More than one statement may be specified.
The SQL statement may specify parameters which could be specified as
values or XPath expressions.
The types of parameters could be any valid SQL types. Only the first row
of a result set will be considered and any others are ignored.
Figure 3: Adding SQL statements