Exception:com.mchange.v2.c3p0.impl.NewProxyConnection cannot be cast to oracle.j

yaweidai

Exception:com.mchange.v2.c3p0.impl.NewProxyConnection cannot be cast to oracle.jdbc.OracleConnection
 
解决方法：
方法1：
//将NewProxyConnection转换为OracleConnectionconn = session.getConnection();//从C3p0获取的连接pstm = conn.preparedStatement();//NewProxyConnection转换为OracleConnection C3P0NativeJdbcExtractor cp30NativeJdbcExtractor = new C3P0NativeJdbcExtractor(); OracleConnection connection = (OracleConnection) cp30NativeJdbcExtractor.getNativeConnection(pstm.getConnection()); itemFlow = oracle.sql.CLOB.createTemporary(connection, false, oracle.sql.CLOB.DURATION_SESSION);// itemFlow =  OracleUtils.createTemporaryCLOB(pstm.getConnection(),false,oracle.sql.CLOB.DURATION_CALL); 
方法2：
 
修改配置文件，添加下面的代码：（貌似没作用？？？）
<bean id="nativeJdbcExtractor" lazy-init="true" class="org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor"/><bean id="oracleLobHandler" lazy-init="true" class="org.springframework.jdbc.support.lob.OracleLobHandler"><property name="nativeJdbcExtractor"><ref bean="nativeJdbcExtractor"/></property> </bean><bean id="sessionFactory"class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><property name="lobHandler" ref="oracleLobHandler"/>...</bean> 
 
转至：http://blog.csdn.net/niuhea/article/details/7877287