Page Comparison

...

Localtabgroup

Localtab

active	true
title	Connection Pool

Code Block

	XML
	XML

<DBLookup>
   <connection>
      <pool>
        <driver/>
        <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"/>*
      <result name="string" column="int|string"/>*
   </statement>+
</DBLookup>

Localtab

title	Data source

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

title	External Datasource

Code Block

	XML
	XML

<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"/>*
      <result name="string" column="int|string"/>*
   </statement>+
</DBLookup>

Localtab

title	Carbon Datasource

Code Block

	XML
	XML

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

...

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.

Adding properties to the DBLookup mediator

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. When this maximum limit is reached, no more active connections will be created by the connection pool. Specify 0 or 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. When this maximum limit is reached, no more new statements will be created by the statement pool. Specify 0 or 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

title	Data source

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

title	External Datasource

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.

Adding properties to the DBLookup mediator

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. When this maximum limit is reached, no more active connections will be created by the connection pool. Specify 0 or 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. When this maximum limit is reached, no more new statements will be created by the statement pool. Specify 0 or 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

title	Carbon Datasource

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.

...

Versions Compared

Old Version 6

New Version 7

Key

Adding properties to the DBLookup mediator

Adding properties to the DBLookup mediator