Hi every one

I have three tables Post, Reply and Abuse

One Post may have more than one reply.
Post table and Reply tables have OneToMany relationship.
So when we fetch any Post from DB it also fetches its replies.

If any one reply is abused by users. It will be saved in Abuse table

Here my problem is,
Now, I need to hide those abused reply from my replies collection. But I can't hide that particular reply, though it is coming from collection.

How to leave that reply through sql where condition?
Is it possible to do through annotation?
Is there any other way to achieve this?

(i.e), while selecting all Posts i need to leave that abused reply.

Yes, when mapping a collection, you can add an arbitrary "where" condition, using the "where" attribute plus a SQL where clause.

This is using a mapping file. I don't know if the same effect can be achieved with annotations.

Hi Gonzalo Díaz,

Thank you for your wonderful support.

But i need further help,

I have tried like,


but it gives ORA 00904 error for field status.

I have tried like,


but it give ORA 00936 error.

Note: I need to do some more processes later thats why i kept separate table for abuse. and abuse table has some more columns too

Can you please correct me.


And, I have searched for the Where clause in net. But i cant get any help or material about the @Where clause

Can you give any link to learn more about hibernate clauses

Thank you.

by,
Alex

Please post your mappings and schema.

For information on where clause, see this link

http://www.hibernate.org/hib_docs/annotations/reference/en/html_single/#entity-hibspec-collection