Tomcate5.0 和Tomcate5.5 Oracle RAC 配置和分析

Tomcate 5.5 配置

<Resource name="jdbc/DBConnectionPool"

       auth="Container"

        type="javax.sql.DataSource"

        maxActive="100"

        maxIdle="3"

        maxWait="10000"

        username="test1"

        password="test1"

        driverClassName="oracle.jdbc.OracleDriver"

        url="jdbc:oracle:thin:@

                (DESCRIPTION =

                (ADDRESS_LIST =

                (source_route=off)

                (FAILOVER = ON)

                (LOAD_BALANCE=ON)

                (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1)(PORT = 1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2)(PORT = 1521))

                )

                (CONNECT_DATA =

                (service_name = RAC.pray.com)

                (failover_mode = (type=select))

                )

                )">

      </Resource>

Tomcat5.028

  <Resource name="jdbc/DBConnectionPool" auth="Container" type="oracle.jdbc.pool.OracleConnectionCacheImpl"/>
  <ResourceParams name="jdbc/DBConnectionPool">
    <parameter>
      <name>factory</name>
      <value>oracle.jdbc.pool.OracleDataSourceFactory</value>
    </parameter>
    <parameter>
     <name>user</name>
     <value>test</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value>test</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@
                (DESCRIPTION =
                (ADDRESS_LIST =
                (source_route=off)
                (FAILOVER = ON)
                (LOAD_BALANCE=ON)
                (ADDRESS = (PROTOCOL = TCP)(HOST =racdb1)(PORT = 1521))
                (ADDRESS = (PROTOCOL = TCP)(HOST = racd)(PORT = $DBPORT2))
                )
                (CONNECT_DATA =
                (service_name = rac.pray.com)
                (failover_mode = (type=select))
                )
                )
      </value>
    </parameter>
  </ResourceParams>