@SqlResultSetMapping

[Lukas Hnatuk]

Hi everyone,
I am trying to do some NatveQueries, but I am stuck with @SqlResultSetMapping configuration.

I have those classes:

@Entity
public class LocalUser implements Serializable {
    private static final long serialVersionUID = 1265845L;
    @Id
    private String username;
    @Column(nullable=false)
    private String password;

    @OneToMany
    private List<RoleName> roles;

    
    public LocalUser() {
    }

    public LocalUser(String username, String password, List<RoleName> roles) {
        this.username = username;
        this.password = password;
        this.roles = roles;
    }    
    
    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public List<RoleName> getRoles() {
        return roles;
    }

    public void setRoles(List<RoleName> roles) {
        this.roles = roles;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }
}

@Entity
public class RoleName implements Serializable {
    private static final long serialVersionUID = 12598741564894L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String roleName;

    public RoleName() {
    }
    
    public RoleName(Long id, String roleName) {
        this.id = id;
        this.roleName = roleName;
    }

    public RoleName(String roleName) {
        this.roleName = roleName;
    }
    
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getRoleName() {
        return roleName;
    }

    public void setRoleName(String roleName) {
        this.roleName = roleName;
    }
}

My question is, how to write propper @SqlResultSetMapping for class LocalUser. My test SQL statement is

select 'user' as username, 'passwd' as password, 1 as id, 'admin' as roleName;

and I would like to get one Entitny Local user, with username user, password passwd and List of roles, where is admin with id 1.

I figgured as far something like this:

@SqlResultSetMapping(name="LocalUserMapping",
        entities={
            @EntityResult(entityClass=LocalUser.class,fields={
                @FieldResult(name="username",column="username"),
                @FieldResult(name="password",column="password")
            }),
            @EntityResult(entityClass=RoleName.class,fields={
                @FieldResult(name="id",column="id"),
                @FieldResult(name="roleName",column="roleName")
            })
        })

but it gives me two objects, instead of one.

Can anybody help me please?

Thanks

[James Sutherland]

You can't define this with a ResultSetMapping, other than getting the two objects back.

If you are using EclipseLink, you could use a normal native query for the class and set the join-fetch hint. It should then build the objects that you want.