JBOSS JNDI 설정 -use sqlmap

o. JNDI 없이 사용할 경우

dbs.properties
    C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\dbs.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/pg
user=ID
pword=PASSWORD

---------------------------------
SqlMapConfigS.xml
    C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\SqlMapConfigS.xml

<properties resource="dbs.properties"/>

<transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="${driver}"/>
      <property name="JDBC.ConnectionURL" value="${url}"/>
      <property name="JDBC.Username" value="${user}"/>
      <property name="JDBC.Password" value="${pword}"/>
      <!-- optional properties below -->
      <property name="Pool.MaximumActiveConnectinos" value="100"/>
      <property name="Pool.MaximumIdleConnections" value="50"/>
      <property name="Pool.MaximumCheckoutTime" value="120000"/>
      <property name="Pool.TimeToWait" value="10000"/>
      <property name="Pool.PingQuery" value="select * from ibatis_pool_ping_check"/>
      <property name="Pool.PingConnectionsOlderThan" value="0"/>
      <property name="Pool.PingConnectionsNotUsedFor" value="0"/>
    </dataSource>
  </transactionManager>
--------------------------------------
Test.xml( sqlmap) ,Test.java  그대로 사용.

1. JNDI 추가
     C:\jboss5\docs\examples\jca  폴더에서 DB에 해당되는 설정 파일을
     C:\jboss5\server\default\deploy (서비스 ROOT)폴더에 복사한다.   
     본인은Mysql을 사용하므로 mysql-ds.xml 파일을 복사하였다.

2. 복사한 파일을 열고, JNDI를 추가한다.(encoding설정을 진행함)            

mysql-ds.xml

<local-tx-datasource>
    <jndi-name>JNDI명</jndi-name>
    <connection-url>jdbc:mysql://127.0.0.1:3306/pg?useUnicode=true&amp;characterEncoding=EUC_KR</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>ID</user-name>
    <password>PASS</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>

    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>

3. jboss-web.xml
     C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\jboss-web.xml

jboss-web.xml

<jboss-web>
  <resource-ref>
    <res-ref-name>jdbc/JNDI명</res-ref-name>
    <jndi-name>java:/JNDI명</jndi-name>
  </resource-ref>
</jboss-web>

4. web.xml
      C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\web.xml

web.xml

<web-app>
  <display-name>Welcome to JBoss</display-name>
  <description>
     Welcome to JBoss
  </description>
  <servlet>
    <servlet-name>Status Servlet</servlet-name>
    <servlet-class>org.jboss.web.tomcat.service.StatusServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>Status Servlet</servlet-name>
    <url-pattern>/status</url-pattern>
  </servlet-mapping>
  <resource-ref>
    <description>리소스설명</description>
    <res-ref-name>jdbc/JNDI명</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>
</web-app>

    

5. sqlMap 설정 파일 추가
     C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\SqlMapConfigDS.xml

SqlMapConfigDS.xml

<sqlMapConfig>
  <settings useStatementNamespaces="false"
   cacheModelsEnabled="true"
   enhancementEnabled="true"
   lazyLoadingEnabled="true"
   maxRequests="512"
   maxSessions="128"
   maxTransactions="32"/>
  <transactionManager type="JDBC" commitRequired="true">
    <dataSource type="JNDI">
      <property name="DBJndiContext" value="java:comp/env/jdbc/JNDI명"/>
    </dataSource>
  </transactionManager>
  <sqlMap resource="Test.xml"/>
</sqlMapConfig>

6. Test.xml

Test.xml

<sqlMap namespace="sqlmap명">
  <select id="sqlQuery명" resultClass="hashmap">
    <![CDATA[
      select no, dt, col1 from aa
    ]]>
  </select>
</sqlMap>

7. Test.java

Test.java

package service;
import java.io.*;
import java.util.*;
import java.sql.*;
import com.ibatis.common.resources.*;
import com.ibatis.sqlmap.client.*;
public class Test{
 public Test() {};
 public Iterator getTest() throws SQLException, Exception {
  Reader reader = Resources.getResourceAsReader("SqlMapConfigDS.xml");
  SqlMapClient client = SqlMapClientBuilder.buildSqlMapClient(reader);
  List someList = client.queryForList("sqlQuery명");  
  return someList.iterator(); 
 }
}

8. test.jsp

test.jsp

<%@ page contentType="text/html; charset=euc-kr"%>
<%@ page import="java.io.*, java.util.* " %>
<%@ page import = "service.Test" %>
<%
  Test htest = new Test();
   Iterator<HashMap> iter = htest.getTest();
%>
<html>
<head><title></title></head>
<body>
<h1>TEST</h1><br>
<%= new java.util.Date() %><br><br>
<%
 while(iter.hasNext()) {
  HashMap data = iter.next();
%>
 <br><%= data.get("no")%>,<%= data.get("dt")%>,<%= data.get("col1")%>
<%
 }
%>
</body>
</html>