高手帮忙啊!关于eclispse 发布网站的问题
背景资料:
我开发环境:
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
请问高手,我哪里错了啊。怎么去解决!
[解决办法]
连接池错误
[解决办法]
在 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本身就有,何必花这样的力气来研究这个呢
[解决办法]
汗楼上的。。。
[解决办法]
连接池的错误,你还是仔细看一下人的连接池~~~不是连接池就是你连接数据库的错!