在tomcat5.5.x与tomcat5.0.x中配置连接池的差别.docVIP

以前在tomcat5.0.28配置过数据库连接池,具体如下在server.xml文件中: Context path=/eXtreme docBase=eXtreme debug=0?????reloadable=true crossContext=true??????Resource name=jdbc/mssql auth=Container??????type=javax.sql.DataSource /????? ResourceParams name=jdbc/mssql??????parameter??????namefactory/name??????value??????mons.dbcp.BasicDataSourceFactory??????/value??????/parameter??????parameter??????namedriverClassName/name??????value??????com.microsoft.jdbc.sqlserver.SQLServerDriver??????/value??????/parameter??????parameter??????nameurl/name??????value??????jdbc:microsoft:sqlserver://:1433;databaseName=manage??????/value??????/parameter??????parameter??????nameusername/name??????valuesa/value??????/parameter??????parameter??????namepassword/name??????value/value??????/parameter??????parameter??????namemaxActive/name??????value20/value??????/parameter??????parameter??????namemaxIdle/name??????value10/value??????/parameter??????parameter??????namemaxWait/name??????value5000/value??????/parameter??????/ResourceParams??????/Context 现在用tomcat5.5.25，如果还用上面的配置，将报以下异常：mons.dbcp.SQLNestedException: Cannot create JDBC driver of class for connect URL null. 必须的改动一下server.xml文件： Context path=/eXtreme docBase=eXtreme debug=0?????reloadable=true crossContext=true ??????Resource name=jdbc/mssql??????type=javax.sql.DataSource password=??????driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver??????maxIdle=2 maxWait=5000 username=sa??????url=jdbc:microsoft:sqlserver://:1433;databaseName=manage??????maxActive=4 /???/Context ? 当然，这两种方式都要进行如下几部配置： 1、要把数据库驱动jar文件、ant.jar、ant-launcher.jar拷到%CATALINA_HOME%/common/lib下； 2、在web.xml中配置： web-app resource-ref??description/description??res-ref-namejdbc/mssql/res-ref-name??res-typejavax.sql.DataSource/res-type??res-authContainer/res-auth?/resource-ref /web-app ? 配置好了后，做个简单的测试：test.jsp ? %@ page language=java import=java.util.* pageEncoding=gb2312%%@page import=java.sql.*%%@page import=javax.sql.*%%@page