Red Hat JBoss Enterprise Application Platform Administration I

Creating a data source requires installing the relevant JDBC driver.

The management console provides database vendor specific templates to ease data source creation.

A JDBC driver can be installed by using the module add management CLI command.

One JDBC driver can be used for multiple relevant XA and non-XA data sources.

XA data sources provide the capability to roll back multi-resource transactions that partially fail.

A connection pool prevents creating one use database connections. Instead Red Hat JBoss Enterprise Application Platform (JBoss EAP) creates several connections for application usage and stores them in the pool.

The connection pool can be configured by adjusting the <min-pool-size>, <max-pool-size>, and <prefill> settings.

Connections can be validated either as they are pulled from the pool (validate-on-match) or at a certain time interval (background-validation).