openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MiƂosz Tylenda <>
Subject Re: Restrict collection items
Date Tue, 23 Dec 2008 13:27:34 GMT

Maybe you could achieve a similar effect by using a "constant join". Have a look at the following
section in the manual:


> Hello All
> We are migrating from Hibernate to OpenJPA and we faced the following
> problem: it seems there is no alternative to Hibernate's @Where annotation
> for collection properties. This annotation allowed us to add arbitrary SQL
> for collections loading, e.g. @Where("IS_DELETED=0").
> We used this to filter so called "marked as deleted" records.
> Could anybody suggest a way to filter collection when loading them from
> database?
> Using LRS will be too heavyweight solution for us.
> Thanks in advance.
> -- 
> View this message in context:
> Sent from the OpenJPA Users mailing list archive at

View raw message