Click here to Skip to main content
13,004,625 members (72,004 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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.
Posted 29-Aug-12 7:46am
Updated 29-Aug-12 7:50am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170627.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100