Tomcat 5.5配置连接池

Question

错误信息为：
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Cannot create resource instance
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause javax.servlet.ServletException: Cannot create resource instance
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.databasetext_jsp._jspService(databasetext_jsp.java:140)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause javax.naming.NamingException: Cannot create resource instance
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:143)
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
org.apache.naming.NamingContext.lookup(NamingContext.java:793)
org.apache.naming.NamingContext.lookup(NamingContext.java:140)
org.apache.naming.NamingContext.lookup(NamingContext.java:781)
org.apache.naming.NamingContext.lookup(NamingContext.java:140)
org.apache.naming.NamingContext.lookup(NamingContext.java:781)
org.apache.naming.NamingContext.lookup(NamingContext.java:140)
org.apache.naming.NamingContext.lookup(NamingContext.java:781)
org.apache.naming.NamingContext.lookup(NamingContext.java:153)
org.apache.naming.SelectorContext.lookup(SelectorContext.java:137)
javax.naming.InitialContext.lookup(InitialContext.java:392)
org.apache.jsp.databasetext_jsp._jspService(databasetext_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.

Answer 1

Tomcat的管理界面中设置了名字为jdbc/bn  
webapps/ROOT/WEB-INF下web.xml，加入如下内容：   
<resource-ref>
  <description>SqlServer Datasource example</description>
  <res-ref-name>jdbc/bn</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
  </resource-ref>msbase.jar,mssqlserver.jar,msutil.jar 都放在tomcat/common/lib下server.xml代码如下:
<?xml version="1.0" encoding="UTF-8"?>
<Server>
  <Listener className="org.apache.catalina.core.AprLifecycleListener"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
  <Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
  <GlobalNamingResources>
  <Environment
  name="simpleValue"
  type="java.lang.Integer"
  value="30"/>
  <Resource
  name="jdbc/bn"
  type="javax.sql.DataSource"
  maxActive="4"
  maxIdle="2"
  username="wang"
  maxWait="5000"
  driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
  password="123"
  url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myDB"/>
  <Resource
  auth="Container"
  description="User database that can be updated and saved"
  name="UserDatabase"
  type="org.apache.catalina.UserDatabase"
  factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
  pathname="conf/tomcat-users.xml"/>
  </GlobalNamingResources>
  <Service
  name="Catalina">
  <Connector
  port="1234"
  redirectPort="8443"
  minSpareThreads="25"
  connectionTimeout="20000"
  maxThreads="150"
  maxSpareThreads="75">
  </Connector>
  <Connector
  port="8009"
  redirectPort="8443"
  protocol="AJP/1.3">
  </Connector>
  <Engine
  defaultHost="localhost"
  name="Catalina">
  <Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
  <Host
  name="localhost">
  </Host>
  </Engine>
  </Service>
</Server>请各位高手帮忙看看，还有哪里需要配置的，新手请指导，非常感谢