以Oracle + Tomcat 5.0為例:
1.配置server.xml
<Resource?name="jdbc/myoracle"?auth="Container"
??????????????type="javax.sql.DataSource"/>?
<ResourceParams?name="jdbc/myoracle">
??<parameter>
????<name>factory</name>
????<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
??</parameter>
??<parameter>
????<name>driverClassName</name>
????<value>oracle.jdbc.driver.OracleDriver</value>
??</parameter>
??<parameter>
????<name>url</name>
????<value>jdbc:oracle:thin:myschema@127.0.0.1:1521:mysid</value>
??</parameter>
??<parameter>
????<name>username</name>
????<value>scott</value>
??</parameter>
??<parameter>
????<name>password</name>
????<value>tiger</value>
??</parameter>
??<parameter>
????<name>maxActive</name>
????<value>20</value>
??</parameter>
??<parameter>
????<name>maxIdle</name>
????<value>10</value>
??</parameter>
??<parameter>
????<name>maxWait</name>
????<value>-1</value>
??</parameter>
</ResourceParams>
2.配置web.xml
在</web-app>節點下加下面信息:
<resource-ref>
?<description>Oracle?Datasource?example</description>
?<res-ref-name>jdbc/myoracle</res-ref-name>
?<res-type>javax.sql.DataSource</res-type>
?<res-auth>Container</res-auth>
</resource-ref>
3.測試的代碼
Context?initContext?=?new?InitialContext();
Context?envContext??=?(Context)initContext.lookup("java:/comp/env");
DataSource?ds?=?(DataSource)envContext.lookup("jdbc/myoracle");
Connection?conn?=?ds.getConnection();
//etc.