Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of curtisr7@gmail.com designates
 74.125.83.46 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=wcW/H/GdDF1nno+67ha4OSp64kQags3QU8btrmcq5/Dzg7c00fn6KhQX3dcj6lI97t
         7SBEwMyFrtXVWG/gEWYWDETP+eCEjv0Tf9ggXP+WQxOUjKsxvQgi9aThZG/JR5PqYG03
         qRbm6luVcnITYeLh5FYW12SamjxRAKpQ5mv7I=
MIME-Version: 1.0
In-Reply-To: <AANLkTinyX6CnA+=8RVo37O4HdCWfUZ53qA8y5GjA=3-O@mail.gmail.com>
References: <AANLkTinyX6CnA+=8RVo37O4HdCWfUZ53qA8y5GjA=3-O@mail.gmail.com>
Date: Tue, 14 Sep 2010 09:56:31 -0500
Message-ID: <AANLkTinPDCVjAcFJ0G6fgNPz3mCuGBx87pAds_xbk3v=@mail.gmail.com>
Subject: Re: Defining named queries in xml
From: Rick Curtis <curtisr7@gmail.com>
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=000e0cd6aa5819067a0490396b90

--000e0cd6aa5819067a0490396b90
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hakon -

> ... it's possible to specify the named queries in a separate file, and
still define the entities using annotations?
Yes, you can specify mapping information in annotations and via mapping
file(s). In the case where mapping information is specified in both
annotations and xml, the xml mapping information will always take
precedence.

For example, if you wanted to use the orm.xml file for only your named
queries, you could do something along these lines (borrowed from our unit
test bucket)...

<entity-mappings xmlns=3D"http://java.sun.com/xml/ns/persistence/orm"
    xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation=3D"http://java.sun.com/xml/ns/persistence/ormorm_2_0=
.xsd"
    version=3D"2.0">
    <entity name=3D"XMLFieldAccess2"
class=3D"org.apache.openjpa.persistence.access.xml.XMLFieldAccess2">
        <named-query name=3D"XMLFieldAccess2.query">
            <query>SELECT xfa FROM XMLFieldAccess2 xfa WHERE xfa.id =3D :id
AND xfa.strField =3D :strVal </query>
        </named-query>
    </entity>
</entity-mappings>

This information can be put in a couple different places. The easiest is to
put it in META-INF/orm.xml. Another option is to create another xml file an=
d
you'll need to specify
<mapping-file>org/apache/openjpa/persistence/xml/orm.xml</mapping-file> in
your persistence.xml. If you follow one of these two options correctly, the
enhancer will find the mapping file(orm.xml) and instrument your Entities
correctly.

> Are there any guides on how to work with orm files using openjpa(?)
Unfortunately I haven't found much good information, even the spec is prett=
y
light on mapping using the orm.xml. Maybe someone else on the list has some
input? One good place to look for examples is the openjpa unit tests. We
have a pretty exhaustive test suite that should help get you going.

Thanks,
Rick

2010/9/14 H=E5kon Sagehaug <hakon.sagehaug@uni.no>

> Hi all,
>
> Up til now I created my entities using the java annotations with queries
> etc, but was wondering if it's possible to specify the named queries in a
> separate file, and still define the entities using annotations. Or do I
> have
> to do my entities in orm file if I want the named queries in XML or
> similar.
>
> Are there any guides on how to work with orm files using openjpa, does th=
e
> enhancer create the needed java classes from the XML or how does it work?
>
> Cheers, H=E5kon
>

--000e0cd6aa5819067a0490396b90--