[Tomcat] Tomcat 4.1 JNDI 설정

server.xml을 수정한다.

<Context docBase="test" path="/test" reloadable="true" source="org.eclipse.jst.j2ee.server:test">
  <Resource name="jdbc/etax" auth="Container" type="javax.sql.DataSource" />
  <ResourceParams name="jdbc/etax">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
 <name>maxActive</name>
 <value>100</value>
    </parameter>
    <parameter>
 <name>maxIdle</name>
 <value>30</value>
    </parameter>
    <parameter>
 <name>maxWait</name>
 <value>10000</value>
    </parameter>               
    <parameter>
      <name>username</name>
      <value>test_userid</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>test_password</value>
    </parameter>
    <parameter>
 <name>driverClassName</name>
 <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
    </parameter>
    <parameter>
 <name>url</name>
 <value>jdbc:sqlserver://10.123.170.64:1433;databaseName=TEST;integratedSecurity=false;</value>
    </parameter>               
  </ResourceParams>       
</Context>

 

mssql : https://forums.oracle.com/forums/thread.jspa?threadID=1330828