#1.到http://www.mysql.com/downloads/connector/j/下载mysql的驱动包
#2.进入jboss-as-7.1.1.Final\modules\com目录下,建立文件夹mysqldatabase\mysql\main
#3.将mysql-connector-java-5.1.24-bin.jar复制到main文件夹下,并加入module.xml,文件内容如下:
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="com.mysqldatabase.mysql">(这两个是对应的)
<resources>
<resource-root path="mysql-connector-java-5.1.24-bin.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>
#4.进入jboss-as-7.1.1.Final\standalone\configuration,打开standalone.xml文件:
找到 <datasources>标签,里面应该已经有一个默认的datasource:ExampleDS,现在加入我们的mysql的datasource:
<datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true" use-java-context="true">
<connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
<driver>mysql</driver>
<security>
<user-name>root</user-name>
<password>123</password>
</security>
</datasource>
接下来,在drivers中加入mysql的driver
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="mysql" module="com.mysqldatabase.mysql"> 与上面的对应
<driver-class>com.mysql.jdbc.Driver</driver-class>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>
#5,注意事项:
标记为红色部分是必须相同的!