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>