tomcat配置连接池错误

Question

在conf目录下的server.xm里配置连接池:
在server.xml 的</host> 前面  加上
     <Context path="/ch13" docBase="ch13" debug="0" reloadable="true"  crossContext="true">
<Resource name="jdbc/bn" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/bn">
   <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:micorsoft:sqlserver://127.0.0.1:1433;DatabaseName=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>10</value>
   </parameter>
   <parameter>
       <name>maxWait</name>
       <value>-1</value>
   </parameter>
</ResourceParams>
</Context>
然后启动tomcat,出现一堆警告错误:
2008-3-18 12:52:32 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'debug' to '0' did not find a matching property.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/name'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter/value'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams/parameter'.
2008-3-18 12:52:32 org.apache.tomcat.util.digester.Digester endElement
警告:   No rules found matching 'Server/Service/Engine/Host/Context/ResourceParams测试连接的jsp出现的错误是:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' 是哪里配置错误了呢?还是漏了哪个步骤,高手指点

Answer 1

请参考各个版本Tomcat的连接池配置方法
http://www.java2000.net/viewthread.jsp?tid=1906

Answer 2

java2000_net 
忘了说了,我用的是tomcat6,按楼上的方法在 conf下的context.xml 设置了,结果还是不行,后来又改成在server.xml 加上
<Context path="/ch13" docBase="ch13" debug="5" reloadable="true" crossContext="true"><Resource name="jdbc/bn"
 auth="Container"
 type="javax.sql.DataSource"
 driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
 url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=jspdev"
 username="sa"
 password=""
 maxIdle="30"
 maxWait="10000"
 maxActive="100"
    />
</Context>
才可以连上,奇怪的是虽然可以得到数据了,但是还是有一个警告错误:
2008-3-18 20:38:44 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'debug' to '5' did not find a matching property.
2008-3-18 20:38:44 org.apache.catalina.core.AprLifecycleListener init
信息: Loaded APR based Apache Tomcat Native library 1.1.12.
2008-3-18 20:38:44 org.apache.catalina.core.AprLifecycleListener init
信息: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].为什么认不出debug呢??想不通,请高手指点

Answer 3

<Context path="/hospital2" reloadable="true" docBase="D:\workspace\hospital2" workDir="D:\workspace\hospital2\work" >
<Resource name="jdbc/hospital2" auth="Container"  type="javax.sql.DataSource" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
driverClassName="org.gjt.mm.mysql.Driver" url="jdbc:mysql://localhost/hospital" username="root" password="gahjdwfn" maxActive="150"
maxIdle="2" maxWait="10000"/>
</Context>
加红的那句是什么意思?

Answer 4

1.需要的文件:mysql-5.0.27-win32.zip(安装文件),mysql-connector-java-5.0.4-bin.jar(连接驱动程序),apache-tomcat-6.0.10.exe(安装文件)
2.配置tomcat下的conf下的context.xml文件,在<context></context>之间添加连接池如下: 
<Resource name="jdbc/mysql"   
       auth="Container"  
       type="javax.sql.DataSource"   
       driverClassName="com.mysql.jdbc.Driver"   
       url="jdbc:mysql://localhost/test"   
       username="root"   
       password="root"   
       maxActive="100"   
       maxIdle="30"   
       maxWait="10000" />   
3.配置你的应用下的web.xml中的<web-app></web-app>之间加入:
xml 代码
<resource-ref>   
    <description>DB Connection</description>   
    <res-ref-name>jdbc/mysqlx</res-ref-name>   
    <res-type>javax.sql.DataSource</res-type>   
    <res-auth>Container</res-auth>   
  </resource-ref>   
基本的步骤应该是这个样子，参考一下吧。

Answer 5

警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'debug' to '5' did not find a matching property. 
   不知楼主怎样解决的。  谢谢！