Difference between revisions of "GVJDBCConnectionBuilder"
(→{{VULCON}} / {{GVCONSOLE}} Configuration) |
(→DriverPoolConnectionBuilder) |
||
Line 70: | Line 70: | ||
Might contain the following sub-elements: | Might contain the following sub-elements: | ||
* Description | * Description | ||
− | * [[PoolParameters]] | + | * [[#PoolParameters|PoolParameters]] |
+ | |||
+ | ====PoolParameters==== | ||
+ | |||
+ | Apache DBCP Pool parameters. All times are in seconds. | ||
+ | |||
+ | The following table shows the PoolParameters element's attributes: | ||
+ | {|class="gvtable" | ||
+ | ! Attribute !! Type !! Description | ||
+ | |- | ||
+ | | minIdle || optional || Controls the maximum number of objects that can sit idle in the pool at any time. | ||
+ | When negative, there is no limit to the number of objects that may be idle at one time. | ||
+ | The default setting for this parameter is 5. | ||
+ | |- | ||
+ | | maxIdle || optional || Controls the maximum number of objects that can sit idle in the pool at any time. | ||
+ | When negative, there is no limit to the number of objects that may be idle at one time. | ||
+ | The default setting for this parameter is 10. | ||
+ | |- | ||
+ | | maxActive || optional || Controls the maximum number of objects that can be allocated by the pool (checked out to clients, or idle awaiting checkout) at a given time. | ||
+ | When non-positive, there is no limit to the number of objects that can be managed by the pool at one time. | ||
+ | When maxActive is reached, the pool is said to be exhausted. | ||
+ | The default setting for this parameter is 15. | ||
+ | |- | ||
+ | | timeBetweenEvictionRuns || optional || Indicates how long the eviction thread should sleep before "runs" of examining idle objects. When non-positive, no eviction thread will be launched. | ||
+ | The default setting for this parameter is 300 seconds (i.e., 5 minutes). | ||
+ | |- | ||
+ | | minEvictableIdleTime || optional || Specifies the minimum amount of time that an object may sit idle in the pool before it is eligible for eviction due to idle time. | ||
+ | When non-positive, no object will be dropped from the pool due to idle time alone. | ||
+ | This setting has no effect unless timeBetweenEvictionRuns > 0. | ||
+ | The default setting for this parameter is 300 seconds (i.e., 5 minutes). | ||
+ | |} | ||
+ | |||
+ | Its subelements are: | ||
+ | * Description | ||
+ | * validationQuery: Apache DBCP pooled connection validation query. | ||
===DataSourceConnectionBuilder=== | ===DataSourceConnectionBuilder=== |
Revision as of 12:36, 20 February 2012
Contents
Description
This element defines the helpers necessary to create a JDBC connection.
VulCon / GV Console Configuration
GreenVulcano® ESB uses the GVJDBCConnectionBuilder adapter for creating a JDBC connection. It is used by DataHandler, Excel Report and sql*{{...}} Metadata.
The following table shows the element's attributes GVJDBCConnectionBuilder:
Attribute | Type | Description |
---|---|---|
type | fixed | This attribute must assume the value module. |
name | fixed | This attribute must assume the value GVJDBC. |
Might contain the following sub-elements:
DriverConnectionBuilder
Creates a JDBC connection using the DriverManager.
The following table shows the element's attributes DriverConnectionBuilder:
Attribute | Type | Description |
---|---|---|
type | fixed | This attribute must assume the value jdbc-connection-builder |
class | fixed | This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.connections.impl.DriverConnectionBuilder. |
name | required | Builder name. |
driver-class | required | JDBC driver class. |
url | required | JDBC connection URL. |
user | optional | JDBC connection user name. |
password | optional | JDBC connection password. |
DriverPoolConnectionBuilder
This item creates a JDBC connection (pool) using Apache DBCP.
The following table shows the element's attributes DriverPoolConnectionBuilder:
Attribute | Type | Description |
---|---|---|
type | fixed | This attribute must assume the value jdbc-connection-builder |
class | fixed | This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.connections.impl.DriverPoolConnectionBuilder. |
name | required | Builder name. |
driver-class | required | JDBC driver class. |
url | required | JDBC connection URL. |
user | optional | JDBC connection user name. |
password | optional | JDBC connection password. |
Might contain the following sub-elements:
- Description
- PoolParameters
PoolParameters
Apache DBCP Pool parameters. All times are in seconds.
The following table shows the PoolParameters element's attributes:
Attribute | Type | Description |
---|---|---|
minIdle | optional | Controls the maximum number of objects that can sit idle in the pool at any time.
When negative, there is no limit to the number of objects that may be idle at one time. The default setting for this parameter is 5. |
maxIdle | optional | Controls the maximum number of objects that can sit idle in the pool at any time.
When negative, there is no limit to the number of objects that may be idle at one time. The default setting for this parameter is 10. |
maxActive | optional | Controls the maximum number of objects that can be allocated by the pool (checked out to clients, or idle awaiting checkout) at a given time.
When non-positive, there is no limit to the number of objects that can be managed by the pool at one time. When maxActive is reached, the pool is said to be exhausted. The default setting for this parameter is 15. |
timeBetweenEvictionRuns | optional | Indicates how long the eviction thread should sleep before "runs" of examining idle objects. When non-positive, no eviction thread will be launched.
The default setting for this parameter is 300 seconds (i.e., 5 minutes). |
minEvictableIdleTime | optional | Specifies the minimum amount of time that an object may sit idle in the pool before it is eligible for eviction due to idle time.
When non-positive, no object will be dropped from the pool due to idle time alone. This setting has no effect unless timeBetweenEvictionRuns > 0. The default setting for this parameter is 300 seconds (i.e., 5 minutes). |
Its subelements are:
- Description
- validationQuery: Apache DBCP pooled connection validation query.
DataSourceConnectionBuilder
This elements creates a JDBC connection using a DataSource.
The following table shows the element's attributes DataSourceConnectionBuilder:
Attribute | Type | Description |
---|---|---|
type | fixed | This attribute must assume the value jdbc-connection-builder |
class | fixed | This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.connections.impl.DataSourceConnectionBuilder. |
name | required | Builder name. |
data-source-jndi | required | DataSource JNDI name. |
Might contain the following sub-elements:
- Description
- JNDIHelper