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

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 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

  1. 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.
  2. 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