C3P0 Oracle clob 报错请教

Question

C3P0ProxyConnection castCon = (C3P0ProxyConnection) DBManager.getConnection(); 
Method m = CLOB.class.getMethod("createTemporary", 
          new Class[]{Connection.class, boolean.class, int.class}); 
Object[] args = new Object[] {C3P0ProxyConnection.RAW_CONNECTION, 
          Boolean.valueOf( true ), 
          new Integer( 10 )}; 
CLOB oracleCLOB = (CLOB) castCon.rawConnectionOperation(m, null, args); 
System.out.println(oracleCLOB);

 

以上是官方提供的代码，但总是报错。。。不知道有什么办法解决

 

Caused by: java.lang.ClassCastException: com.mchange.v2.c3p0.impl.NewProxyConnection cannot be cast to oracle.jdbc.OracleConnection
 at oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.java:5174)
 at oracle.sql.CLOB.createTemporary(CLOB.java:1009)
 at oracle.sql.CLOB.createTemporary(CLOB.java:956)

Answer 1

Oracle 连接池经常会碰到这个问题，建议更新到最新的驱动程序包试试