...
| Localtabgroup |
|---|
| Localtab |
|---|
| active | true |
|---|
| title | Connection Pool |
|---|
| 
The parameters available to configure the DBLookup mediator are as follows: | Parameter Name | Description |
|---|
| Connection Information | This parameter is used to specify whether the connection should be taken from a connection pool or a datasource. | | Driver | The class name of the database driver. | | URL | JDBC URL of the database where the data will be looked up. | | User | Username used to connect to the database. | | Password | Password used to connect to the database. |
If you click Add Property, the page will expand to display the following parameters.
The parameters available to manage properties are as follows. | Parameter Name | Description |
|---|
| Name | The name of the property. | | Value | The value of the property. | | Action | This parameter enables a property to be deleted. |
The available properties are as follows.
Name | Value | Description |
|---|
autocommit | true / false | The auto-commit state of the connections created by the pool. | isolation | Connection.TRANSACTION_NONE / Connection.TRANSACTION_READ_COMMITTED / Connection.TRANSACTION_READ_UNCOMMITTED / Connection.TRANSACTION_REPEATABLE_READ / Connection.TRANSACTION_SERIALIZABLE | The isolation state of the connections created by the pool. | initialsize | int | The initial number of connections created when the pool is started. | maxactive | int | The maximum number of active connections that can be allocated from this pool at a given time. Specify a negative value if you do not want to set a limit. | maxidle | int | The maximum number of idle connections to be allowed in the connection pool at a given time. Specify 0 or a negative value if you want the pool to wait indefinitely. | maxopenstatements | int | The maximum number of open statements that can be allocated from the statement pool at a given time. Specify a negative value if you do not want to set a limit. | maxwait | long | The maximum number of milliseconds that the connection pool will wait for a connection to return before throwing an exception when there are no connections available in the pool. Specify 0 or a negative value if you want the pool to wait indefinitely. | minidle | int | The minimum number of idle connections to be allowed in the connection pool at a given time. Specify 0 or a negative value if you want the pool to wait indefinitely. | poolstatements | true/ false | If the value is true, statement pooling is enabled for the pool. | testonborrow | true/ false | If the value is true, objects are validated before they are borrowed from the pool. An object which fails the validation test will be dropped from the pool and another object in the pool will be picked instead. | testwhileidle | true/ false | If the value is true, the objects in the pool will be validated using an idle object evictor (if any exists). Any object which fails this validation test would be dropped from the pool. | validationquery | String | The SQL query that will be used to validate connections from this pool before returning them to the caller. |
|
| Localtab |
|---|
| The UI configuration 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 UI configuration. | Localtabgroup |
|---|
| Localtab |
|---|
|
The parameters available to configure the DBLookup mediator are as follows. | Parameter Name | Description |
|---|
| Connection Information | This parameter is used to specify whether the connection should be taken from a connection pool or a datasource. | | Datasource Type | This parameter is used to specify whether the connection to the databased should be made using an external datasource or a Carbon datasource. | | Initial Context | The initial context factory class. The corresponding Java environment property is java.naming.factory.initial. | | Datasource Name | The naming service provider URL . The corresponding Java environment property is java.naming.provider.url. | | URL | JDBC URL of the database that data will be looked up from. | | User | The user name used to connect to the database. | | Password | The password used to connect to the database. |
If you click Add Property, the page will expand to display the following parameters.
The parameters available to manage properties are as follows. | Parameter Name | Description |
|---|
| Name | The name of the property. | | Value | The value of the property. | | Action | This parameter enables a property to be deleted. |
The available properties are as follows.
Name | Value | Description |
|---|
autocommit | true / false | The auto-commit state of the connections created by the pool. | isolation | Connection.TRANSACTION_NONE / Connection.TRANSACTION_READ_COMMITTED / Connection.TRANSACTION_READ_UNCOMMITTED / Connection.TRANSACTION_REPEATABLE_READ / Connection.TRANSACTION_SERIALIZABLE | The isolation state of the connections created by the pool. | initialsize | int | The initial number of connections created when the pool is started. | maxactive | int | The maximum number of active connections that can be allocated from this pool at a given time. Specify a negative value if you do not want to set a limit. | maxidle | int | The maximum number of idle connections to be allowed in the connection pool at a given time. Specify 0 or a negative value if you want the pool to wait indefinitely. | maxopenstatements | int | The maximum number of open statements that can be allocated from the statement pool at a given time. Specify a negative value if you do not want to set a limit. | maxwait | long | The maximum number of milliseconds that the connection pool will wait for a connection to return before throwing an exception when there are no connections available in the pool. Specify 0 or a negative value if you want the pool to wait indefinitely. | minidle | int | The minimum number of idle connections to be allowed in the connection pool at a given time. Specify 0 or a negative value if you want the pool to wait indefinitely. | poolstatements | true/ false | If the value is true, statement pooling is enabled for the pool. | testonborrow | true/ false | If the value is true, objects are validated before they are borrowed from the pool. An object which fails the validation test will be dropped from the pool and another object in the pool will be picked instead. | testwhileidle | true/ false | If the value is true, the objects in the pool will be validated using an idle object evictor (if any exists). Any object which fails this validation test would be dropped from the pool. | validationquery | String | The SQL query that will be used to validate connections from this pool before returning them to the caller. |
|
| Localtab |
|---|
|
The parameters available to configure the DBLookup mediator are as follows. | Parameter Name | Description |
|---|
| Connection Information | This parameter is used to specify whether the connection should be taken from a connection pool or a datasource. | | Datasource Type | This parameter is used to specify whether the connection to the databased should be made using an external datasource or a Carbon datasource. | | JNDI Name | The JNDI used to look up data. See Configuring a JNDI Datasource for more information. |
|
|
|
|
Adding SQL statements to the DBLookup Mediator
| Anchor |
|---|
| SQL Statements |
|---|
| SQL Statements |
|---|
|
...