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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.