Question of using SqlResultSetMapping

[Tariq Ahsan]

Hello All,

Learning to use Hibernate and JPA. Trying to use CreateNativeQuery in the following way -

import javax.persistence.Query;
import javax.persistence.SqlResultSetMapping;
import javax.persistence.EntityResult;
import javax.persistence.FieldResult;

...

@Stateful
@Scope(ScopeType.CONVERSATION)
@Name("test")
@SqlResultSetMapping(name="testing", entities = 
        @EntityResult(entityClass=table1.class, fields= {
            @FieldResult(name="col1", column="col1"),
            @FieldResult(name="col2", column="col2"),
            @FieldResult(name="col3", column="col3"),
        })
)
public class TestAction  implements TestInterface {

public String col1;
...

@DataModel
private List<table1> queryresults;
...

String sqlStmt = " select col1, col2, col3, col4  from (select col1, col2, col3, col4" +   
             "from table1" +    
             "union " +   
             "select col1, col2, col3, col4" +   
             "from table2) " +   
             "where col1 = :col1";  
queryresults = em.createNativeQuery(sqlStmt, "testing).getResultList();   
col1 = queryresults.get(0).getCol1();

...

But getting org.hibernate.MappingException: Unknown SqlResultSetMapping [testing]

Not sure if the @SqlResultSetMapping or the @NameNativeQuery need to be in the table1 POJO. In that case I would rather create a db table view doing the same above query using UNION of table1 and table2. I thought I could use SqlResultSetMapping to use one of the 2 tables (table1 or table2) class object's common fields (col1, col2 and col3) and assign the resultList values to it.
Is it something else I am missing or not doing right?

Thanks