This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I'm having problems with the OneToMany side of a relation.
2 models (with the appropiate getters and setters)
If I make the query from City table, I have no problem.
But I'm trying this.
and Hibernate (with Oracle) makes a Query like this.
select * from ( select this_.Serial as Serial2_0_, this_.CodeRegion as CodeRe2_2_0_, this_.DescRegion as DescRe3_2_0_ from region this_ where exists (select 1 from city where this_.Serial=CodeRegion) ) where rownum <= ?
I noted that part in Black as is using Serial column not using the CodeRegion
Any way to substitute the black part from this_.Serial to this_.CodeRegion?