[nio-8080-exec-6] INFO l.AbstractPoolBackedDataSource - Initializing c3p0 pool...报错无法显示数据库中数据-CSDN博客

本文链接：https://blog.csdn.net/qq_51764257/article/details/130477512

文章描述了一个关于Java应用中c3p0数据源初始化时遇到的问题，提到了错误日志，并指出问题可能由EL表达式忽略、数据库凭据错误或jar包版本不兼容导致。解决方案包括在Java页面添加isELIgnored属性设置为false，检查数据库凭证，以及更新不兼容的jar包版本。

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

报错：

2023-05-03 21:21:14,233 22837 [nio-8080-exec-6] INFO l.AbstractPoolBackedDataSource - Initializing c3p0 pool... 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 -> 1hgfdo2av1qn6kon7zd5wi|30b57d2, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgfdo2av1qn6kon7zd5wi|30b57d2, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/sm?characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
[null]

这个找了大概一天，人都找麻了，最终改java文件中加上 isELIgnored=''false'' 就可以了

解决方案：

1，java文件开头需要加 isELIgnored=''false''

<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>

2 ,可能要你密码，或账号错误，改正即可

3，myql数据库jar包版本和c3p0jar包版本不兼容，去官网找jar包更改就ok；