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

来源：互联网发布：公路工程试验软件编辑：程序博客网时间：2024/04/29 21:54

DBCP：http://www.cnblogs.com/ieage/archive/2012/05/22/2512847.html

<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" />

C3P0：http://www.cnblogs.com/xdp-gacl/p/4040103.html

<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"/>

druid：http://www.cnblogs.com/xdp-gacl/p/4040019.html

<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>

0 0