Hurraa
Opensource project to resource management
Datasource configuration
General Configuration
Get MySQL Module for WildFly here and unpack in "WILDFLY_HOME/modules/com", in the end you should have a structure like this "WILDFLY_HOME/modules/com/mysql/main" verify this structure before following the next steps
Like the following video shows: http://www.youtube.com/watch?v=l1daP7PZxNA#t=2729 After 45 minutes
Configuration of the Datasource through jboss cli
After General Configuration section:
- Start Windfly server
- In the folder WILDFLY_HOME/bin run the jboss-cli.sh or .bat
- Enter the CLI next steps
- connect localhost:9990
- ./subsystem=datasources/jdbc-driver=com.mysql:add(driver-name="com.mysql", driver-module-name="com.mysql", driver-xa-datasource-class-name="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" )
- ./subsystem=datasources/data-source=hurraaDS:add(enabled=true , jndi-name="java:/hurraaDS" , use-java-context=true, driver-name="com.mysql" , min-pool-size=10 , max-pool-size=100 , pool-prefill=true, user-name="root" , connection-url="jdbc:mysql://localhost:3306/hurraa" )
Configuration environment vars.
Create a env variable WILDFLY_HOME for arquillian.xml config
- LINUX - most of linux distributions: create a file wf.sh in /etc/profile.d with this content
export WILDFLY_HOME=/your_path_to/wildfly-8.0.0.Final
- MAC - add this content into /etc/profile
WILDFLY_HOME=/your_path_to/wildfly-8.0.0.Final/
Configuration of the datasource at standalone.xml file
<datasource jndi-name="java:/hurraaDS" pool-name="hurraaDS" enabled="true" use-java-context="true">
<connection-url>jdbc:mysql://localhost:3306/hurraa</connection-url>
<driver>com.mysql</driver>
<pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<user-name>root</user-name>
</security>
</datasource>
<drivers>
<driver name="com.mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>