c3p0初始化mysql卡住_c3p0 pool初始化不动了，用navicat是能连上数据库的，help在线等...

最新推荐文章于 2021-08-14 13:05:07 发布

甄公子

最新推荐文章于 2021-08-14 13:05:07 发布

阅读量330

点赞数

文章标签： c3p0初始化mysql卡住

本文链接：https://blog.csdn.net/weixin_35592186/article/details/113941161

版权

在启动Web应用程序时遇到c3p0连接池初始化卡住的问题，尽管使用Navicat可以正常连接数据库。初始化过程中加载了多个XML配置文件，并尝试预实例化单例bean。c3p0日志显示正在初始化连接池，但似乎停滞不前。可能的原因包括配置错误、数据库连接问题或资源超时。解决方案可能涉及检查数据库连接参数、c3p0配置和网络状况。

摘要由CSDN通过智能技术生成

该楼层疑似违规已被系统折叠隐藏此楼查看此楼

Root WebApplicationContext: initialization started

- Refreshing Root WebApplicationContext: startup date [Mon Aug 31 22:18:16 CST 2015]; root of context hierarchy

- Loading XML bean definitions from ServletContext resource [/WEB-INF/classes/applicationContext.xml]

- Loading XML bean definitions from ServletContext resource [/WEB-INF/classes/spring/mysql-spring-service.xml]

- Loading XML bean definitions from ServletContext resource [/WEB-INF/classes/spring/mysql-spring-service1.xml]

- Loading XML bean definitions from ServletContext resource [/WEB-INF/classes/spring/mysql-spring-service2.xml]

- Loading XML bean definitions from ServletContext resource [/WEB-INF/classes/task/applicationContext_task.xml]

- Loading properties file from class path resource [database.properties]

- Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3aee2e79: defining beans [propertyConfigurer,dataSourcemysql,transactionManagermysql,sqlSessionFactory,mysqlbaseTransactionProxy,autoProxyCreator,discusBlackUserMapper,discusBlackUserMapperImpl,discusBlackUserService,discusForbidMapper,discusForbidMapperImpl,discusForbidService,discusRecordMapper,discusRecordMapperImpl,discusRecordService,discusExplainationMapper,discusExplainationMapperImpl,discusExplainationService,jdpFxTradeMapper,jdpFxTradeMapperImpl,jdpFxTradeService,org.springframework.scheduling.quartz.SchedulerFactoryBean#0]; root of factory hierarchy

- MLog clients using log4j logging.

- Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10]

- Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge1449b10nqk16eygl5m|5a16aeb6, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge1449b10nqk16eygl5m|5a16aeb6, idleConnectionTestPeriod -> 20, initialPoolSize -> 2, jdbcUrl -> jdbc:mysql://192.168.1.200/srv, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 20, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]