oracle all resouce,求大神解答,oracle连接提示com.mchange.v2.resourcepool.BasicResourcePool??

最新推荐文章于 2022-09-12 11:43:54 发布

weixin_39600616

最新推荐文章于 2022-09-12 11:43:54 发布

阅读量901

点赞数

文章标签： Maven Tomcat Oracle数据库连接失败 c3p0

以下是控制台打印的信息

[INFO] Scanning for projects...

[INFO] ------------------------------------------------------------------------

[INFO] Reactor Build Order:

[INFO]

[INFO] bos_main

[INFO] bos_utils

[INFO] bos_domain

[INFO] bos_dao

[INFO] bos_biz

[INFO] bos_management

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building bos_main 0.0.1-SNAPSHOT

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) > process-classes @ bos_main >>>

[INFO]

[INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) < process-classes @ bos_main <<<

[INFO]

[INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bos_main ---

[INFO] Skipping non-war project

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building bos_utils 0.0.1-SNAPSHOT

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) > process-classes @ bos_utils >>>

[INFO]

[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ bos_utils ---

[WARNING] Using platform encoding (GBK actually) to copy filtered resources, i.e. build is platform dependent!

[INFO] Copying 0 resource

[INFO]

[INFO] --- maven-compiler-plugin:3.2:compile (default-compile) @ bos_utils ---

[INFO] Nothing to compile - all classes are up to date

[INFO]

[INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) < process-classes @ bos_utils <<<

[INFO]

[INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bos_utils ---

[INFO] Skipping non-war project

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building bos_domain 0.0.1-SNAPSHOT

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) > process-classes @ bos_domain >>>

[INFO]

[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ bos_domain ---

[WARNING] Using platform encoding (GBK actually) to copy filtered resources, i.e. build is platform dependent!

[INFO] Copying 0 resource

[INFO]

[INFO] --- maven-compiler-plugin:3.2:compile (default-compile) @ bos_domain ---

[INFO] Nothing to compile - all classes are up to date

[INFO]

[INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) < process-classes @ bos_domain <<<

[INFO]

[INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bos_domain ---

[INFO] Skipping non-war project

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building bos_dao 0.0.1-SNAPSHOT

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) > process-classes @ bos_dao >>>

[INFO]

[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ bos_dao ---

[WARNING] Using platform encoding (GBK actually) to copy filtered resources, i.e. build is platform dependent!

[INFO] Copying 0 resource

[INFO]

[INFO] --- maven-compiler-plugin:3.2:compile (default-compile) @ bos_dao ---

[INFO] Nothing to compile - all classes are up to date

[INFO]

[INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) < process-classes @ bos_dao <<<

[INFO]

[INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bos_dao ---

[INFO] Skipping non-war project

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building bos_biz 0.0.1-SNAPSHOT

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) > process-classes @ bos_biz >>>

[INFO]

[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ bos_biz ---

[WARNING] Using platform encoding (GBK actually) to copy filtered resources, i.e. build is platform dependent!

[INFO] Copying 0 resource

[INFO]

[INFO] --- maven-compiler-plugin:3.2:compile (default-compile) @ bos_biz ---

[INFO] Nothing to compile - all classes are up to date

[INFO]

[INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) < process-classes @ bos_biz <<<

[INFO]

[INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bos_biz ---

[INFO] Skipping non-war project

[INFO]

[INFO] ------------------------------------------------------------------------

[INFO] Building bos_management 0.0.1-SNAPSHOT

[INFO] ------------------------------------------------------------------------

[INFO]

[INFO] >>> tomcat7-maven-plugin:2.1:run (default-cli) > process-classes @ bos_management >>>

[INFO]

[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ bos_management ---

[WARNING] Using platform encoding (GBK actually) to copy filtered resources, i.e. build is platform dependent!

[INFO] Copying 5 resources

[INFO]

[INFO] --- maven-compiler-plugin:3.2:compile (default-compile) @ bos_management ---

[INFO] Nothing to compile - all classes are up to date

[INFO]

[INFO] <<< tomcat7-maven-plugin:2.1:run (default-cli) < process-classes @ bos_management <<<

[INFO]

[INFO] --- tomcat7-maven-plugin:2.1:run (default-cli) @ bos_management ---

[INFO] Running war on http://localhost:9080/bos_management

[INFO] Using existing Tomcat server configuration at D:\就业班\工作空间\BOS物流系统\bos_main\bos_management\target\tomcat

[INFO] create webapp with contextPath: /bos_management

五月 13, 2017 9:41:04 下午 org.apache.coyote.AbstractProtocol init

信息: Initializing ProtocolHandler ["http-bio-9080"]

五月 13, 2017 9:41:04 下午 org.apache.catalina.core.StandardService startInternal

信息: Starting service Tomcat

五月 13, 2017 9:41:04 下午 org.apache.catalina.core.StandardEngine startInternal

信息: Starting Servlet Engine: Apache Tomcat/7.0.37

五月 13, 2017 9:41:15 下午 org.apache.catalina.core.ApplicationContext log

信息: No Spring WebApplicationInitializer types detected on classpath

五月 13, 2017 9:41:15 下午 org.apache.catalina.core.ApplicationContext log

信息: Initializing Spring root WebApplicationContext

21:41:15,572 INFO ContextLoader:307 - Root WebApplicationContext: initialization started

21:41:15,816 INFO XmlWebApplicationContext:573 - Refreshing Root WebApplicationContext: startup date [Sat May 13 21:41:15 CST 2017]; root of context hierarchy

21:41:15,939 INFO XmlBeanDefinitionReader:317 - Loading XML bean definitions from class path resource [applicationContext.xml]

21:41:16,889 INFO PropertySourcesPlaceholderConfigurer:172 - Loading properties file from class path resource [db.properties]

21:41:16,906 INFO AutowiredAnnotationBeanPostProcessor:153 - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation (NOP) logger implementation

SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

MLog initialization issue: slf4j found no binding or threatened to use its (dangerously silent) NOPLogger. We consider the slf4j library not found.

21:41:17,150 INFO MLog:124 - MLog clients using log4j logging.

21:41:17,303 INFO C3P0Registry:248 - Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]

21:41:18,338 INFO Version:37 - HHH000412: Hibernate Core {5.0.1.Final}

21:41:18,346 INFO Environment:213 - HHH000206: hibernate.properties not found

21:41:18,353 INFO Environment:317 - HHH000021: Bytecode provider name : javassist

21:41:18,505 INFO Version:66 - HCANN000001: Hibernate Commons Annotations {5.0.0.Final}

21:41:18,979 INFO AbstractPoolBackedDataSource:527 - 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, contextClassLoaderSource -> caller, dataSourceName -> 1hgem0x9oke9uf1hnqg2b|2b5c3ebe, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgem0x9oke9uf1hnqg2b|2b5c3ebe, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@localhost:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]

21:41:49,486 WARN BasicResourcePool:1911 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@42f79c38 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

java.sql.SQLException: Undefined Error

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)

at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)

at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)

at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)

at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)

at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

Caused by: oracle.net.ns.NetException: Undefined Error

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)

... 13 more

21:41:49,584 WARN BasicResourcePool:1911 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@55fcf5c9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: