problem with @FieldResult, mapping does not seem to work

[niels maes]

Hi everyone,

I'm trying to execute the following query:

		List<Employee> employees = em.createNativeQuery(
				"select id, lastname as last_name from employee", "employeeResult")
				.getResultList();

		for (Employee emp : employees) {
			System.out.println(emp.toString());
		}

I expect an id and a lastname to be returned from the query, However only an id is returned.
It seems that the fieldresult annotation does not work.
If I use a different query: select id, lastname from employee, I get the lastname returned.
Below is the complete entity.

Does anyone have an idea what could be wrong?
thanks.

package com.niels.persistence.nativequery;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityResult;
import javax.persistence.FieldResult;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.NamedNativeQueries;
import javax.persistence.NamedNativeQuery;
import javax.persistence.OneToOne;
import javax.persistence.SqlResultSetMapping;

@Entity
@SqlResultSetMapping(name = "employeeResult", 
	entities = @EntityResult(entityClass = Employee.class, 
	fields = { @FieldResult(column = "last_name", name = "lastName") }))
public class Employee {

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private long id;

	@Column(name = "first_name")
	private String firstName;
	private String lastName;

	@OneToOne
	@JoinColumn(name = "dept_id")
	private Department department;

	public Department getDepartment() {
		return department;
	}

	public void setDepartment(Department department) {
		this.department = department;
	}

	public Employee() {
		super();
	}

	public Employee(String firstName, String lastName) {
		super();
		this.firstName = firstName;
		this.lastName = lastName;
	}

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	@Override
	public String toString() {
		return "Employee [id=" + id + ", firstName=" + firstName
				+ ", lastName=" + lastName + ", department=" + department + "]";
	}

	public Employee(String firstName, String lastName, Department department) {
		super();
		this.firstName = firstName;
		this.lastName = lastName;
		this.department = department;
	}

}

[Vijitha Kumara]

Welcome to the CodeRanch!

Why you haven't mapped the "lastName" column in the entity as with the "firstName" in the first place?

[niels maes]

thanks.

It is just an example to try out the @field_result annotation.
I'm trying out all annotations, originally the mapping was as in your suggestion.
I deliberately changed the mapping/the query to be able to test the field_result annotation.
But I don't understand why it doesn't work.

[Vijitha Kumara]

I haven't tried this myself (may be later I'll try). But I think persistence provider has no idea of the field being a persistent field. You can verify this perhaps by persisting an entity of this with this code?