Tomcat 6.0 + Oracle 11g 数据库连接池
Tomcat 6.0 + Oracle 11g 数据库连接池
无需在 server.xml 和web.xml里面添加内容第一:
在项目META-INF下建立文件 context.xml
<?xml version="1.0" encoding="UTF-8"?>
Java代码
- <Context>
- <Resource name="jdbc/myOracle" auth="Container"
- type="oracle.jdbc.pool.OracleDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory"
- connectionCachingEnabled="true" driverClassName="oracle.jdbc.OracleDriver"
- url="jdbc:oracle:thin:@10.0.x.x:test"
- username="scott" password="tiger" maxActive="20" maxIdle="10"
- removeAbandoned="true"
- removeAbandonedTimeout="30"
- maxWait="-1"/>
- </Context>
第二:
项目中调用
- InitialContext ic = new InitialContext();
- DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/myoracle");
- Connection c = ds.getConnection();
- ...
- c.close();
评论暂时关闭