背景资料:
  我开发环境:
    Tomcat 5.5.
    Mysql 4.1 
    Java语言 JDK1.4.2
    数据池:proxool-0.8.3.jar
    数据库驱动mysql-connector-java-3.1.12-bin.jar
  我是用ECLIPSE WTP做的项目        e:\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\myjspweb
  我在互联网上申请了域名和空间。
  服务器环境:
    freebsd:
    Tomcat 5.5.
    Mysql 4.1, 
    Java语言 JDK1.5
问题:
   我现在把myjspweb 下面的资料上传到服务器(web)上去。包括(jsp,WEB-INFO).同时  ,也上传了数据库。当然相应的设置也改了。
以前在我这里的开发环境是 http://localhost:8090/myjspweb/
  但是我现在要实现 http://www.myweb.com/ 
  proxool.properties:jdbc-0.proxool.alias=tombdb
jdbc-0.proxool.driver-url=jdbc:mysql://localhost:3306/tomb?useUnicode=true&characterEncoding=GB2312&zeroDateTimeBehavior=convertToNull
jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-0.user=www
jdbc-0.password=1123222
jdbc-0.proxool.maximum-connection-count=50
jdbc-0.proxool.minimum-connection-count=10
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.verbose=true
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.statistcs=10s,1m,1d
jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE   我现在一运行网页程序就报:
   javax.servlet.ServletException: java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered pool by its alias 'tombdb'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.archive.archiveNews_jsp._jspService(org.apache.jsp.archive.archiveNews_jsp:425)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
tomb.kernal.comm.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:33)
root cause com.szdev.database.dao.DAOException: java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered pool by its alias 'tombdb'
tomb.kernal.comm.dao.CommonDAO.getDBFiledValue(CommonDAO.java:119)
org.apache.jsp.archive.archiveNews_jsp._jspService(org.apache.jsp.archive.archiveNews_jsp:76)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
tomb.kernal.comm.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:33
请问高手,我哪里错了啊。怎么去解决!
       

解决方案 »

  1.   

    在 web.xml 加上 <servlet>
       <servlet-name>ServletConfigurator</servlet-name>
       <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
       <init-param>
      <param-name>xmlFile</param-name>
      <param-value>WEB-INF/classes/proxool.xml</param-value>
       </init-param>
       <load-on-startup>0</load-on-startup>
     </servlet>  就可以解决
    顺便说一句,现在的WEB容器都有自己的连接池,TOMCAT本身就有,何必花这样的力气来研究这个呢
      

  2.   

    在我的电脑上都运行正常啊。数据池注册和调用是正常的。我的系统是windows,上传的系统是freebsd.我想也不应该有区别把?