tomcat 数据源配置

conf/context.xml 内容如下：

 

<?xml version='1.0' encoding='utf-8'?>
<Context>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
     
<Resource name="jdbc/dbp" auth="Container" type="javax.sql.DataSource"
  username="dic_dbp" password="dic_dbp"
  driverClassName="oracle.jdbc.driver.OracleDriver"
  url="jdbc:oracle:thin:@192.168.101.136:1521:orcl"
  maxActive="100" maxIdle="50"  maxWait="10000"/>
 
    <!-- iap 127.0.0.1 test-->
  <Resource name="jdbc/iap_local" type="javax.sql.DataSource"
  driverClassName="oracle.jdbc.driver.OracleDriver" maxIdle="2"
  maxWait="5000" username="iap" password="iap"
  url="jdbc:oracle:thin:@192.168.101.164:1521:orcl" maxActive="4"
  factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" />
      

 <Resource name="jdbc/dbp" auth="Container" type="javax.sql.DataSource" username="dic_dbp" password="dic_dbp"
     driverClassName="oracle.jdbc.driver.OracleDriver"
     url="jdbc:oracle:thin:@134.64.101.166:1521:edw" maxActive="100" maxIdle="50"  maxWait="10000"/>
    <Resource
  name="jdbc/config1"
  type="javax.sql.DataSource"
  driverClassName="oracle.jdbc.driver.OracleDriver"
  password="mag_meta"
  minIdle="10"
  maxIdle="20"
  maxWait="10000"
  username="meta_mag"
  url="jdbc:oracle:thin:@134.64.101.166:1521:edw"
  maxActive="20"
  testOnBorrow="true" testWhileIdle="true"
  validationQuery="select 1 from dual"/>

</Context>