tomcat下面配置外部连接池

zrong

在tomcat 安装目录下面 conf下面的 context.xml


<!-- The contents of this file will be loaded for each web application -->
<Context>
<!-- Default set of monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to disable session persistence across Tomcat restarts -->
<!--
<Manager pathname="" />
-->
<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30"  maxWait="10000" username="scott" password="tiger" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:MYORACLE" />
</Context>


后台java

package com.crm.datasource;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

/*
* 获得数据源
* */
public final class CRMDataSource {
//私有构造方法
private CRMDataSource(){
}
//获得数据源对象
private static DataSource getDataSource(){
DataSource ds = null;
try {
ds = (DataSource)new InitialContext().lookup("java:comp/env/jdbc/oracle");
} catch (NamingException e) {
//LogFactory.getLogger("CRMDataSource").error("创建数据源失败");
}
return ds;
}
/**获得链接对象
* @param null
* @return Connection
* */
public static Connection getConn(){
Connection conn = null;
try {
ConnectionPools cp = ConnectionPools.getInstance();
conn = cp.getConnection();
} catch (Exception e) {
//LogFactory.getLogger("CRMDataSource").error("创建链接失败");
}
return conn;
}
}