模板
教程
環境
性能
功能
管理
配置tomcat5.0連接池遇到的問題，請高人指點
我在使用tomcat5.0連接池功能時，得到的conn對象總是為空，真是郁悶，請高人指點。多謝多謝了?。。?！
這是我的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"/>
<Resource name="jdbc/hello" type="javax.sql.DataSource"/>
<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>
<ResourceParams name="jdbc/hello">
<parameter>
<name>url</name>
<value>jdbc:oracle:thin@127.0.0.1:1521:jingrui</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service name="Catalina">
<Connector aclearcase/" target="_blank" >cceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" port="8080" 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>
這是我的web.xml加的東東
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app>
<display-name>tia.net web</display-name>
<description>connectDB test</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/hello</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
都是按其文檔幫助中進行的，就是不中
這是測試頁面
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<html>
<body>
<%
DataSource ds = null;
ResultSet rs = null;
Statement stmt = null;
Connection conn = null;
String m_strDriver = "oracle.jdbc.driver.OracleDriver", // 驅動字符串
m_strConURL = "jdbc:oracle:thin:"; // 連接字符串
try
{
Context initContext = new InitialContext();
ds = (DataSource)initContext.lookup ("java:comp/env/jdbc/hello");
//注意connectDB的名稱和上面一致
conn = ds.getConnection();
out.println("has error here");
stmt = conn.createStatement();
String strSql = " select * from emp"; //test為數據庫中的一個表
rs = stmt.executeQuery(strSql);
if(rs==null){out.println("rs is null");}
else
{out.println("okokok");}
while(rs.next())
{
out.println("hello");
}
}
catch(Exception ex)
{
if(conn == null){out.println("conn is null");}
out.println(ex.getMessage());
out.println("has dkjf");
}
finally
{
}
%>
</body>
</html>
原文轉自：http://www.anti-gravitydesign.com
