Juri Berlanda created OPENJPA-2778:
--------------------------------------
Summary: Error on Oracle LOB handling
Key: OPENJPA-2778
URL: https://issues.apache.org/jira/browse/OPENJPA-2778
Project: OpenJPA
Issue Type: Bug
Components: jdbc, jpa
Affects Versions: 3.0.0, 2.4.3, 2.4.0
Reporter: Juri Berlanda
I get the following error
{{ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB
column}}
on one of our queries.
The Entity I am trying to write is relatively complicated (includes @Embedded
and inheritance), but for legal reasons I am not allowed to disclose the code.
What seems to happen is, that the not all CLOB columns are updated at the end
of the update statement.
>From logs I see:
{{databaseProductName: Oracle}}
{{databaseProductVersion: Oracle Database 12c Enterprise Edition Release
12.1.0.2.0 - 64bit Production}}
{{Using dictionary class "org.apache.openjpa.jdbc.sql.OracleDictionary" (Oracle
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production}}
I reproduced the bug using all of Oracle driver 12.1.0.2, 12.2.0.1 and 18.3.
Unfortunately I cannot downgrade further then version 2.4.0, since our codebase
uses Java8 features.
Hibernate does not show the described behavior, neither does the same code on
PostgreSQL.
I am happy to help debug and fix the issue, but I'd need some guidance (i.e.
where to look).
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
