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

　　Exception:com.mchange.v2.c3p0.impl.NewProxyConnection cannot be cast to oracle.jdbc.OracleConnection
　　
　　解决方法：
　　方法1：

//将NewProxyConnection转换为OracleConnection
conn = 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