...
| Table of Contents |
|---|
| maxLevel | 3 |
|---|
| minLevel | 3 |
|---|
| style | border:1 |
|---|
| location | top |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
...
Syntax
The syntax of the DBLookup mediator changes depending on whether you connect to the database using a connection pool, or using a data source. Click on the relevant tab to view the required syntax.
| Localtabgroup |
|---|
| Localtab |
|---|
| active | true |
|---|
| title | Connection Pool |
|---|
| | Code Block |
|---|
| <DBLookup>
<connection>
<pool>
<driver/>
<url/>
|
|
(<driver <url/>
<property name="name" value="value"/>*
</pool>
</connection>
|
|
<user/><statement>
<sql>select something from table where something_else = ?</sql>
<parameter [value="" | expression=""] type="CHAR|VARCHAR|LONGVARCHAR|NUMERIC|DECIMAL|BIT|TINYINT|SMALLINT|INTEGER|BIGINT|REAL|FLOAT|DOUBLE|DATE|TIME|TIMESTAMP"/>*
<result |
|
<password/>name="string" column="int|string"/>*
</statement>+
</DBLookup> |
|
| Localtab |
|---|
| The syntax of the DBLookup mediator further differs based on whether the connection to the database is made using an external datasource or a Carbon datasource. Click on the relevant tab to view the required syntax.| Localtabgroup |
|---|
| Localtab |
|---|
| | Code Block |
|---|
| <DBLookup>
<connection>
<pool>
<dsName/>
<icClass/>
<url/>
<user/>
<password/>
<property name="name" value="value"/>*
</pool>
</connection>
<statement>
<sql>select something from table |
|
|
|
)
where something_else = ?</sql>
<parameter [value="" | expression=""] type="CHAR|VARCHAR|LONGVARCHAR|NUMERIC|DECIMAL|BIT|TINYINT|SMALLINT|INTEGER|BIGINT|REAL|FLOAT|DOUBLE|DATE|TIME|TIMESTAMP"/>*
|
|
|
|
<propertynamevaluevalueint|string"/>*
</statement>+
</DBLookup>
|
|
| Localtab |
|---|
| | Code Block |
|---|
| <DBLookup>
<connection>
<pool>
<dsName/>
</pool>
</connection>
<statement>
<sql>select something from table where something_else = ?</sql>
<parameter [value="" | expression=""] type="CHAR|VARCHAR|LONGVARCHAR|NUMERIC|DECIMAL|BIT|TINYINT|SMALLINT|INTEGER|BIGINT|REAL|FLOAT|DOUBLE|DATE|TIME|TIMESTAMP"/>*
<result name="string" column="int|string"/>*
</statement>+
</DBLookup>
|
|
|
|
|
...
UI Configuration
The UI configuration of the DBLookup mediator changes depending on whether you establish the connection connect to the database using a connection pool, or using a data source. Click on the relevant tab to view the required UI configuration.
...