Description Viktor Bartuszek 2012-01-15 11:51:07 EST

Build Identifier: 2.3.2

When you use nativeQuery with type cast, then the resultset's first element is ok, but all the others are filled with nulls.

public List<UserStatusType> getEntities() {
		List<EntityName> res = new ArrayList<EntityName>();
		res = em.createNativeQuery("select * from tbl", EntityName.class)
			.getResultList();
		
		return res;
	}

If you annotating the entity with SqlResultSetMapping and sets all the fields that you need, then it's working fine.:

@SqlResultSetMapping(
	name="statusResult",
	entities=@EntityResult(
		entityClass=EntityName.class,
		fields={
			@FieldResult(name="id", column="ID"),
			@FieldResult(name="statusName", column="StatusName")
		}
	)
)

public List<UserStatusType> getEntities() {
		List<EntityName> res = new ArrayList<EntityName>();
		res = em.createNativeQuery("select * from tbl", "statusResult")
			.getResultList();
		
		return res;
	}

With version 2.2.1 it's also working fine with typecast and resultset mapping too.

Reproducible: Always

Steps to Reproduce:
1. create native query with a simple select
2. run it
3. create native query with a complete SqlResultSetMapping
4. run it