c3p0 不能连接到oracle数据库

海_狼 2015-01-19 10:59:48 


2015-01-19 10:52:48,820 [org.hibernate.connection.ConnectionProviderFactory]-[INFO] Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider

2015-01-19 10:52:49,030 [com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource]-[INFO] 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 -> z8kfsx9712f7qeicel0|2ac02d83, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx9712f7qeicel0|2ac02d83, idleConnectionTestPeriod -> 900, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@192.168.20.25:1521:orcl, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 10, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0" java.lang.LinkageError: loader constraint violation: loader (instance of org/apache/catalina/loader/WebappClassLoader) previously initiated loading for a different type with name "oracle/sql/converter/CharacterConverters"

	at java.lang.ClassLoader.defineClass1(Native Method)

	at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)

	at java.lang.ClassLoader.defineClass(ClassLoader.java:615)

	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)

	at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2331)

	at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:976)

	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1451)

	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)

	at oracle.sql.CharacterSet1Byte.getInstance(CharacterSet1Byte.java:86)

	at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:103)

	at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)

	at oracle.sql.CharacterSet.make(CharacterSet.java:440)

	at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:145)

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

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

	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

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

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

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

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

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

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

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

	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

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

Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#9" java.lang.LinkageError: oracle/sql/converter/CharacterConverters

	at oracle.sql.CharacterSet1Byte.getInstance(CharacterSet1Byte.java:86)

	at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:103)

	at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)

	at oracle.sql.CharacterSet.make(CharacterSet.java:440)

	at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:145)

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

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

	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

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

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

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

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

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

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

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

	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

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

Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#8" java.lang.LinkageError: oracle/sql/converter/CharacterConverters

	at oracle.sql.CharacterSet1Byte.getInstance(CharacterSet1Byte.java:86)

	at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:103)

	at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)

	at oracle.sql.CharacterSet.make(CharacterSet.java:440)

	at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:145)

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

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

	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

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

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

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

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

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

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

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

	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

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

各位大神，帮我看看这是什么原因导致的，谢了！
...全文
384 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_36987278 2017-06-30
  • 打赏
  • 举报
 回复
你好，能把你用到的jar包和代码发一下看看吗？我写的一个也是c3p0连接oracle总是报错，不是不识别sid-name就是缺ocijdbc11,实在找不出办法了，458101369谢谢帮帮忙呗
海_狼 2015-01-20
  • 打赏
  • 举报
 回复
引用 3 楼 wangxf_8341 的回复:
是jar包冲突了，Ctrl+shift+t，看看你的项目依赖里面有几个包含oracle.sql.converter.CharacterConverters这个类的jar，具体哪个jar该去掉，目前这个报错信息并不明显，只有一个个的排除，
确实是jar包冲突了，我删了个jar包就好了。
黄金神衣 2015-01-19
  • 打赏
  • 举报
 回复
没碰到过这种错误，检查下自己的配置
文哥xxx 2015-01-19
  • 打赏
  • 举报
 回复
我觉得 还是 从 name " oracle/sql/converter/CharacterConverters" 这方面入手
淡定的峰哥 2015-01-19
  • 打赏
  • 举报
 回复
是jar包冲突了，Ctrl+shift+t，看看你的项目依赖里面有几个包含oracle.sql.converter.CharacterConverters这个类的jar，具体哪个jar该去掉，目前这个报错信息并不明显，只有一个个的排除，
lsongiu86 2015-01-19
  • 打赏
  • 举报
 回复
可能是引用jar冲突了，http://winters1224.blog.51cto.com/3021203/797789
c3p0 连接oracle数据库必备jar包.rar
c3p0 连接池 连接oracle数据库必备jar包
hibernate C3P0数据源 连接oracle数据库
博文链接：https://wxinpeng.iteye.com/blog/203110
C3p0、Oracle数据库连接驱动、MySQL数据库连接驱动jar包.rar
C3p0、Oracle数据库连接驱动、MySQL数据库连接驱动jar包.rar
c3p0数据库连接池案例
c3p0数据库连接池案例,java项目，例子结构清晰，适合新手学习
c3p0数据库连接池所需jar包
这里有关于吃c3p0数据库连接池所需要的jar包。。。。。。。。。。。。
Web 开发

81,092

社区成员

341,718

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章