We're getting an ORA-24816 error when using Hibernate with Oracle and inserting CLOBs.
Issue
We seem to be having an issue inserting a CLOB using Hibernate with the Oracle database. The error that occurs when a SQL insert is done is:
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column.
Researching this a bit on our end we found this open JIRA seems to fit this problem:
https://hibernate.atlassian.net/browse/HHH-4635
The application is running with the following:
Server JDK - Sun 1.6.0_21
Application Server - JBossEAP 5.0.1.GA
Hibernate Core - 3.3.2.GA_CP01 shipped with server
Oracle JDBC client - Oracle 10.2 driver, ojdbc6.jar with the Sun JDK above.
Oracle DB - Oracle 10.2 RAC server
Environment
- JBoss Enterprise Application Platform (EAP)
- 5.0.1.GA
- Hibernate Core
- 3.3.2.GA_CP01
- Oracle Database
- 10.2 RAC server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.