ITPub博客

首页 > 应用开发 > IT综合 > 因数据库用户被锁,tomcat报错,c3p0 pool问题

因数据库用户被锁,tomcat报错,c3p0 pool问题

原创 IT综合 作者:sunyi_672 时间:2017-06-28 13:25:52 0 删除 编辑
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后,恢复正常



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26600495/viewspace-2141336/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-12-29

  • 博文量
    51
  • 访问量
    46987