配置tomcat5.0连接池遇到的问题，请高人指点

发布: 2007-6-22 07:38 | 作者: | 来源: | 查看: 21次 | 进入软件测试论坛讨论

我在使用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 acceptCount="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>

文章来源于领测软件测试网 https://www.ltesting.net/

软件测试论坛

领测软件测试网最新更新

软件测试技术相关文章

软件测试培训信息

最新软件测试技术专题

最新领测软件测试网新闻

软件测试技术文章排行榜

编辑推荐
周排行
月排行

软件测试技术分类最新内容