문서의 이전 판입니다!
— 이강우 2015/08/03 16:13
Context.xml
<?xml version='1.0' encoding='utf-8'?>
<Context docBase="/software/docroot/app.war" privileged="true" reloadable="true">
<!-- ### MySQL JDBC JNDI - 1node ###
<Resource name="jdbc/mysql" auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="USERNAME"
password="PASSWORD"
driverClassName="com.mysql.jdbc.Driver"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="60"
logAbandoned="true"
validationQuery="select 1"
url="jdbc:mysql://IPADDRESS:PORT/DBNAME?autoReconnect=true" />
-->
<!-- ### Oracle JDBC JNDI - 1node ###
<Resource name="jdbc/JNDINAME" auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="USERNAME"
password="PASSWORD"
driverClassName="oracle.jdbc.driver.OracleDriver"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="60"
logAbandoned="true"
validationQuery="select 1 from dual"
url="jdbc:oracle:thin:@localhost:1521:SID" />
-->
<!-- ### Oracle RAC JDBC JNDI - 2node ###
<Resource name="jdbc/jndiname" auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="USERNAME"
password="PASSWORD"
driverClassName="oracle.jdbc.driver.OracleDriver"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="60"
logAbandoned="true"
validationQuery="select 1 from dual"
url="jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=1.1.1.1)(port=1521))(address=(protocol=tcp)(host=2.2.2.2)(port=1521)))(connect_data=(service_name=SERVICE_NAME)(failover_mode=(type=select)(method=basic))))" />
-->
<!-- ### Oracle RAC JDBC JNDI - 4node ###
<Resource name="jdbc/JNDINAME" auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="USERNAME"
password="PASSWORD"
driverClassName="oracle.jdbc.driver.OracleDriver"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="60"
logAbandoned="true"
validationQuery="select 1 from dual"
url="jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=1.1.1.1)(port=1521))(address=(protocol=tcp)(host=2.2.2.2)(port=1521))(address=(protocol=tcp)(host=3.3.3.3)(port=1521))(address=(protocol=tcp)(host=4.4.4.4)(port=1521)))(connect_data=(service_name=SERVICE_NAME)(failover_mode=(type=select)(method=basic))))" />
-->
</Context>