tomcat + spring + iBatis JNDI 설정

※ tomcat + spring + iBatis JNDI 설정

1. tomcat server.xml - <GlobalNamingResources> 태그에 <Resource> 추가

<Resource name="skimads"
        auth="Container"
        type="javax.sql.DataSource"
        username="SKIMA_ADM"
        password="kimiplm"
        driverClassName="oracle.jdbc.driver.OracleDriver"
        url="jdbc:oracle:thin:@192.168.0.126:1521:skimadb"
        maxActive="20"
        maxIdle="10" />

2. tomcat server.xml - <Context> 태그에 <ResourceLink> 추가

<ResourceLink name="skimads" global="skimads" type="javax.sql.DataSource" />

3. sqlMapConfig.xml - iBatis sqlMapConfig 설정

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig  PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"  "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

    <settings
        cacheModelsEnabled="true"
        enhancementEnabled="true"
        useStatementNamespaces="true"
        lazyLoadingEnabled="true"
        maxRequests="512"
        maxSessions="128"
        maxTransactions="32" />
       
    <!-- List the SQL Map XML files. -->
    <sqlMap resource="skima/plm/framework/kernel/sql/skima-sql-message.xml" />
    <sqlMap resource="skima/plm/framework/kernel/sql/skima-sql-user.xml" />

</sqlMapConfig>

4. spring bean 설정

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.1.xsd
    http://www.springframework.org/schema/mvc
    http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd">
   
    <bean id="skima.plm.dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="java:comp/env/skimads" />
    </bean>
   
    <bean name="skima.plm.sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
        <property name="sqlMapClient" ref="skima.plm.sqlMapClientFactoryBean" />
    </bean>
   
    <bean name="skima.plm.sqlMapClientFactoryBean" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation" value="config/sql/sqlMapConfig.xml" />
        <property name="dataSource" ref="skima.plm.dataSource" />
    </bean>

</beans>