Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Object Relational Mapping
JPA native query, group function, different entity
posted 7 years ago
I have got an exciting problem.
I have got the following native query:
String sql = "select max(nvl(a_date, b_dt)) as max_a" + ", min(nvl(a_date, b_dt)) as min_a" + ", max(c_dt_tm) as max_c" + ", min(c_dt_tm) as min_c" + " from date_table " + " where number " + " between '" + startNumber + "' " + " and '" + endNumber + "' " + " and c_dt_tm is not null";
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!
I agree. Here's the link:
how to pass array value in sql
Need help - Lot of joins are slowing down my query
Oracler Date function
Native query always returning same data
Regular expression - Pattern and matcher