WildFly Datasource configuration

In this tutorial we will learn how to configure Microsoft SQLServer Datasource on WildFly application server First of all, you need a JDBC Driver which is fit for your SQLServer version. You can download the JDBC Driver from Microsoft’s site: https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server Some popular options include: mssql2017: mssql-jdbc-7.4.1.jre8.jar mssql2016: mssql-jdbc-6.4.0.jre8.jar Then, from the jboss-cli.sh connect and … Read more

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

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

Today I will show how to use a graphical GUI to trace the execution of your Database connection pool running in JBoss AS or WildFly with ton of useful info at your hands. There are already some nice tools to monitor the execution of your database activity like P6Spy or og4jdbc. However all these nice … Read more

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 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

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