users@jpa-spec.java.net

[jpa-spec users] _at_Where Annotation for filtering a to-many relationship

From: Wilming, Heinz <Heinz.Wilming_at_akquinet.de>
Date: Sat, 17 Mar 2012 13:43:16 +0000

Hi,

some JPA provider support a @Where annotation, e.g Hibernate, for filtering a to-many relationship. This annotation is very useful if you are using soft deletes instead of physical deletes.

Without the annotation, it is not possible to use a getter to retrieve a collection of entities without all soft-deleted entities from the database.

So I would like to propose this annotation for the JPA specification.

Thanks a lot,
Heinz


--
Heinz Wilming
Diplom Wirtschaftsinformatiker (FH)
akquinet tech_at_spree GmbH
Bülowstrasse 66, D-10783 Berlin
Fon:    +49 (0)30 235 520 - 0
Fax:    +49 (0)30 217 520 - 12
E-Mail:   heinz.wilming_at_akquinet.de<mailto:heinz.wilming_at_akquinet.de>
www.akquinet.de<http://www.akquinet.de>
akquinet tech_at_spree GmbH, Berlin
Geschäftsführung: Martin Weber, Dr. Torsten Fink
Amtsgericht Berlin-Charlottenburg HRB 86780 B
USt.-Id. Nr.: DE 225 964 680