如何使用SqlResultSetMapping将JPA NativeQuery的结果集映射到POJO [英] How to map the result set of a JPA NativeQuery to a POJO using SqlResultSetMapping

问题描述

我正在尝试使用带有@ConstructorResult的@SqlResultSetMapping将本机查询的结果映射到POJO.这是我的代码:

I am attempting to map the results of a Native query to a POJO using @SqlResultSetMapping with @ConstructorResult. Here is my code:

@SqlResultSetMapping(name="foo",
    classes = {
        @ConstructorResult(
                targetClass = Bar.class,
                columns = {
                    @ColumnResult(name = "barId", type = Long.class),
                    @ColumnResult(name = "barName", type = String.class),
                    @ColumnResult(name = "barTotal", type = Long.class)
                })
    })

public class Bar {

private Long barId;
private String barName;
private Long barTotal;

...

然后在我的DAO中:

Query query = em.createNativeQueryBar(QUERY, "foo");
... set some parameters ...
List<Bar> list = (List<Bar>) query.getResultList();

我已经阅读到JPA 2.1仅支持此功能，但这就是我正在使用的功能.这是我的依赖项:

I have read that this functionality is only supported in JPA 2.1, but that is what I am using. Here's my dependency:

        <dependency>
            <groupId>org.hibernate.javax.persistence</groupId>
            <artifactId>hibernate-jpa-2.1-api</artifactId>
            <version>1.0.0.Final</version>
        </dependency>

我发现了一些资源，包括以下资源:jpa 2.1中的 @ConstructorResult映射.但是我仍然没有运气.

I found a couple of resources, including this one: @ConstructorResult mapping in jpa 2.1. But I am still not having any luck.

我想念什么?为什么找不到SqlResultSetMapping?

What am I missing? Why can't the SqlResultSetMapping be found?

javax.persistence.PersistenceException: org.hibernate.MappingException: Unknown SqlResultSetMapping [foo]

推荐答案

@SqlResultSetMapping注释不应放在POJO上.将其放在(任何)@Entity类中. 未知的SqlResultSetMapping [foo]"告诉您，JPA提供程序在名称'foo'下看不到任何映射.请参阅我的另一个答案以获取正确的示例

@SqlResultSetMapping annotation should not be put on a POJO. Put it at (any) @Entity class. "Unknown SqlResultSetMapping [foo]" tells you, that JPA provider doesn't see any mapping under name 'foo'. Please see another answer of mine for the correct example

• JPA-在非实体中联接两个表课

这篇关于如何使用SqlResultSetMapping将JPA NativeQuery的结果集映射到POJO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！