MySQL의 JDBC드라이버는 관련 사이트에서 다운로드하면 된다.

(링크는 http://dev.mysql.com/downloads/connector/j/ 이다)

 

1. module 설정

다운로드된 드라이버 파일은 아래와 같은 구조를 만들어 적용한다.

- jboss/modules/com/sql/main/module.xml

- jboss/modules/com/sql/main/드라이버.jar (예를 들면 mysql-connector-java-5.1.34-bin.jar)

아래는 module.xml 내용이다.

<?xml version="1.0" encoding="UTF-8"?>

<module xmlns="urn:jboss:module:1.0" name="com.mysql">
  <resources>
    <resource-root path="mysql-connector-java-5.1.34-bin.jar"/>
  </resources>
  <dependencies>
    <module name="javax.api"/>
  </dependencies>
</module>

 

2. datasource 설정

standalone*.xml 파일 내에 다음과 같이 datasource 설정을 한다.

        <subsystem xmlns="urn:jboss:domain:datasources:1.1">
            <datasources>
                <datasource jndi-name="java:jboss/datasources/mysqlDs" pool-name="mysqlDs" enabled="true" use-java-context="true" use-ccm="true">
                    <connection-url>jdbc:mysql://127.0.0.1:3306/test</connection-url>
                    <driver>com.mysql</driver>
                    <security>
                        <user-name>testuser</user-name>
                        <password>testuser</password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="com.mysql" module="com.mysql"/>
                </drivers>
            </datasources>

 

3. troubleshooting

jboss 부팅시 아래와 같이 에러가 발생하였다.

00:59:19,513 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 25) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
00:59:19,517 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 25) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.fabric.jdbc.FabricMySQLDriver (version 5.1)
00:59:19,522 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 25) JBAS014612: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("jdbc-driver" => "com.mysql")
]): org.jboss.msc.service.DuplicateServiceException: Service jboss.jdbc-driver.com_mysql is already registered
        at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:154) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
        at org.jboss.msc.service.ServiceControllerImpl.startInstallation(ServiceControllerImpl.java:227) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
        at org.jboss.msc.service.ServiceContainerImpl.install(ServiceContainerImpl.java:561) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
        at org.jboss.msc.service.ServiceTargetImpl.install(ServiceTargetImpl.java:201) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
...

해결책: standalone*.xml 파일의 <driver>를 아래처럼 수정해야 함.

                    <driver name="com.mysql" module="com.mysql">
                        <driver-class>com.mysql.jdbc.Driver</driver-class>
                    </driver>