有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

带有c3p0池的JavaSpring应用程序生成java。lang.SQLException:某些资源在关闭时无法正确关闭

我们使用spring和c3p0作为数据库池,我们使用Oracle10g作为数据库。 当我们启动应用程序时,它会继续显示以下错误

 2012-5-7 13:12:43 com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask run
 Warning: Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@20af46
 java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@20af46
  2012-5-7 14:45:51 com.mchange.v2.c3p0.impl.NewPooledConnection logCloseExceptions
  Info: [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
  2012-5-7 14:45:51 com.mchange.v2.c3p0.impl.NewPooledConnection logCloseExceptions
  Info: [c3p0] NewPooledConnection close Exception.
  java.sql.SQLException: More data can not be read from the socket
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1123)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1075)
    at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:106)
    at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:465)
    at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1203)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java
    at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

 In oracle trace file,we found the following error
  *** 2012-05-07 11:50:56.421
   ksedmp: internal or fatal error  
   ORA-07445: An unexpected error: core dump [ACCESS_VIOLATION] [_evaopn2+153] [PC:0x1BBDFA9] [ADDR:0x0] [UNABLE_TO_READ] []
   Current SQL statement for this session:

是oracle错误导致上述原因。我们花了很多时间去发现问题,但是我们没有发现问题。在我们使用oracle 9i之前,它没有问题。最近我们升级到oracle 10g。问题出在哪里?任何想法都会很有帮助。谢谢 我们使用的c3p0是com。springsource。通用域名格式。麦克亨格。v2。c3p0-0.9.1.2。罐子


共 (0) 个答案