Tomcat连接池设置

              今天总算把Tomcat的连接池给搞定了,搞了我好几天的心血啊,现在总算轻松了!可以舒口气了,现在我把 Tomcat连接池的具体方法和步骤写下来:

我先声明下我的环境:Tomcat 5.5.20+SQLSERVER2000 开发版(打了SP4补丁)+Microsoft JDBC Driver SP3+Windows xp sp2

首先,我们在CATALINA_HOME/webapps/目录下按如下所示建好目录:

CATALINA_HOME/webapps/                                              |--/TomcatPool/                                              |                      |--/WEB-INF/                                               |                                        |--/web.xml                                              |--/test.jsp

然后,我们来写test.jsp的内容,如下:

<% @ page contentType = " text/html; charset=GBK " %> <% @ page  import = " java.sql.* " %> <% @ page  import = " javax.sql.* " %> <% @ page  import = " javax.naming.* " %> < html > < head >      < title > 测试 </ title > </ head > < body > <% try ... {Context context = new InitialContext();DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/Pool");Connection conn =ds.getConnection();if(conn!=null)        out.print("恭喜你，数据库连接池连接成功！");conn.close();} catch (Exception ex) ... {    out.print(ex.getMessage());    ex.printStackTrace();} %> </ body > </ html >

 

第三,我们来写web.xml,如下:

 

<? xml version="1.0" encoding="ISO-8859-1" ?> <! DOCTYPE web-appPUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN""http://java.sun.com/dtd/web-app_2_3.dtd" > < web-app >       < display-name > TomcatPoolTest </ display-name >      < description > Test Tomcat Pool </ description >          < resource-ref >              < description > DB Connection </ description >              < res-ref-name > jdbc/Pool </ res-ref-name >              < res-type > javax.sql.DataSource </ res-type >              < res-auth > Container </ res-auth >        </ resource-ref >      </ web-app >

最后,我们还要修改一个地方,那就是CATALINA_HOME/conf/server.xml文件,打开此文件,找到:

<Host appBase="webapps" name="localhost">,在<host></host>中间加入<context>片段,具体如下:

 

< Host           appBase ="webapps"           name ="localhost" > < Context          path ="/TomcatPool"              docBase ="/TomcatPool"                     crossContext ="true"          reloadable ="true" >          < Resource                      auth ="Container"                 name ="jdbc/Pool"                 type ="javax.sql.DataSource"                 password ="123456"                    //这里是连接你数据库用户sa的密码                driverClassName ="com.microsoft.jdbc.sqlserver.SQLServerDriver"                 maxIdle ="30"                 maxWait ="10000"                 username ="sa"                //这里是连接数据库的用户sa                    url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test"      //DatabaseName是你要连接的数据库的名字                maxActive ="100" /> </ Context > </ Host >

现在就可以了,打开Tomcat和SQLSERVER,然后就在IE里面输入地址:http://localhost:8080/TomcatPool/test.jsp 你就可以看到了结果了,快去看看吧!