在tomcat中的context配置为:
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource
name="jdbc/oracle"
auth="Container"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="10000"
logAbandoned="true"
username="scott"
password="tiger"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@10.1.233.93:1521:oracle"/>
</Context>
在servlet中获得连接的方法是:
InitialContext init;
init = new InitialContext();
Context ctx = (Context)init.lookup("java:comp/env");
ds = (DataSource)ctx.lookup("jdbc/oracle");
conn = ds.getConnection();