使用 jpa 和 hibernate 在 orm.xml 中定义命名查询 [英] define named query in orm.xml with jpa and hibernate

问题描述

我试图将我的命名查询放入我的 orm.xml(放入带有persistence.xml 的 META-INF)但我的 orm.xml 似乎被 hibernate/jpa 忽略.

I'm trying to put my named queries in my orm.xml (put in META-INF with persistence.xml) but my orm.xml seems to be ignored by hibernate/jpa.

当我尝试使用 em.createNamedQuery("myQuery") 创建命名查询时，它返回找不到此查询.

When I try to create my named query with em.createNamedQuery("myQuery"), it returns that it can't find this query.

我使用注解，我想在 orm.xml 中外部化我的命名查询(仅此而已).

I use annotation and I would like to externalize my named queries in orm.xml (only that).

这是我的persistence.xml:

Here is my persistence.xml:

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">

<persistence-unit name="default" transaction-type="RESOURCE_LOCAL">
    <mapping-file>META-INF/orm.xml</mapping-file>

    <class>com.mysite.Account</class>

    <properties>
        <property name="hibernate.cache.provider_class" value="net.sf.ehcache.hibernate.EhCacheProvider" />
        <property name="hibernate.cache.use_query_cache" value="true" />
        <property name="hibernate.cache.use_second_level_cache" value="true" />
        <property name="hibernate.show_sql" value="true" />
        <property name="hibernate.format_sql" value="true" />
        <property name="use_sql_comments" value="false" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.MYSQLDialect" />
        <property name="hibernate.c3p0.min_size" value="5" />
        <property name="hibernate.c3p0.max_size" value="20" />
        <property name="hibernate.c3p0.timeout" value="300" />
        <property name="hibernate.c3p0.max_statements" value="50" />
        <property name="hibernate.c3p0.idle_test_period" value="3000" />

        <property name="hibernate.search.default.directory_provider" value="org.hibernate.search.store.FSDirectoryProvider" />
    </properties>

</persistence-unit>

</persistence>

这是我的 orm.xml

here is my orm.xml

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" version="1.0">

<package>com.mysite</package>

<entity class="Account">
    <sql-result-set-mapping name="nicknames">
        <column-result name="nickname" />
    </sql-result-set-mapping>
    <table name="Account" />
    <named-native-query name="myQuery" result-set-mapping="nicknames">
        <query><![CDATA[select a.nickname from Account a]]>
    </query>
    </named-native-query>
</entity>
</entity-mappings>

我做错了什么?为什么我的 orm.xml 被忽略了?

What I'm doing wrong ? Why my orm.xml is ignored ?

谢谢

推荐答案

好的，我终于明白了！

我将我的 orm.xml 保存在 META-INF 目录中.当我将此文件移动到包含域对象的包中时(例如在我的示例中:com.mysite)，orm.xml 不会被忽略并全部运行.

I was saving my orm.xml in META-INF directory. When I move this file to my package where I have my domain object (like in my example: com.mysite), the orm.xml is not ignored and all run.

我还需要更改映射文件(persistence.xml)中的路径:com/mysite/orm.xml

I also need to change the path in mapping-file (persistence.xml) : com/mysite/orm.xml

这篇关于使用 jpa 和 hibernate 在 orm.xml 中定义命名查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！