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

H2 Database Tutorial and expert Tips

by

H2 DB is an open source lightweight Database written in Java. It ships in JBoss EAP and WildFly application server to speed up developing and testing Java applications. Let’s have a look to the main configuration options and how to create an example application using the H2 DB. What is H2 database? Firstly, let’s see … Read more

How to validate Database connections in JBoss / WildFly

by

This tutorial discusses how to validate database connections using in WildFly so that you can manage reconnection to the database in case of temporary failures. Connection Validation in a nutshell A datasource connection validation helps to ensure that the connections to the database are still valid. The strategy behind connection vaidation is to periodically test … Read more

H2 Database cheatsheet

by

Here is a cheat sheet for H2 Database which shows some common Data definition, Data modification statements, JDBC Settings and H2 Database server administration. Firstly, if you are looking for an introduction to using H2 Database in your applications, then check this tutorial: H2 database tutorial DDL cheat sheet Table Creation (Basic) CREATE TABLE TEST(ID … Read more