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.

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

Carbon Datasource

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

Figure 2 : Existing Datasources

External

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

Figure 3: External Datasources

Adding properties

Properties can be add to the DBReport Mediator by clicking Add Property, then the configuration UI appears.

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. SQL Statements can be added by clicking Add Statement link.
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.