Tomcat6.0连接池配置_Mentos .布丁手札

查看文章

Tomcat6.0连接池配置

2008-06-07 07:23

Tomcat6.0连接池配置

2008-01-25 15:41

1, Tomcat6根目录下， conf文件夹下面：修改context.xml文件；

在<Context>中加入：

<Resource name="jdbc/test"

auth="Container"

type="javax.sql.DataSource"

driverClassName="oracle.jdbc.driver.OracleDriver"

url="jdbc:oracle:thin:@172.29.96.23:1521:ahdb"

username="ahdbs"

password="ahdbs"

maxActive="10"

maxIdle="3"

maxWait="10000" />

2,项目文件架下：WEB-INF目录下：修改web.xml文件：

在<web-app>中加入：

<resource-ref>

<description>DB Connection</description>

<res-ref-name>jdbc/test</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%@ page import="javax.sql.*"%>

<%@ page import="javax.naming.*"%>

try {

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");

DataSource ds = (DataSource) envCtx.lookup("jdbc/test");

Connection conn = ds.getConnection();

Statement stmt = conn.createStatement();

ResultSet rst = stmt.executeQuery("describe host");

while (rst.next()) {

out.println(rst.getString(1));

}

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

4,OK!!!!!!