Click here to Skip to main content
Rate this: bad
good
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
v3

1 solution

Rate this: bad
good
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.
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 450
1 OriginalGriff 230
2 DamithSL 150
3 Dave Kreskowiak 120
4 Suvendu Shekhar Giri 110
0 OriginalGriff 7,740
1 DamithSL 5,644
2 Sergey Alexandrovich Kryukov 5,404
3 Maciej Los 5,011
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2014
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