背景资料:
我开发环境:
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)