快被Tomcat连接Mysql连接池问题弄疯了!
16lz
2021-01-22
有三天了吧!一下停留在这个问题上,几乎看遍了网上所有的文章了,可总有各种各样的错误跑来来。
去参考官方网站,按提示写,还有有错误:
网页上的报错是:
org.apache.jasper.JasperException:AnexceptionoccurredprocessingJSPpage/test.jspatline3
1:<%@tagliburi="http://java.sun.com/jsp/jstl/sql"prefix="sql"%>
2:<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="c"%>
3:<sql:queryvar="rs"dataSource="jdbc/TestDB">
4:selectid,foo,barfromtestdata
5:</sql:query>
6:<html>
================================
我的JSP文件如下,我感觉没有错啊,一个字都没有错的啊
<%@tagliburi="http://java.sun.com/jsp/jstl/sql"prefix="sql"%>
<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="c"%>
<sql:queryvar="rs"dataSource="jdbc/TestDB">
selectid,foo,barfromtestdata
</sql:query>
<html>
<head>
<title>DBTest</title>
</head>
<body>
<h2>Results</h2>
<c:forEachvar="row"items="${rs.rows}">
Foo${row.foo}<br/>
Bar${row.bar}<br/>
</c:forEach>
</body>
</html>
============================
Tomcat中报错如下:
信息:Serverstartupin1082ms
2009-8-2312:08:27org.apache.catalina.core.StandardWrapperValveinvoke
严重:Servlet.service()forservletjspthrewexception
javax.servlet.jsp.JspException:Unabletogetconnection,DataSourceinvalid:"org.apache.tomcat.dbcp.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Serverconnectionfailureduringtransaction.Duetounderlyingexception:'java.net.SocketException:java.net.ConnectException:Connectionrefused:connect'.
**BEGINNESTEDEXCEPTION**
java.net.SocketException
MESSAGE:java.net.ConnectException:Connectionrefused:connect
STACKTRACE:
java.net.SocketException:java.net.ConnectException:Connectionrefused:connect
atcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
atcom.mysql.jdbc.Connection.createNewIO(Connection.java:2815)
atcom.mysql.jdbc.Connection.<init>(Connection.java:1531)
atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
atorg.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
atorg.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:274)
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
atorg.apache.jsp.test_jsp._jspx_meth_sql_005fquery_005f0(test_jsp.java:103)
atorg.apache.jsp.test_jsp._jspService(test_jsp.java:62)
atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
atorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
atjava.lang.Thread.run(UnknownSource)
**ENDNESTEDEXCEPTION**
Attemptedreconnect3times.Givingup.)"
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
atorg.apache.jsp.test_jsp._jspx_meth_sql_005fquery_005f0(test_jsp.java:103)
atorg.apache.jsp.test_jsp._jspService(test_jsp.java:62)
atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
atorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
atjava.lang.Thread.run(UnknownSource)
2009-8-2312:08:34org.apache.catalina.core.StandardWrapperValveinvoke
严重:Servlet.service()forservletjspthrewexception
javax.servlet.jsp.JspException:Unabletogetconnection,DataSourceinvalid:"org.apache.tomcat.dbcp.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Serverconnectionfailureduringtransaction.Duetounderlyingexception:'java.net.SocketException:java.net.ConnectException:Connectionrefused:connect'.
============================
如果您解决了这个问题,您是否有空去看看,能不能顺便看一下我发的另一个问题,关于编码不一致的问题:http://topic.csdn.net/u/20090822/17/3eba5680-bdc6-4b59-9409-de782f170523.html?seed=1973859369&r=59270155#r_59270155
我的web.xml如下:
%tomcat%/conf/context.xml如下:
去参考官方网站,按提示写,还有有错误:
网页上的报错是:
org.apache.jasper.JasperException:AnexceptionoccurredprocessingJSPpage/test.jspatline3
1:<%@tagliburi="http://java.sun.com/jsp/jstl/sql"prefix="sql"%>
2:<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="c"%>
3:<sql:queryvar="rs"dataSource="jdbc/TestDB">
4:selectid,foo,barfromtestdata
5:</sql:query>
6:<html>
================================
我的JSP文件如下,我感觉没有错啊,一个字都没有错的啊
<%@tagliburi="http://java.sun.com/jsp/jstl/sql"prefix="sql"%>
<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="c"%>
<sql:queryvar="rs"dataSource="jdbc/TestDB">
selectid,foo,barfromtestdata
</sql:query>
<html>
<head>
<title>DBTest</title>
</head>
<body>
<h2>Results</h2>
<c:forEachvar="row"items="${rs.rows}">
Foo${row.foo}<br/>
Bar${row.bar}<br/>
</c:forEach>
</body>
</html>
============================
Tomcat中报错如下:
信息:Serverstartupin1082ms
2009-8-2312:08:27org.apache.catalina.core.StandardWrapperValveinvoke
严重:Servlet.service()forservletjspthrewexception
javax.servlet.jsp.JspException:Unabletogetconnection,DataSourceinvalid:"org.apache.tomcat.dbcp.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Serverconnectionfailureduringtransaction.Duetounderlyingexception:'java.net.SocketException:java.net.ConnectException:Connectionrefused:connect'.
**BEGINNESTEDEXCEPTION**
java.net.SocketException
MESSAGE:java.net.ConnectException:Connectionrefused:connect
STACKTRACE:
java.net.SocketException:java.net.ConnectException:Connectionrefused:connect
atcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
atcom.mysql.jdbc.Connection.createNewIO(Connection.java:2815)
atcom.mysql.jdbc.Connection.<init>(Connection.java:1531)
atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
atorg.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
atorg.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:274)
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
atorg.apache.jsp.test_jsp._jspx_meth_sql_005fquery_005f0(test_jsp.java:103)
atorg.apache.jsp.test_jsp._jspService(test_jsp.java:62)
atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
atorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
atjava.lang.Thread.run(UnknownSource)
**ENDNESTEDEXCEPTION**
Attemptedreconnect3times.Givingup.)"
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
atorg.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
atorg.apache.jsp.test_jsp._jspx_meth_sql_005fquery_005f0(test_jsp.java:103)
atorg.apache.jsp.test_jsp._jspService(test_jsp.java:62)
atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
atorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
atjava.lang.Thread.run(UnknownSource)
2009-8-2312:08:34org.apache.catalina.core.StandardWrapperValveinvoke
严重:Servlet.service()forservletjspthrewexception
javax.servlet.jsp.JspException:Unabletogetconnection,DataSourceinvalid:"org.apache.tomcat.dbcp.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(Serverconnectionfailureduringtransaction.Duetounderlyingexception:'java.net.SocketException:java.net.ConnectException:Connectionrefused:connect'.
============================
如果您解决了这个问题,您是否有空去看看,能不能顺便看一下我发的另一个问题,关于编码不一致的问题:http://topic.csdn.net/u/20090822/17/3eba5680-bdc6-4b59-9409-de782f170523.html?seed=1973859369&r=59270155#r_59270155
20 个解决方案
#1
我的web.xml如下:
<web-appxmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<description>MySQLTestApp</description>
<resource-ref>
<description>DBConnection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
%tomcat%/conf/context.xml如下:
<?xmlversion='1.0'encoding='utf-8'?>
<!--
LicensedtotheApacheSoftwareFoundation(ASF)underoneormore
contributorlicenseagreements.SeetheNOTICEfiledistributedwith
thisworkforadditionalinformationregardingcopyrightownership.
TheASFlicensesthisfiletoYouundertheApacheLicense,Version2.0
(the"License");youmaynotusethisfileexceptincompliancewith
theLicense.YoumayobtainacopyoftheLicenseat
http://www.apache.org/licenses/LICENSE-2.0
Unlessrequiredbyapplicablelaworagreedtoinwriting,software
distributedundertheLicenseisdistributedonan"ASIS"BASIS,
WITHOUTWARRANTIESORCONDITIONSOFANYKIND,eitherexpressorimplied.
SeetheLicenseforthespecificlanguagegoverningpermissionsand
limitationsundertheLicense.
-->
<!--Thecontentsofthisfilewillbeloadedforeachwebapplication-->
<Contextpath="/DBTest"docBase="D:\myeclipse_workspace\DBTest\WebRoot"
debug="5"reloadable="true"crossContext="true">
<Resourcename="jdbc/TestDB"auth="Container"type="javax.sql.DataSource"
maxActive="100"maxIdle="30"maxWait="10000"
username="javauser"password="javadude"driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"/>
</Context>
更多相关文章
- AppScan安全问题解决方案
- PLSQL乱码解决方案
- 数据库不支持中文解决方案(mysql)
- Mysql替代解决方案Cassandra
- [置顶] Android屏幕适配解决方案
- 物流货运移动APP解决方案
- 转:Android Studio Error:Connection timed out: connect.解决方
- android.os.NetworkOnMainThreadException的解决方案
- Android极光推送jPush混淆解决方案终极篇