导航：首页 > 互联网科技 >

如何解决因数据库用户被锁tomcat报错的c3p0 pool问题

发表于：2024-09-22 作者：千家信息网编辑

千家信息网最后更新 2024年09月22日，如何解决因数据库用户被锁tomcat报错的c3p0 pool问题，针对这个问题，这篇文章详细介绍了相对应的分析和解答，希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。C:\Program

千家信息网最后更新 2024年09月22日如何解决因数据库用户被锁tomcat报错的c3p0 pool问题

如何解决因数据库用户被锁tomcat报错的c3p0 pool问题，针对这个问题，这篇文章详细介绍了相对应的分析和解答，希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。

C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Users\comsys\AppData\Local\Microsoft\WindowsApps;;.
java.specification.name=Java Platform API Specification
java.class.version=50.0
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
os.version=6.2
org.apache.catalina.startup.ContextConfig.jarsToSkip=
user.home=C:\Users\comsys
catalina.useNaming=true
user.timezone=Asia/Shanghai
java.awt.printerjob=sun.awt.windows.WPrinterJob
file.encoding=GBK
java.specification.version=1.6
catalina.home=D:\view\SDCenter_v4.0(R)_20151009\SDCenter4.0
java.class.path=D:\view\SDCenter_v4.0(R)_20151009\SDCenter4.0\bin\bootstrap.jar;D:\view\SDCenter_v4.0(R)_20151009\SDCenter4.0\bin\tomcat-juli.jar
user.name=comsys
java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory
package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
java.vm.specification.version=1.0
sun.java.command=org.apache.catalina.startup.Bootstrap start
java.home=C:\Program Files\Java\jre6
sun.arch.data.model=64
user.language=zh
java.specification.vendor=Sun Microsystems Inc.
awt.toolkit=sun.awt.windows.WToolkit
java.vm.info=mixed mode
java.version=1.6.0_45
java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext
sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\lib\modules\jdk.boot.jar;C:\Program Files\Java\jre6\classes
server.loader=
java.vendor=Sun Microsystems Inc.
catalina.base=D:\view\SDCenter_v4.0(R)_20151009\SDCenter4.0
file.separator=\
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar
sun.io.unicode.encoding=UnicodeLittle
sun.cpu.endian=little
package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
sun.desktop=windows
sun.cpu.isalist=amd64}
WARN [Thread-3] [org.apache.commons.httpclient.HttpMethodBase] (HttpMethodBase.java:682) - Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
INFO [localhost-startStop-1] [com.mchange.v2.log.MLog] (MLog.java:80) - MLog clients using log4j logging.
INFO [localhost-startStop-1] [com.mchange.v2.c3p0.C3P0Registry] (C3P0Registry.java:204) - Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
INFO [localhost-startStop-1] [com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource] (AbstractPoolBackedDataSource.java:462) - 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 -> 1hge2cu9o1tsl8ijbmx9tf|5fb271f1, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge2cu9o1tsl8ijbmx9tf|5fb271f1, idleConnectionTestPeriod -> 60, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@127.0.0.1:1521:ORCL, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, 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 ]

问题原因：
由于tomcat连接oracle数据库，用户被锁定，导致报错。

解决方法：
进入oracle数据库，将用户解锁
alter user user_name account unlock;
重启tomcat后，恢复正常