DB Report Mediator - User Guide
DB Report Mediator
The dbreport mediator is very similar to the dblookup mediator, but
writes information to a Database, using the specified insert SQL
statement.
Adding a DBReport mediator
Go to Advanced
and click DBReport
to add a DBLookup mediator. Figure 1
illustrate this,

Figure 1: Adding a DBReport mediator
DBReport mediator options
Clicking on the DBReport mediator created as in figure 1 will open up
DBReport mediator specific options. Figure 2 illustrate this,

Figure 2: 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 3 shows the screen after clicking Add Property,

Figure 3: 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 3 and it'll open
up
the screen where you could enter SQL statement option. This is shown in
figure 4.
- 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 4: Adding SQL statements