Hello,
I have 2 classes USercontent and content , UserContent extends content as a joined-subclass strategy keyed by the same column Content_id. when i try and do a bulk update using a named hql as...

<query name="update.content.as.verified">
update UserContent uc set uc.isVerifiedByAdmin =:isVerified where uc.id in (:contentIdList)
</query>

i get an oracle column ambigous error exception. the sql executed and the exception log is ...


Hibernate operation: could not insert/select ids for bulk update; bad SQL grammar [insert into HT_USER_CONTENT select userconten0_.CONTENT_ID as CONTENT_ID from USER_CONTENT userconten0_ inner join CONTENT userconten0_1_ on userconten0_.CONTENT_ID=userconten0_1_.CONTENT_ID where CONTENT_ID in (?)]; nested exception is java.sql.SQLException: ORA-00918: column ambiguously defined

Caused by: java.sql.SQLException: ORA-00918: column ambiguously defined



any ideas how i can qualify the content_id to use uc.content_id ?Iam using hibernate 3.1.3

Thanks

bumping this thread...anyone has any ideas? kinda stuck with using direct jdbc for now which can become more difficult with deletes