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

原创

诺__浅 2021-08-26 15:10:42 博主文章分类：Java ©著作权

文章标签 oracle tomcat mysql html 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>