I'm trying to figure out what is going wrong with my delete request. I get the following hibernate log message :
query and message :
select entityitem0_.ENTITY_ITEM_ID as ENTITY1_187_, entityitem0_.ARCHIVED as ARCHIVED2_187_, entityitem0_.CEILING_ENTITY as CEILING3_187_, entityitem0_.CHANGE_TYPE as CHANGE4_187_, entityitem0_.CUST_CRITERIA as CUST5_187_, entityitem0_.ENTITY_ID as ENTITY13_187_, entityitem0_.ENTITY_LNKD_ID as ENTITY6_187_, entityitem0_.PERSIST_PERSPECTVE_ID as PERSIST14_187_, entityitem0_.REQUESTING_ENTITY_NAME as REQUESTI7_187_, entityitem0_.SANDBOX_ID as SANDBOX8_187_, entityitem0_.SCHEDULED_DATE as SCHEDULE9_187_, entityitem0_.SECONDARY_TYPE as SECONDA10_187_, entityitem0_.SECT_ENTITY_FIELD as SECT11_187_, entityitem0_.ENTITY_TRGT_ID as ENTITY12_187_ from BLC_SNDBX_ENTITY_ITEM entityitem0_ inner join BLC_SNDBX_ENTITY entityimpl1_ on entityitem0_.ENTITY_ID=entityimpl1_.ENTITY_ID where entityimpl1_.TYPE=? and (entityitem0_.SANDBOX_ID not in (?)) and (select count(propertyim2_.PROPERTY_ID) from BLC_SNDBX_PROPERTY propertyim2_ inner join BLC_SNDBX_ENTITY entityimpl3_ on propertyim2_.ENTITY_ID=entityimpl3_.ENTITY_ID where (propertyim2_.NAME in (?)) and (propertyim2_.VALUE in (?)) and entityimpl3_.ENTITY_ID=entityimpl1_.ENTITY_ID)=?
[ WARN] 15:30:34 SqlExceptionHelper - SQL Error: 932, SQLState: 42000
We're using Oracle 11g.
[ERROR] 15:30:34 SqlExceptionHelper - ORA-00932: inconsistent datatypes: expected - got CLOB
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.