天天看点

Tomcat5.5.x数据源的配置

Tomcat5.5.x的server.xml的配置如下:

   <Resource name="jdbc/navi_bw"

               type="javax.sql.DataSource"

           password="INTRAMAIN"

    driverClassName="oracle.jdbc.driver.OracleDriver"

            maxIdle="10"

            maxWait="-1"

           username="INTRAMAIN"

                url="jdbc:oracle:thin:@192.168.101.205:1521:orgzdb"

          maxActive="20"/>

而不是原有的:

<ResourceParams name="jdbc/navi_bw">

    <parameter>

        <name>factory</name>

        <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

    </parameter>

    <parameter>

        <name>driverClassName</name>

        <value>oracle.jdbc.driver.OracleDriver</value>

    </parameter>

    <parameter>

        <name>url</name>

          <!--jdbc:oracle:thin:@10.100.143.205:1521:orgzdb  -->

          <!--jdbc:oracle:thin:@10.100.143.141:1521:navi01  -->

        <value>jdbc:oracle:thin:@10.100.143.205:1521:orgzdb</value>

    </parameter>

    <parameter>

        <name>driverClassName</name>

        <value>oracle.jdbc.driver.OracleDriver</value>

    </parameter>

    <parameter>

        <name>username</name>

        <value>intramain</value>

    </parameter>

    <parameter>

        <name>password</name>

        <value>intramain</value>

    </parameter>

    <parameter>

        <name>maxActive</name>

        <value>20</value>

    </parameter>

    <parameter>

        <name>maxIdle</name>

        <value>10</value>

    </parameter>

    <parameter>

        <name>maxWait</name>

        <value>-1</value>

    </parameter>

  </ResourceParams>

同时 <Context path="/NaviInsBW" reloadable="true" docBase="E:/vsswork/pj08_04_navi_ins/08Source/Phase2/Online/workspace/NaviInsBW/Web" workDir="E:/vsswork/pj08_04_navi_ins/08Source/Phase2/Online/workspace/NaviInsBW/work/org/apache/jsp" >

              <Logger className="org.apache.catalina.logger.SystemOutLogger" verbosity="4" timestamp="true"/>

              <Loader className="org.apache.catalina.loader.DevLoader" reloadable="true" debug="1"/>

              <ResourceLink name="jdbc/navi" type="javax.sql.DataSource" global="jdbc/navi_bw"/>

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

       </Context>

应该改为

 <Context path="/NaviInsBW" reloadable="true" docBase="E:/vsswork/pj08_04_navi_ins/08Source/Phase2/Online/workspace/NaviInsBW/Web" workDir="E:/vsswork/pj08_04_navi_ins/08Source/Phase2/Online/workspace/NaviInsBW/work/org/apache/jsp" >

              <Logger className="org.apache.catalina.logger.SystemOutLogger" verbosity="4" timestamp="true"/>

              <ResourceLink name="jdbc/navi" type="javax.sql.DataSource" global="jdbc/navi_bw"/>

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

       </Context>