I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error;
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes]; uncategorized SQLException for SQL [insert into notes1 (REQUEST_ID, NOTES_TEXT, USER_ACTION, ACTIVITY_NAME, ATTCH_REFS, INSERT_ID, INSERT_DATE, UPDATE_ID, UPDATE_DATE, NOTES_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [null]; error code ; operation not allowed: streams type cannot be used in batching; nested exception is java.sql.SQLException: operation not allowed: streams type cannot be used in batching
notes_text is CLOB type.
Can you please check and give me solution for this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!