weblogic项目与数据库经常连不上
项目在本机启动没有问题,最近将项目部署到weblogic上面去了,连的数据库也是在weblogic部署的同一台服务器上面
项目部署上去后,启动正常,显示也能正常使用
但是经常会间歇性出现连不上数据库的情况,就是突然就连不上了。
有时候我用一个用户操作连不上数据库,但是当我用另一个用户登录的时候显示一切正常,完全看不出什么问题。以下是连不上数据库报的日志,麻烦各位帮忙看看,谢谢!
INFO 2017-09-14 00:19:40,663 com.web.base.dynamicds.CustomerContextHolder.setCustomerType(19) ##### using data source : dsSys
INFO 2017-09-14 00:19:40,664 com.web.base.sql.SqlStatement.executeQuery(1145) ##### query start: 1505319580664
INFO 2017-09-14 00:19:40,664 com.web.base.sql.SqlStatement.getQueryString(1010) ##### sql statement : select t1.username uname from t8_sys_date_log t join sys_user t1 on t.inputuser = t1.loginname where t.id = (select max
(id) from t8_sys_date_log) and t.status = '-1' and t.inputuser is not null<2017-9-14 上午12时19分40秒 CST> <Error> <HTTP> <BEA-101017> <[ServletContext@1551582260[app:ast_web module:ast_web.war path:null spec-version:3.0], request: weblogic.servlet.internal.ServletRequestImpl@63cc0e4a[
POST /ast_web/base/comn-query.json HTTP/1.1
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
Accept: application/json, text/javascript, */*; q=0.01
X-Requested-With: XMLHttpRequest
Referer: http://10.0.54.28:7001/ast_web/index.jsp
Accept-Language: zh-CN
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; LCTE; rv:11.0) like Gecko
Content-Length: 38
Connection: Keep-Alive
Cache-Control: no-cache
]] Root cause of ServletException.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireR
etryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 5j5esc9sz8edst14wfx7|166f5ae2, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 5j5esc9sz8edst14wfx7|166f5ae2, idleConnectionTestPeriod -> 7200, initialPoolSize -> 2, jdbcUrl -> jdbc:oracle:thin:@191.241.10.258:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 4, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] has been closed() -- you can no longer use it. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:391)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
at com.kayak.web.base.sql.SqlStatement.executeQuery(SqlStatement.java:1147)
at com.kayak.web.base.dao.ComnDao.sqlQuery(ComnDao.java:613)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLException: com.mchange.v2.c3p0.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 -> 5j5esc9sz8edst14wfx7|166f5ae2, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 5j5esc9sz8edst14wfx7|166f5ae2, idleConnectionTestPeriod -> 7200, initialPoolSize -> 2, jdbcUrl -> jdbc:oracle:thin:@191.241.10.258:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 4, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] has been closed() -- you can no longer use it. at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.assertCpds(AbstractPoolBackedDataSource.java:495)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:507)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:164)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
Truncated. see log file for complete stacktrace
>
INFO 2017-09-14 00:19:40,815 com.web.base.dynamicds.CustomerContextHolder.setCustomerType(19) ##### using data source : dsSys
INFO 2017-09-14 00:19:40,815 com.web.base.dao.ComnDao.exeQuery(185) ##### comn query exeid : M865EQ003, execute sqlid : M865Q003, oracle