关于TOMCAT4.1+SQLSERVER2000 配置数据库连接池的问题

Question

http://dev.csdn.net/develop/article/19/19013.shtm

Answer 1

server.xml格式可能有问题,你可以把server.xml内容贴出来.

Answer 2

server.XML配置有问题。在命令状态下（DOS窗口）启动Tomcat ，可看到出错提示。

Answer 3

1，这是我的server.xml文件
2，在d:/ch13/WEB-INF/WEB.XML加入如下内容：   
  <resource-ref>
  <description>SqlServer Datasource example</description>
  <res-ref-name>jdbc/SqlServerDB</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
  </resource-ref>
3，在common\lib 加如SQLSERVER2000的三个驱动文件
   但还是有问题，手工启动后，Apache Tomcat 4.1服务一会又停止了；我安装Tomcat是随机器启动服务启动的，命令状态下没有办法启动Tomcat，看不到错误。大家看看是什么问题，真是郁闷！  <Server port="8005" shutdown="SHUTDOWN" debug="0">
  <!-- Uncomment these entries to enable JMX MBeans support -->
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
            debug="0"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
            debug="0"/>  <!-- Global JNDI resources -->
  <GlobalNamingResources>    <!-- Test entry for demonstration purposes -->
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved">
    </Resource>
    <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>  </GlobalNamingResources>   <!-- Define the Tomcat Stand-Alone Service -->
  <Service name="Tomcat-Standalone">       <!-- Define a non-SSL Coyote HTTP/1.1 Connector on port 8081 -->
    <Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="8080"               minProcessors="5" maxProcessors="75"
               enableLookups="true" redirectPort="8443"
               acceptCount="100" debug="0" connectionTimeout="20000"
               useURIValidationHack="false" disableUploadTimeout="true" />
        <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
    <Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
               port="8009" minProcessors="5" maxProcessors="75"
               enableLookups="true" redirectPort="8443"
               acceptCount="10" debug="0" connectionTimeout="20000"
               useURIValidationHack="false"
               protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"/>    <!-- Define the top level container in our container hierarchy -->
    <Engine name="Standalone" defaultHost="localhost" debug="0">      <!-- Global logger unless overridden at lower levels -->
      <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="catalina_log." suffix=".txt"
              timestamp="true"/>      <!-- Because this Realm is here, an instance will be shared globally -->      
      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
                 debug="0" resourceName="UserDatabase"/>      <!-- Define the default virtual host -->
      <Host name="localhost" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true">        <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="localhost_log." suffix=".txt"
        timestamp="true"/>      
        <!-- Tomcat Root Context -->
        <!--
          <Context path="" docBase="ROOT" debug="0"/>
        -->        <!-- Tomcat Examples Context -->
        <Context path="/examples" docBase="examples" debug="0"
                 reloadable="true" crossContext="true">
          <Logger className="org.apache.catalina.logger.FileLogger"
                     prefix="localhost_examples_log." suffix=".txt"
           timestamp="true"/>
          <Ejb   name="ejb/EmplRecord" type="Entity"
                 home="com.wombat.empl.EmployeeRecordHome"
               remote="com.wombat.empl.EmployeeRecord"/>          <Environment name="maxExemptions" type="java.lang.Integer"
                      value="15"/>
          <Parameter name="context.param.name" value="context.param.value"
                     override="false"/>
          <Resource name="jdbc/EmployeeAppDb" auth="SERVLET"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/EmployeeAppDb">
            <parameter><name>user</name><value>sa</value></parameter>
            <parameter><name>password</name><value></value></parameter>
            <parameter><name>driverClassName</name>
              <value>org.hsql.jdbcDriver</value></parameter>
            <parameter><name>driverName</name>
              <value>jdbc:HypersonicSQL:database</value></parameter>
          </ResourceParams>
          <Resource name="mail/Session" auth="Container"
                    type="javax.mail.Session"/>
          <ResourceParams name="mail/Session">
            <parameter>
              <name>mail.smtp.host</name>
              <value>localhost</value>
            </parameter>
          </ResourceParams>
          <ResourceLink name="linkToGlobalResource"
                    global="simpleValue"
                    type="java.lang.Integer"/>
        </Context>  <Context path="/product" docBase="d:/product/" debug="5" reloadable="true" crossContext="true"></Context> <Context path="/Webjsp" docBase="D:\productjsp\jsp\Webjsp" debug="5" reloadable="true" crossContext="true"></Context> <Context path="/WebBenServ" docBase="D:\jspbeaser\jsp\WebBenServ" debug="5" reloadable="true" crossContext="true"></Context>
 <!--*************************数据库连接池****************************************************-->
 <!--<Context path="" docBase="ROOT" debug="0" reloadable="true">--><Context path="/ch13" docBase="d:/ch13/" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/SqlServerDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SqlServerDB"><parameter>
<name>factory</name>      
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter><parameter>
<name>driverClassName</name>     
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
  </parameter><parameter>
 <name>url</name>  <value>jdbc:microsoft:sqlserver://127.0.0.1:1433;databa  
    seName=jspdev</value>
  </parameter>  <parameter>
     <name>username</name>
     <value>bn</value>
  </parameter>  <parameter>
     <name>password</name>
     <value>bn</value>
  </parameter>  <parameter>
     <name>maxActive</name>
     <value>20</value>
  </parameter>  <parameter>
     <name>maxIdle</name>
     <value>20</value>
  </parameter>  <parameter>
     <name>maxWait</name>
     <value>-1</value>
  </parameter>     </ResourceParams>
   </Context>
 <!--***************************************************************************************-->
  </Host>
    </Engine>
  </Service>
</Server>

Answer 4

你可以用:http://localhost:8080/admin来配置连接池.
http://blog.csdn.net/funcreal/archive/2004/09/16/106945.aspx