[3]. WEB/WAS Server 구성 - 8. DataSource 설정
01. Oracle 설정
- 드라이버 설치
모듈 위치 : /home/jboss/EAP-7.1.0/modules/system/layers/base
폴더 생성 : mkdir com/oracle/main
드라이버 업로드 : com/oracle/main/ojdbc7-12.1.0.2.jar
- 모듈 파일 생성
[root@localhost main]# vi module.xml
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.5" name="com.oracle">
<resources>
<resource-root path="ojdbc7-12.1.0.2.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>
- 권한 설정
[root@localhost com]# chown jboss.jboss -R oracle
02. MySql 설정
- 드라이버 설치
모듈 위치 : /home/jboss/EAP-7.1.0/modules/system/layers/base
폴더 생성 : mkdir com/mysql/main
드라이버 업로드 : com/mysql/main/mysql-connector-java-8.0.11.jar
- 모듈 파일 생성
[root@localhost main]# vi module.xml
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.5" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-8.0.11.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>
- 권한 설정
[root@localhost com]# chown jboss.jboss -R mysql
03. PgSql 설정
- 드라이버 설치
모듈 위치 : /home/jboss/EAP-7.1.0/modules/system/layers/base
폴더 생성 : mkdir com/pgsql/main
드라이버 업로드 : com/pgsql/main/postgresql-42.2.4.jar
- 모듈 파일 생성
[root@localhost main]# vi module.xml
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.5" name="com.pgsql">
<resources>
<resource-root path="postgresql-42.2.4.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
<module name="javax.servlet.api" optional="true"/>
</dependencies>
</module>
- 권한 설정
[root@localhost com]# chown jboss.jboss -R pgsql
04. 데이터소스 설정
- Node1 : /home/jboss/EAP-7.1.0/SERVER11/configuration/standalone-full-ha.xml
- Node2 : /home/jboss/EAP-7.1.0/SERVER12/configuration/standalone-full-ha.xml
<subsystem xmlns="urn:jboss:domain:datasources:5.0">
<datasources>
<datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jndi-name="java:/MyWeb-OracleDS" pool-name="MyWeb-OracleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@192.168.20.1:1521:ORCL</connection-url>
<driver>oracle</driver>
<security>
<user-name>ID</user-name>
<password>PW</password>
</security>
</datasource>
<datasource jta="true" jndi-name="java:/MyWeb-MySqlDS" pool-name="MyWeb-MySqlDS" enabled="true" use-ccm="true">
<connection-url>jdbc:mysql://192.168.20.1:3306/MyWeb_DATA_REAL?autoReconnect=true&useTimezone=true&serverTimezone=UTC</connection-url>
<driver-class>com.mysql.cj.jdbc.Driver</driver-class>
<driver>mysql</driver>
<security>
<user-name>ID</user-name>
<password>PW</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
<background-validation>true</background-validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
</validation>
</datasource>
<datasource jta="true" jndi-name="java:/MyWeb-PgSqlDS" pool-name="MyWeb-PgSqlDS" enabled="true" use-ccm="true">
<connection-url>jdbc:postgresql://192.168.20.1:5432/MyWeb_data_real</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>pgsql</driver>
<security>
<user-name>ID</user-name>
<password>PW</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>
<background-validation>true</background-validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>
</validation>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="oracle" module="com.oracle">
<xa-datasource-class>oracle.jdbc.driver.OracleDriver</xa-datasource-class>
</driver>
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.cj.jdbc.Driver</xa-datasource-class>
</driver>
<driver name="pgsql" module="com.pgsql">
<xa-datasource-class>org.postgresql.Driver</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>