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

最新推荐文章于 2023-12-11 08:59:42 发布

arlendai

最新推荐文章于 2023-12-11 08:59:42 发布

阅读量614

点赞数

分类专栏： Oracle 文章标签： oracle NewProxyConnection

本文链接：https://blog.csdn.net/arlendai/article/details/84323253

版权

Oracle 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

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