Hello everybody, I'm facing some issues with entities which have Lob fields and which extend a base entity by
@Inheritance(strategy=InheritanceType.JOINED)Let's suppose we have TableA (TABLE_A), TableB (TABLE_B), TableC (TABLE_C) in which I have at least one Lob field.
This three tables extend a BaseEntity (TABLE_BASE) in which I have the
@Inheritance(strategy=InheritanceType.JOINED) annotation.
When I try to query from the BaseEntity I obtain the following select:
Code:
select distinct tabl0_.*
from TABLE_BASE tabl0_1_
left outer join TABLE_A tabl0_1_ on tabl0_.ID=tabl0_1_.ID
left outer join TABLE_B tabl0_2_ on tabl0_.ID=tabl0_2_.ID
left outer join TABLE_C tabl0_3_ on tabl0_.ID=tabl0_3_.ID
where tabl0_.A_FIELD='something' )
Since in the TABLE_A and TABLE_B there are Lob fields I have the following error:
Code:
ORA-00932: inconsistent datatypes: expected - got CLOB
I'm using Hibernate 4.3.11.Final, Spring Data JPA 1.11.1.RELEASE and Oracle 11g.
Any ideas?
Many thanks for support.
PS
Forgive possible errors but I can't put the original model due to NDA issues.
Login
FAQ
Search
