Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Question of using SqlResultSetMapping

 
Tariq Ahsan
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

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



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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic