Tomcat realm 설정 방법

 

http://jakarta.apache-korea.org/tomcat/tomcat-4.1-doc/realm-howto.html
http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html

위의 두곳을 참고한다.

참고로 톰캣의 server.xml을 편집하는 것이고, 아래는 ssg 라는 context 를 설정한 샘플이다.

    <Context path="/ssg" reloadable="true"
     docBase="D:\workspace\Eclipse_workspace\ssg\web"
     workDir="D:\workspace\Eclipse_workspace\ssg\work\org\apache\jsp">

     <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="9"
     driverName="com.mysql.jdbc.Driver"
     connectionURL="jdbc:mysql://localhost:3306/ssg"
     connectionName="dbuser" connectionPassword="dbpassword"
     digest="MD5"
     userTable="emp_master" userNameCol="EMPNO" userCredCol="PASSWORD"
     userRoleTable="emp_role" roleNameCol="ROLE" />

     <Logger
      className="org.apache.catalina.logger.FileLogger"
      prefix="localhost_DBTest_log." suffix=".txt" timestamp="true" />

     <Resource auth="Container" name="UserTransaction" scope="Shareable" type="javax.transaction.UserTransaction"/>

     <Resource name="jdbc/SSGDataSource" auth="Container"
      type="javax.sql.DataSource" />

     <ResourceParams name="UserTransaction">
      <parameter>
       <name>jotm.timeout</name>
       <value>60</value>
      </parameter>
      <parameter>
       <name>factory</name>
       <value>org.objectweb.jotm.UserTransactionFactory</value>
      </parameter>
     </ResourceParams>

     <ResourceParams name="jdbc/SSGDataSource">
      <parameter>
       <name>factory</name>
       <value>
        org.apache.commons.dbcp.BasicDataSourceFactory
       </value>
      </parameter>

      <!-- Maximum number of dB connections in pool. Make sure you
       configure your mysqld max_connections large enough to handle
       all of your db connections. Set to 0 for no limit.
      -->
      <parameter>
       <name>maxActive</name>
       <value>100</value>
      </parameter>

      <!-- Maximum number of idle dB connections to retain in pool.
       Set to 0 for no limit.
      -->
      <parameter>
       <name>maxIdle</name>
       <value>30</value>
      </parameter>

      <!-- Maximum time to wait for a dB connection to become available
       in ms, in this example 10 seconds. An Exception is thrown if
       this timeout is exceeded.  Set to -1 to wait indefinitely.
      -->
      <parameter>
       <name>maxWait</name>
       <value>10000</value>
      </parameter>

      <!-- MySQL dB username and password for dB connections  -->
      <parameter>
       <name>username</name>
       <value>dbuser</value>
      </parameter>
      <parameter>
       <name>password</name>
       <value>dbpassword</value>
      </parameter>

      <!-- Class name for mm.mysql JDBC driver -->
      <parameter>
       <name>driverClassName</name>
       <value>org.gjt.mm.mysql.Driver</value>
      </parameter>

      <!-- The JDBC connection url for connecting to your MySQL dB.
       The autoReconnect=true argument to the url makes sure that the
       mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
       connection.  mysqld by default closes idle connections after 8 hours.
      -->
      <parameter>
       <name>url</name>
       <value>
        jdbc:mysql://localhost:3306/ssg
       </value>
      </parameter>
     </ResourceParams>
</Context>