{"id":12,"date":"2011-07-12T16:36:40","date_gmt":"2011-07-12T16:36:40","guid":{"rendered":"https:\/\/zorq.net\/b\/?p=12"},"modified":"2012-04-17T08:27:09","modified_gmt":"2012-04-17T08:27:09","slug":"adding-a-mysql-datasource-to-jboss-as-7","status":"publish","type":"post","link":"https:\/\/zorq.net\/b\/2011\/07\/12\/adding-a-mysql-datasource-to-jboss-as-7\/","title":{"rendered":"Adding a MySQL datasource to JBoss AS 7"},"content":{"rendered":"

This post assumes you are using a Unix like system with a bash shell and have already downloaded and extracted the JBoss AS 7 application server.<\/p>\n

Retrieve the MySQL Connector<\/h2>\n

The connector can be downloaded from: http:\/\/dev.mysql.com\/downloads\/connector\/j\/<\/a>. The current version at the time of writing is 5.1.17, further sections of this guide assume that version number.<\/p>\n

Unzip the connector to your downloads folder and save the location of the main JAR in a variable which we can refer to later:<\/p>\n

cd ~\/Downloads\r\nunzip mysql-connector-java-5.1.17.zip\r\nexport MYSQL_JAR=~\/Downloads\/mysql-connector-5.1.17\/mysql-connector-java-5.1.17-bin.jar<\/pre>\n
Add a Module to AS 7<\/h2>\n
AS 7 uses a module system to provide isolation in class loading. We need to create a new module which contains the MySQL Connector J JAR. Move to the the AS installation directory and create the folder structure for the new module:<\/p>\n
\r\nexport JBOSS_HOME=~\/Development\/jboss-as-web-7.0.0.Final\r\ncd $JBOSS_HOME\r\nmkdir -p modules\/com\/mysql\/main<\/pre>\n
Copy the driver jar to the new directory and move to that directory:<\/p>\n
cp $MYSQL_JAR $JBOSS_HOME\/modules\/com\/mysql\/main\r\ncd $JBOSS_HOME\/modules\/com\/mysql\/main<\/pre>\n
Define the module in XML. This is the key part of the process:<\/p>\n
vi module.xml<\/pre>\n
If the version of the jar has changed, remember to update it here:<\/p>\n
\r\n\r\n\r\n\r\n  \r\n    \r\n  <\/resources>\r\n  \r\n    \r\n  <\/dependencies>\r\n<\/module>\r\n<\/pre>\n
The new module directory should now have the following contents:<\/p>\n
\r\nmodule.xml\r\nmysql-connector-java-5.1.17-bin.jar\r\n<\/pre>\n
Create a Driver Reference<\/h2>\n
Now the module has been created, we need to make a reference to it from the main application server configuration file:<\/p>\n
\r\ncd $JBOSS_HOME\/standalone\/configuration\r\nvi standalone.xml\r\n<\/pre>\n
Find the ‘drivers’ element and add a new driver to it:<\/p>\n
\r\n\r\n    \r\n    \r\n        \r\n            org.h2.jdbcx.JdbcDataSource\r\n        <\/xa-datasource-class>\r\n    <\/driver>\r\n<\/drivers>\r\n<\/pre>\n
The ‘h2’ driver is part of the default JBoss configuration. The new driver that needs adding is named ‘mysql’.<\/p>\n
Add the Datasource<\/h2>\n
Go into the configuration directory and open the main configuration file:<\/p>\n
\r\ncd $JBOSS_HOME\/standalone\/configuration\r\nvi standalone.xml\r\n<\/pre>\n
Find the datasources element and add a new datasource inside:<\/p>\n
\r\n\r\n    \r\n        jdbc:mysql:\/\/localhost:3306\/mydb\r\n    <\/connection-url>\r\n    \r\n        mysql\r\n    <\/driver>\r\n    \r\n        \r\n            root\r\n        <\/user-name>\r\n        \r\n            \r\n        <\/password>\r\n    <\/security>\r\n    \r\n        \r\n            100\r\n        <\/prepared-statement-cache-size>\r\n        \r\n    <\/statement>\r\n<\/datasource>\r\n<\/pre>\n
Start the Application Server<\/h2>\n
Now try running the application server. Make sure you run initially as a user which has write access to the modules directory where you placed the MySQL connector JAR. This is because the appication server seems to generate an index of the directories inside the JAR.<\/p>\n
\r\ncd $JBOSS_HOME\r\nbin\/standalone.xml\r\n<\/pre>\n
Hopefully, amongst the application server’s console output you should see the following:<\/p>\n
\r\n20:31:33,843 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) Bound data source [java:\/mydb]\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
This post assumes you are using a Unix like system with a bash shell and have already downloaded and extracted the JBoss AS 7 application server. Retrieve the MySQL Connector The connector can be downloaded from: http:\/\/dev.mysql.com\/downloads\/connector\/j\/. The current version at the time of writing is 5.1.17, further sections of this guide assume that version […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[22,21,4],"class_list":["post-12","post","type-post","status-publish","format-standard","hentry","category-jboss","tag-java","tag-jboss","tag-mysql"],"_links":{"self":[{"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/posts\/12","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/comments?post=12"}],"version-history":[{"count":26,"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/posts\/12\/revisions"}],"predecessor-version":[{"id":65,"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/posts\/12\/revisions\/65"}],"wp:attachment":[{"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/media?parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/categories?post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zorq.net\/b\/wp-json\/wp\/v2\/tags?post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}