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:
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
How to validate Database connections in JBoss / WildFly
How to encrypt the Datasource password
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
How to deploy a DataSource in jboss at application level
How to inject a DataSource in your Enterprise applications
Configuring Datasource JTA and XA settings
How do I access the specific driver Connection with JBoss
Configuring a PostgreSQL DataSource
Configuring MS SQLServer DataSource
Configuring a MySQL DataSource
Installing a Datasource on JBoss AS 7 and WildFly as module can be tedious as it requires three commands to complete. However by creating a batch script you can easily automate the process and install it on every distribution with as little as a shell command. Here is a sample script to create a Datasource … Read more
This tutorial shows how to use a Java SE 7 feature called try-with-resources to handle Connection, Statement and ResultSet objects which are retrieved from a JBoss / WildFly Datasource.Prior to Java SE 7, developers needed a finally block to ensure that a resource is closed regardless of whether the try statement successfully completed or not. … Read more
JBoss AS 7.1.1 has been released and one of its appealing news is the “resurrection” of the earlier -ds.xml datasources which can now be deployed as a standalone resource or even as part of an application. We have to admit, we were missing it. Although configuring a datasource with AS7 just requires a few … Read more
A Datasource is the component used by Enterprise applications to connect to the database. The datasource, in turn, uses a Driver to communicate with the underlying database. For this reason, for WildFly to provide database integration, it needs a Driver and a Datasource. Out of the box, WildFly ships with a default configuration, which includes … Read more
