How do I create Named Queries in a Separate file

Question

I need to keep the all the named queries in a separate file. For example

@javax.persistence.NamedQueries({
    @NamedQuery(name = "Employee.findAll", query = "SELECT e FROM Employee e")})

public class AllNamedQueries {

}

Now that much in itself causes an Error "Named queries can only be defined in Entity or MappedSuperClass class".

How do I create Named Queries in a Separate file? By separate I mean files other than entity file.

score 3 · Accepted Answer · edited May 23 '17 at 12:02

3

You can use orm.xml that allows you to define JPA mappings in XML. This approach is equivalent and overrides annotations.

Example based on define named query in orm.xml with jpa and hibernate:

<entity class="com.example.Employee">
    <table name="Employee.findAll" />
    <named-query name="findAll">
        <query><![CDATA[
          SELECT e
          FROM Employee e
        ]]></query>
    </named-query>
</entity>

edited May 23 '17 at 12:02

Community

1
1

answered Dec 06 '11 at 22:30

Tomasz Nurkiewicz

334,321
69
703
674

I'm using OpenJPA, not hibernate. – SQC Dec 07 '11 at 04:58
2

What has Hibernate got to do with anything? This is JPA, as per the spec. – DataNucleus Dec 07 '11 at 08:31
1

@SQC: `orm.xml` is a JPA standard descriptor: *define **JPA** mappings in XML* - works in every JPA provider. See: http://openjpa.apache.org/builds/1.0.0/apache-openjpa-1.0.0/docs/manual/jpa_overview_persistence.html – Tomasz Nurkiewicz Dec 07 '11 at 08:35
Thanks guys, I thought OpenJPA doesn't use one – SQC Dec 09 '11 at 01:41

How do I create Named Queries in a Separate file

1 Answers1

Linked