WildFly Datasource configuration

A javax.sql.DataSource objects simplifies access to a Database by implementing classes that allow you to use connection pool.

In WildFly, the DataSource object is available in all server configurations through the datasources subsystem. Out of the box, an H2 Datasource is available for testing purposes.

You can learn more about DataSource Configuration through the following resources:

DataSource set up

How to set up a Datasource with WildFly

How to configure the DataSource Connection pool

Configuring Agroal Datasource on WildFly

Creating a Datasource using a CLI script

Creating a Datasource using the Web Console

Hardening a DataSource

How to validate Database connections in JBoss / WildFly

How to encrypt the Datasource password

Monitoring / Troubleshooting

How to trace JDBC statements with JBoss and WildFly

Solving “No managed connections available within configured blocking timeout”

Using try-with-resources to close database connections

DataSource and Enterprise applications

How to deploy a DataSource in jboss at application level

How to inject a DataSource in your Enterprise applications

Advanced topics

HA Datasource Configuration

Configuring Datasource JTA and XA settings

How do I access the specific driver Connection with JBoss

Database specific tutorials

Configuring a PostgreSQL DataSource

Configuring MS SQLServer DataSource

Configuring a MySQL DataSource

Datasource cheatsheet

Configuring Agroal Datasource on WildFly

by

WildFly 14 has been released. One of the most interesting features of it is the new Agroal Datasource. Agroal is a datasource connection pool implementation with integration with transaction, security and other systems. In a nutshell, the advantage over the standard connection pool (provided by the datasources subsystem) is that it does not use the … Read more

JBoss AS 5 Datasource configuration

by

In order to create a DataSource (so that you can use JDBC connectivity) you need to create a file ending with -ds.xml under the “deploy” directory of your server. The default Datasource file The default data source for JBoss 5 is the HypersonicDB data source. Here’s the hsqldb-ds.xml that ships with JBoss : <?xml version=”1.0″ … Read more

Demystifying Datasource JTA and XA settings on JBoss-WildFly

by

One topic which is often misunderstood by middleware administrators is the configuration of JTA and XA attributes and their effect on transactions. Let’s see more in practice. Basically on a JBoss AS 6/WildFly configuration you can choose three different strategies as far as transactioons are concerned: 1) Setting jta = false and Non-XA datasource <datasource jta=”false” … Read more

Creating a Datasource on WildFly using the Web Console

by

Creating a Datasource for WildFly 9 is a pretty simple task thanks to the templating wizard that is included on the Web console. First of all you need to download WildFly from http://wildfly.org/downloads/ Let’s see how to configure an Oracle 12c Connection using the ojdbc7.jar Driver. There are multiple strategies for configuring a Datasource, the faster one … Read more