java.sql.SQLException:不允许操作:流类型不能用于批处理 [英] java.sql.SQLException: operation not allowed: streams type cannot be used in batching

问题描述

我正在尝试使用 CKEditor插入数据流 [ java.sql.SQLException:不允许操作:流类型不能用于批处理

在Google上试了很长时间，但无济于事.您对解决方法有一个精确的想法吗?我的Oracle驱动程序版本为ojdbc14.数据库从base64解码回去.

I''m trying to insert a stream of data using a CKEditor [CKEditor ] in JSP using Spring MVC(3.0.2) and Hibernate 3.2.1 to a Clob type field of Oracle 10g database. It throws the following exception.

java.sql.SQLException: operation not allowed: streams type cannot be used in batching

Tried on Google for a long time but to no avail. Do you have a precise idea about how to solve it? My Oracle driver version is ojdbc14.

解决方案

If you want it work without updating the Oracle driver,change the data from CKEditor to base64 and insert it and similarly while retrieving from database decode back from base64.

这篇关于java.sql.SQLException:不允许操作:流类型不能用于批处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！