I'm sorry you'll need to be a bit more specific. What query are you using with the annotation and what error is it telling you? Remember, you cannot use the query you specified above in the @NamedNativeQuery; you need to use native SQL and not HQL / JPQL.