[iBatis] Tomcat 의 DataSource연동 설정

1. Tomcat 의 server.xml

DataSource 설정
<Resource name = "jdbc/paint"

2. iBatis의 SqlMapConfig.xml

<sqlMapConfig>
<transactionManager type="JDBC" commitRequired="false">
  <!-- MySQL-->
  <!--
  <dataSource type="SIMPLE">
    <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
    <property name="JDBC.ConnectionURL" value="jdbc:mysql://127.0.0.1:3306/paint"/>
    <property name="JDBC.Username" value="usr"/>
    <property name="JDBC.Password" value="pwd"/>
  </dataSource>
  -->
  <!-- Oracle -->
  <!--
  <dataSource type="SIMPLE">
    <property name="JDBC.Driver" value="oracle.jdbc.OracleDriver"/>
    <property name="JDBC.ConnectionURL" value="jdbc:oracle:@127.0.0.1:1521:paint"/>
    <property name="JDBC.Username" value="usr"/>
    <property name="JDBC.Password" value="pwd"/>
  </dataSource>
-->
  <dataSource type="JNDI">
      <property name="DataSource" value="java:comp/env/jdbc/paint" />
  </dataSource>
</transactionManager>