GVJDBCConnectionBuilder

Description

This element defines the helpers necessary to create JDBC connections.

VulCon / GV Console Configuration

GreenVulcano^® ESB uses the GVJDBCConnectionBuilder adapter for creating JDBC connections. It is used by DataHandler, Excel Report and sql*{{...}} metadata.

If the client's requested connection isn't configured the GVJDBCConnectionBuilder try to instantiate a DataSourceConnectionBuilder using the requested connection name as a DataSource JNDI name.

The following table shows the GVJDBCConnectionBuilder element's attributes:

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:

• Description
• DataSourceConnectionBuilder
• DriverConnectionBuilder
• DriverPoolConnectionBuilder

DataSourceConnectionBuilder

Creates a JDBC connection using a DataSource.

The following table shows the DataSourceConnectionBuilder element's attributes:

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

DriverConnectionBuilder

Creates a JDBC connection using the DriverManager.

The following table shows the DriverConnectionBuilder element's attributes:

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	user name.
password	optional	password.

DriverPoolConnectionBuilder

Creates a JDBC connection pool using Apache DBCP.

The following table shows the DriverPoolConnectionBuilder element's attributes:

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	user name.
password	optional	password.

Might contain the following sub-elements:

• Description
• PoolParameters

PoolParameters

Apache DBCP Pool parameters. All time values 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 sub-elements are:

• Description
• validationQuery: Apache DBCP pooled connection validation query.