Get your CodeRanch badge!*
The moose likes Object Relational Mapping and the fly likes JPA native query, group function, different entity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "JPA native query, group function, different entity" Watch "JPA native query, group function, different entity" New topic
Author

JPA native query, group function, different entity

Bruno Frascino
Ranch Hand

Joined: Jul 22, 2003
Posts: 55
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!


--BJCK--
 
wood burning stoves
 
subject: JPA native query, group function, different entity
 
Similar Threads
Oracler Date function
Need help - Lot of joins are slowing down my query
Native query always returning same data
Regular expression - Pattern and matcher
how to pass array value in sql