Tomcat5.0配置数据源

 

<Context path="/spms_yn" docBase="${catalina.home}/webapps/spms_yn" reloadable="true"
        >

  <!-- Uncomment this Valve to limit access to the Admin app to localhost
   for obvious security reasons. Allow may be a comma-separated list of
   hosts (or even regular expressions).
  <Valve className="org.apache.catalina.valves.RemoteAddrValve"
    allow="127.0.0.1"/>
  -->

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

    <Resource name="jdbc/SPMSDS" auth="Container" type="javax.sql.DataSource"/>        
      <ResourceParams name="jdbc/SPMSDS">  
           
      <parameter>       
      <name>factory</name>       
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>       
      </parameter>
      
      <parameter>       
      <name>maxActive</name>       
      <value>50</value>       
      </parameter>      
      
      <parameter>       
      <name>maxIdle</name>       
      <value>20</value>       
      </parameter>       
      
      <parameter>       
      <name>maxWait</name>       
      <value>500</value>       
      </parameter>
      
      <parameter>       
      <name>username</name>       
      <value>sa</value>       
      </parameter>
            
      <parameter>       
      <name>password</name>       
      <value>12345678</value>       
      </parameter>
      
      <parameter>       
      <name>driverClassName</name>       
      <value>com.sybase.jdbc2.jdbc.SybDriver</value>       
      </parameter>
      
      <parameter>       
      <name>url</name>       
      <value>jdbc:sybase:Tds:10.17.34.181:5000/spms_yn?CHARSET=eucgb</value>
      </parameter>
      
 </ResourceParams>

</Context>