H2 Database Tutorial and expert Tips

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

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

Configuring a Datasource with MySQL on WildFly

In this tutorial we will learn how to install and configure a Datasource on WildFly which uses MySQL or MariaDB as Database. MySQL set up In order to install MySQL, please follow the Installation Guide available: https://dev.mysql.com/doc/mysql-getting-started/en/#mysql-getting-started-installing As an alternative, if you have available docker, you can start a MySQL instance in a minute with: … Read more

Configuring a datasource with PostgreSQL and JBoss/WildFly

This tech tip shows how you can install and configure PostgreSQL with JBoss / WildFly going into the details of PostGreSQL installation, configuration and tuning.  We will also learn how to configure hibernate postgresql dialect in a JPA application. Installing PostgreSQL We will assume that you are running on a Linux machine. Firstly, install PostgreSQL: $ … Read more