Tomcat中JDBCRealm的配置

在配置Tomcat的JDBCRealm的时候，有几个应该注意的地方

   1. 数据库JDBC驱动应该放在${tomcat.home}/server/lib目录下，而不能放在webapps的lib目录下，二者的class loader不同
   2. tomcat在启动时只会自动装载后缀为.jar的jar包，因此如果使用oracle9i的驱动，应把class12.zip改名为class12.jar
   3. 最好将JDBCRealm的配置信息放在webapp的context配置文件中，而不要放在server.xml中


e.g.
<!-- ======================================================================= -->
<!-- This file is deployed to Tomcat 4.1.x using the "setup-tomcat" ant      -->
<!-- task. You can also manually copy it to Tomcat's webapps directory.      -->
<!-- ======================================================================= -->

<!-- To use Tomcat's MemoryRealm (in $CATALINA_HOME/conf/tomcat-users.xml)
     simply comment out both of the Realm's below.  MemoryRealm is the
     default realm for all applications, specified in
     $CATALINA_HOME/conf/server.xml.
    
     To use Tomcat's JDBCRealm, JNDIRealm or JAASRealm, uncomment the
     appropriate section below.  All of these 3 realms require supplemental
     drivers (JAR files) in $CATALINA_HOME/common/lib.
    
     jdbc/mysql: http://www.mysql.com/downloads/api-jdbc-stable.html
                 - JAR: mysql-connector-java-2.0.14-bin.jar
     jdbc/postgresql: http://www.postgresql.org/
                 - JAR: postgresql-jdbc3-7.3.jar
     jndi/ldap:  http://java.sun.com/products/jndi/index.html#download
                 - JAR: ldap.jar
     jaas:       http://free.tagish.net/jaas/index.jsp
                 - JAR: tagishauth.jar

     NOTE: For the JAASRealm, you must also add the path to NTSystem.dll to
     your $PATH environment variable.
    
-->

<!-- Simchronize-selfcare Application Context -->
<Context path="/simchronize-selfcare" docBase="simchronize-selfcare" debug="99" reloadable="true">
    <Logger className="org.apache.catalina.logger.FileLogger"
        prefix="simchronize_selfcare_log." suffix=".txt" timestamp="true"/>

    <!--
       
    <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="oracle.jdbc.driver.OracleDriver"
       connectionURL="jdbc:oracle:thin:@10.168.195.62:1521:SIMCHRO"
      connectionName="SIMCHR_24" connectionPassword="SIMCHR_24"
           userTable="SIMCHR_SELFCARE_USERS" userNameCol="MSISDN" userCredCol="PASSWD"
       userRoleTable="SIMCHR_SELFCARE_USER_ROLES" roleNameCol="ROLE" />
   -->

    <!-- NOTE: If you want to use a DataSourceRealm, the Resource must be a
               global resource -->
    <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="oracle.jdbc.driver.OracleDriver"
       connectionURL="jdbc:oracle:thin:@10.168.195.62:1521:SIMCHRO"
      connectionName="SIMCHR_24" connectionPassword="SIMCHR_24"
           userTable="SIMCHR_SELFCARE_USERS" userNameCol="MSISDN" userCredCol="PASSWD"
       userRoleTable="SIMCHR_SELFCARE_USER_ROLES" roleNameCol="ROLE" />
      
    <Resource name="jdbc/simchronize" auth="Container" type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/simchronize">
        <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>SIMCHR_24</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>SIMCHR_24</value>
        </parameter>
        <!-- Class name for JDBC driver -->
        <parameter>
            <name>driverClassName</name>
            <value>oracle.jdbc.driver.OracleDriver</value>
        </parameter>
        <!-- Autocommit setting.  This setting is required to make
             Hibernate work.  Or you can remove calls to commit(). -->
        <parameter>
            <name>defaultAutoCommit</name>
            <value>true</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:oracle:thin:@10.168.195.62:1521:SIMCHRO</value>
        </parameter>
        <!-- Recover abandoned connections -->
        <parameter>
            <name>removeAbandoned</name>
            <value>true</value>
        </parameter>
        <!-- Set the number of seconds a dB connection has been idle
             before it is considered abandoned.
             -->
        <parameter>
            <name>removeAbandonedTimeout</name>
            <value>60</value>
        </parameter>
        <!-- Log a stack trace of the code which abandoned the dB
             connection resources.
             -->
        <parameter>
            <name>logAbandoned</name>
            <value>true</value>
        </parameter>
    </ResourceParams>
 
</Context>