MySQL DataSource JBoss EAP wildfly

# module.xml

<module xmlns="urn:jboss:module:1.0" name="com.mysql">

<resources>

<resource-root path=“mysql-connector-java-5.1.32-bin.jar"/>

</resources>

<dependencies>

<module name="javax.api"/>

</dependencies>

</module>

 

# drivers

<driver name=“mysql" module="com.mysql“>

<driver-class>com.mysql.jdbc.Driver</driver-class>

</driver>

 

# mysql datasource

<datasource jta="false" jndi-name="java:/mysqlJNDI" pool-name=“mysqlDS" enabled="true" use-ccm="false">

<connection-url>jdbc:mysql://xxx.xxx.xxx.xxx:3306/mysql</connection-url>

<driver-class>com.mysql.jdbc.Driver</driver-class>

<driver>mysql</driver>

<pool>

<min-pool-size>2</min-pool-size>

<max-pool-size>5</max-pool-size>

<prefill>true</prefill>

</pool>

<security>

<user-name>jboss</user-name>

<password>jboss</password>

</security>

</datasource>

 

<security>

<security-domain>encds</security-domain>

</security>

 

<security-domain name="encds" cache-type="default">

<authentication>

<login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">

<module-option name="username" value="username"/>

<module-option name="password" value="enc_pwd"/>

<module-option name="managedConnectionFactoryName" value="jboss.jca:service=LocalTxCM"/>

</login-module>

</authentication>

</security-domain>