1. JSP 测试代码:
<%@page import="java.sql.*,java.util.*,javax.naming.*,javax.sql.*,com.gci.project.common.util.*" %>
<%
out.println(new java.util.Date() +"<br>");
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/apts");
//System.out.println("ds=" + ds);
//DbWrapper.executeQuery("select * from runningbus");
%>
2. GlobalNamingResources 配置
在 server.xml中加入:
<GlobalNamingResources>
<Resource
name="jdbc/apts"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="apts"
maxIdle="10"
maxWait="10000"
username="apts"
url="jdbc:oracle:thin:@dev.db.gci.com:1521:aptsdb"
maxActive="30"/>
</GlobalNamingResources>
注意必须,在 conf/context.xml文件中加入这行
<ResourceLink name="jdbc/apts" global="jdbc/apts" type="javax.sql.DataSource"/>
3.在虚拟目录下配置连接池
<Context path="/aptsgjv20" debug="5" reloadable="true" crossContext="true" docBase="E:\aptsgjv20">
....
</Context>