• Post Reply Bookmark Topic Watch Topic
  • New Topic

JPA native query, group function, different entity  RSS feed

Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,

I have got an exciting problem.
I have got the following native query:

As you see, this will return 4 different dates for me, and they need to populate another entity instead of date_table, which i got the values from.
So, this is the question:

"How can I select values from a table A to populate actually not the entity related to table A but an entity B related to table B?"

I am trying to use native query and resultSetMapping, but I keep getting an error, invalid column name from Hibernate. I don't know how could I do it not using nativequery.

I'd appreciate any help, thanks!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!