c3p0配置问题

我用了c3p0做连接池,可是最近总出一个问题,过一段时间不用后在浏览器中访问就会抛出无法获得连接的异常,然后多次重复在浏览器中访问后又会恢复正常,我是第一次使用c3p0连接池,不知道问题出在哪里,请大虾们指点一下。我的控制台中打出来的c3p0配置如下:

[AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c
3p0.ComboPooledDataSource
[
acquireIncrement -> 3,
acquireRetryAttempts -> 30,
acquireRetryDelay -> 1000,
autoCommitOnClose -> false,
automaticTestTable -> null,
breakAfterAcquireFailure -> false,
checkoutTimeout -> 0,
connectionCustomizerClassName -> null,
connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester,
dataSourceName -> ghk5dy81dymcimihlxep|10811b5,
debugUnreturnedConnectionStackTraces -> false,
description -> null, driverClass -> oracle.jdbc.driver.OracleDriver,
factoryClassLocation -> null,
forceIgnoreUnresolvedTransactions -> false,
identityToken -> ghk5dy81dymcimihlxep|10811b5,
idleConnectionTestPeriod -> 0,
initialPoolSize -> 2,
jdbcUrl -> jdbc:oracle:thin:@59.108.73.68:5525:test00,
lastAcquisitionFailureDefaultUser -> null,
maxAdministrativeTaskTime -> 0,
maxConnectionAge -> 0,
maxIdleTime -> 0,
maxIdleTimeExcessConnections -> 0,
maxPoolSize -> 15,
maxStatements -> 0,
maxStatementsPerConnection -> 0,
minPoolSize -> 3,
numHelperThreads -> 3,
numThreadsAwaitingCheckoutDefaultUser -> 0,
preferredTestQuery -> SELECT 1 FROM dual,
properties -> {user=******, password=******},
propertyCycle -> 0,
testConnectionOnCheckin -> true,
testConnectionOnCheckout -> false,
unreturnedConnectionTimeout -> 0,
usesTraditionalReflectiveProxies -> false
]


出现的异常是这样的:
10:34:43,274 INFO [STDOUT] 获得oracle数据库连接出错!
10:34:43,274 ERROR [STDERR] java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
10:34:43,274 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
10:34:43,274 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
10:34:43,274 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
10:34:43,274 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
10:34:43,274 ERROR [STDERR] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
10:34:43,290 ERROR [STDERR] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
10:34:43,290 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:582)
10:34:43,290 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:185)
10:34:43,305 ERROR [STDERR] at com.cltc.jdbc.JdbcConnector.getConnection(JdbcConnector.java:27)
10:34:43,305 ERROR [STDERR] at com.cltc.hotct.chn.Channel.getChnnel(Channel.java:36)
10:34:43,305 ERROR [STDERR] at org.apache.jsp.index_jsp._jspService(index_jsp.java:63)
10:34:43,321 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
10:34:43,321 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
10:34:43,321 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
10:34:43,336 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
10:34:43,336 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
10:34:43,336 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
10:34:43,352 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
10:34:43,352 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
10:34:43,352 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
10:34:43,368 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
10:34:43,368 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
10:34:43,368 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
10:34:43,383 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
10:34:43,383 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
10:34:43,383 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
10:34:43,399 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
10:34:43,399 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
10:34:43,399 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
10:34:43,415 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
10:34:43,415 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
10:34:43,430 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
10:34:43,430 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
10:34:43,430 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
10:34:43,446 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
10:34:43,461 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
但是检查了我的用户名密码都没问题,而且我认为如果真是用户名密码的错误的话,再连几次后也应该连不上才对,可是多连几次后又连接上去了,很是疑惑,我认为应该是我的c3p0配置出了问题,可是我又不知道是哪里的错
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值