Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: Java
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 8:46am
Edited 29-Aug-12 8: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
0 Maciej Los 495
1 Sergey Alexandrovich Kryukov 419
2 OriginalGriff 360
3 CHill60 310
4 CPallini 275
0 Sergey Alexandrovich Kryukov 10,017
1 OriginalGriff 9,495
2 Peter Leow 5,241
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 3,076

Advertise | Privacy | Mobile
Web03 | 2.8.150327.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2015
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