Tomcat5.0.28 + JDK1.5 + Eclipse3.1数据库连接池问题
其实不想麻烦大家的，但是小弟在网上看了很多例子，还是没有搭建成功，请大家指点一下：
D:\Tomcat5.0\conf\Catalina\localhost 下：jado.xml
------------------------------------
<?xml version= '1.0 ' encoding= 'utf-8 '?>
<Context crossContext= "true " displayName= "jado " docBase= "D:\Workspace\jado\WebRoot\classes " path= "/jado " reloadable= "true " workDir= "work\Catalina\localhost\jado ">
<Resource auth= "Container " name= "jdbc/jado " type= "javax.sql.DataSource "/>
<ResourceParams name= "jdbc/jado ">
<parameter>
<name> factory </name>
<value> org.apache.commons.dbcp.BasicDataSourceFactory </value>
</parameter>
<parameter>
<name> url </name>
<value> jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=testdb </value>
</parameter>
<parameter>
<name> password </name>
<value> sa </value>
</parameter>
<parameter>
<name> maxActive </name>
<value> 20 </value>
</parameter>
<parameter>
<name> maxWait </name>
<value> -1 </value>
</parameter>
<parameter>
<name> driverClassName </name>
<value> com.microsoft.jdbc.sqlserver.SQLServerDriver </value>
</parameter>
<parameter>
<name> username </name>
<value> sa </value>
</parameter>
<parameter>
<name> maxIdle </name>
<value> 10 </value>
</parameter>
</ResourceParams>
</Context>
---------------------------------
D:\Tomcat5.0\conf 下：server.xml
----------------------------
<?xml version= '1.0 ' encoding= 'utf-8 '?>
<Server>
<Listener className= "org.apache.catalina.mbeans.ServerLifecycleListener "/>
<Listener className= "org.apache.catalina.mbeans.GlobalResourcesLifecycleListener "/>
<GlobalNamingResources>
<Environment name= "simpleValue " type= "java.lang.Integer " value= "30 "/>
<Resource auth= "Container " description= "User database that can be updated and saved " name= "UserDatabase " type= "org.apache.catalina.UserDatabase "/>
<ResourceParams name= "UserDatabase ">
<parameter>
<name> factory </name>
<value> org.apache.catalina.users.MemoryUserDatabaseFactory </value>
</parameter>
<parameter>
<name> pathname </name>
<value> conf/tomcat-users.xml </value>
</parameter>
</ResourceParams>
<Resource
name= "jdbc/jado "
type= "javax.sql.DataSource "
password= "sa "
driverClassName= "com.microsoft.jdbc.sqlserver.SQLServerDriver "
maxIdle= "2 "
maxWait= "5000 "
username= "sa "
url= "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=testdb "
maxActive= "4 "/>
</GlobalNamingResources>
<Service name= "Catalina ">
<Connector acceptCount= "100 " connectionTimeout= "20000 " disableUploadTimeout= "true " port= "8888 " redirectPort= "8443 " maxSpareThreads= "75 " maxThreads= "150 " minSpareThreads= "25 ">
</Connector>
<Connector port= "8009 " protocol= "AJP/1.3 " protocolHandlerClassName= "org.apache.jk.server.JkCoyoteHandler " redirectPort= "8443 ">
</Connector>
<Engine defaultHost= "localhost " name= "Catalina ">
<Host appBase= "webapps " name= "localhost ">
<Logger className= "org.apache.catalina.logger.FileLogger " prefix= "localhost_log. " suffix= ".txt " timestamp= "true "/>
</Host>
<Logger className= "org.apache.catalina.logger.FileLogger " prefix= "catalina_log. " suffix= ".txt " timestamp= "true "/>
<Realm className= "org.apache.catalina.realm.UserDatabaseRealm "/>
</Engine>
</Service>
</Server>
--------------------------------
D:\Workspace\jado\WebRoot\WEB-INF 下：web.xml
---------------------------
<?xml version= "1.0 " encoding= "UTF-8 "?>
<web-app xmlns= "http://java.sun.com/xml/ns/j2ee " xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance " version= "2.4 " xsi:schemaLocation= "http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd ">
<servlet>
<servlet-name> action </servlet-name>
<servlet-class> org.apache.struts.action.ActionServlet </servlet-class>
<init-param>
<param-name> config </param-name>
<param-value> /WEB-INF/struts-config.xml </param-value>
</init-param>
<init-param>
<param-name> debug </param-name>
<param-value> 3 </param-value>
</init-param>
<init-param>
<param-name> detail </param-name>
<param-value> 3 </param-value>
</init-param>
<load-on-startup> 0 </load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name> action </servlet-name>
<url-pattern> *.do </url-pattern>
</servlet-mapping>
<resource-ref>
<description> sqlserverDB Connection </description>
<res-ref-name> jdbc/jado </res-ref-name>
<res-type> javax.sql.DataSource </res-type>
<res-auth> Container </res-auth>
</resource-ref>
</web-app>
------------------------------
D:\Workspace\jado\WebRoot 下：index.jsp（网上down的一个例子！）
----------
<%@ page language= "java " pageEncoding= "UTF-8 "%>
<%@ page import= "java.util.* " %>
<%@ page import= "java.sql.* " %>
<%@ page import= "javax.sql.* " %>
<%@ page import= "javax.naming.* " %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+ ":// "+request.getServerName()+ ": "+request.getServerPort()+path+ "/ ";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN ">
<html>
<head>
<base href= " <%=basePath%> ">
<title> My JSP 'TestDesConn.jsp ' starting page </title>
<meta http-equiv= "pragma " content= "no-cache ">
<meta http-equiv= "cache-control " content= "no-cache ">
<meta http-equiv= "expires " content= "0 ">
<meta http-equiv= "keywords " content= "keyword1,keyword2,keyword3 ">
<meta http-equiv= "description " content= "This is my page ">
</head>
<body>
测试tomcat数据库连接池 <br>
<%
int i = 0 ;
try{
Context ctx = null;
DataSource ds = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String jado = "java:comp/env/jdbc/jado " ; //tomcat中配置的jdbi名字
ctx = new InitialContext();
ds = ( DataSource ) ctx.lookup(jado); //通过jndi取得一个连接
conn = ds.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery( "select * from base_user ");
while (rs.next()) {
i++;
}
}catch (Exception e) {
e.printStackTrace();
}
System.out.println( "一共有 " + i + " 记录！ ");
%>
</body>
</html>
-----------------------------------
结果在登录：http://127.0.0.1:8888/jado/ 显示如下界面！郁闷
=============================================================
Directory Listing For /
----------------------------
Filename Size Last Modified
----------------------------
Apache Tomcat/5.0.28
==============================================================
麻烦大家指点我一下，哪里错了，或者配置的有问题，谢谢！
[解决办法]
http://127.0.0.1:8888/jado/index.jsp你先这样访问试试吧
[解决办法]
docBase= "D:\Workspace\jado\WebRoot\classes "
错了，改为工程目录
能明白 <Context crossContext= "true " displayName= "jado " docBase= "D:\Workspace\jado\WebRoot\classes " path= "/jado " reloadable= "true " workDir= "work\Catalina\localhost\jado "> 什么意思不？
