Last active
December 18, 2015 04:49
-
-
Save Surechun/5727748 to your computer and use it in GitHub Desktop.
Mybatis&c3p0 error msg.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
exception in thread "Timer-0" org.apache.ibatis.exceptions.PersistenceException: | |
### Error querying database. Cause: java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 50, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> c3p0_test, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> intergalactoApp, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge9mc8v8715f23uaf6u|859a68, idleConnectionTestPeriod -> 360, initialPoolSize -> 20, jdbcUrl -> jdbc:mysql://test1.company.com:3306/crawling?useUnicode=true&characterEncoding=UTF8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 7200, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 60, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 5, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {master-of-the-universe={maxStatementsPerConnection=50, maxPoolSize=5, minPoolSize=1, initialPoolSize=1, acquireIncrement=1}, test-user={maxPoolSize=10, maxStatements=0, minPoolSize=1}}, usesTraditionalReflectiveProxies -> false ] has been closed() -- you can no longer use it. | |
### The error may exist in example/spy/core/mapper/ParseLogMapper.xml | |
### The error may involve example.spy.core.mapper.ParseLogMapper.selectByServerNo | |
### The error occurred while executing a query | |
### Cause: java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 50, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> c3p0_test, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> intergalactoApp, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge9mc8v8715f23uaf6u|859a68, idleConnectionTestPeriod -> 360, initialPoolSize -> 20, jdbcUrl -> jdbc:mysql://test1.company.com:3306/crawling?useUnicode=true&characterEncoding=UTF8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 7200, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 60, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 5, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {master-of-the-universe={maxStatementsPerConnection=50, maxPoolSize=5, minPoolSize=1, initialPoolSize=1, acquireIncrement=1}, test-user={maxPoolSize=10, maxStatements=0, minPoolSize=1}}, usesTraditionalReflectiveProxies -> false ] has been closed() -- you can no longer use it. | |
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) | |
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) | |
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) | |
at example.data.common.SessionFactory.selectList(SessionFactory.java:137) | |
at example.spy.core.dao.impl.ParseLogDaoImpl.loadAndDeleteAll(ParseLogDaoImpl.java:50) | |
at example.spy.server.ParseLogWriteServer.loadData(ParseLogWriteServer.java:262) | |
at example.spy.server.ParseLogWriteServer.run(ParseLogWriteServer.java:94) | |
at java.util.TimerThread.mainLoop(Timer.java:512) | |
at java.util.TimerThread.run(Timer.java:462) | |
Caused by: java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 50, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> c3p0_test, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> intergalactoApp, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge9mc8v8715f23uaf6u|859a68, idleConnectionTestPeriod -> 360, initialPoolSize -> 20, jdbcUrl -> jdbc:mysql://test1.company.com:3306/crawling?useUnicode=true&characterEncoding=UTF8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 7200, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 60, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 5, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {master-of-the-universe={maxStatementsPerConnection=50, maxPoolSize=5, minPoolSize=1, initialPoolSize=1, acquireIncrement=1}, test-user={maxPoolSize=10, maxStatements=0, minPoolSize=1}}, usesTraditionalReflectiveProxies -> false ] has been closed() -- you can no longer use it. | |
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.assertCpds(AbstractPoolBackedDataSource.java:507) | |
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:519) | |
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) | |
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:131) | |
at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58) | |
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:271) | |
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69) | |
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56) | |
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259) | |
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132) | |
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105) | |
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81) | |
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) | |
... 7 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment