Creating a Datasource on WildFly 9 using templates

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 

Since WildFly 9 creating a Datasource is even easier thanks to the templating wizard that is included on the Web console.

First of all you need to download a Beta (or more recent) version of WildFly 9 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 will be deploying the JDBC Driver on WildFly so that module and JDBC driver gets installed in one shot. Turn to the Deployments tab and deploy the JDBC Driver:

wildfly 9 datasource

Next, from the Configuration Tab select Connector -> Datasources. Click to Add a Datasource. The template wizard will start letting you to choose from a set of templates:

wildfly 9 datasource

Click on Next. The wizard will choose for you a default name and a valid JNDI name for the Datasource. You can can the latter as long as it remains a valid JNDI Name (java:/ or java:jboss/):

wildfly 9 datasource

Next, you have to bind the Datasource to a Driver. In the default settings the application server propose you the com.oracle Module name. 

wildfly 9 datasource

 

Since we haven't installed the driver in the JBOSS_HOME/modules path we will choose the "Detected Driver" option instead. The JDBC Driver should be enlisted:

wildfly 9 datasource

Click on next. Complete the Connection Settings by specifying the Connection URL and security settings for your Datasource:

wildfly 9 datasource

Finally, click on Test Connection to verify Connectivity and Done when completed. Et voilà! a Datasource configured in as little as a minute!

Side Notes

As of WildFly 9 some configuration options have been deprecated:

1) Deployable Datasources have been deprecated, so it is not guaranteed that they will be compatible with future versions of the application server

2) The attribute "enabled" attribute has been deprecated too, as you can see from this message on the server logs

WFLYCTL0028: Attribute enabled is deprecated, and it might be removed in future version!

 

Related articles available on mastertheboss.com

How to deploy a DataSource in jboss at application level ?

  Do you need to deploy your DataSource along with your Enterpri

JBoss Datasource HA

This tutorial has been updated for the new release of JBoss Appli

JBoss run out of Connections ?

Have you got No ManagedConnections available error message ? well

How to connect to a DataSource from a remote client?

  If you want to connect to your JBoss Connection Pool from a re

JBoss Datasource configuration

A Datasource is a Java Naming and Directory Interface (JNDI) obje

How do I get the list of Datasources available ?

JBOSS AS 4/5 Users You can use either twiddle: $ twiddle.sh que

Follow us on Twitter