使用DBCP,C3P0,druid,apache-jdbc配置JNDI数据源

原创

诺__浅 2022-02-16 11:50:18 博主文章分类：Java ©著作权

©著作权归作者所有：来自51CTO博客作者诺__浅的原创作品，请联系作者获取转载授权，否则将追究法律责任

<Resource 
  name="jdbc/blvc" 
  auth="Container" 
  type="javax.sql.DataSource"
  driverClassName="oracle.jdbc.driver.OracleDriver" 
  url="jdbc:oracle:thin:@10.201.128.161:1521:orcl"
  username="blvc" 
  password="blvc" 
  maxActive="100" 
  maxIdle="30" 
  maxWait="10000" />

<Resource 
        name="jdbc/MysqlDataSource" 
        auth="Container"
        factory="org.apache.naming.factory.BeanFactory" 
        type="com.mchange.v2.c3p0.ComboPooledDataSource"
        driverClass="com.mysql.jdbc.Driver"
        idleConnectionTestPeriod="60"
        maxPoolSize="50" 
        minPoolSize="2"
        acquireIncrement="2" 
        user="root" 
        password="root"
        jdbcUrl="jdbc:mysql://192.168.1.144:3306/leadtest"/>

<Resource 
        name="jdbc/OracleDataSource"
        factory="com.alibaba.druid.pool.DruidDataSourceFactory"
        auth="Container"
        type="javax.sql.DataSource"
        driverClassName="oracle.jdbc.OracleDriver"
        url="jdbc:oracle:thin:@192.168.1.229:1521:lead"
        username="lead_oams"
        password="p"
        maxActive="50"
        maxWait="10000"
        removeabandoned="true"
        removeabandonedtimeout="60"
        logabandoned="false"
        filters="stat"/>

apache-jdbc：（需要TOMCAT7以上，看lib下面是否有tomcat-jdbc.jar）

<Context path="/demo" reloadable="true">

  <!--配置多数据源的JNDI -->
  <Resource 
  name="jdbc/comm" 
  auth="Container" 
  type="javax.sql.DataSource"
  factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
  driverClassName="oracle.jdbc.driver.OracleDriver" 
  url="jdbc:oracle:thin:@101.231.192.11:20001:oradb"
  username="COMM" 
  password="COMM" 
  maxActive="100" 
  maxIdle="30" 
  maxWait="10000" />
</Context>