join « Version « JPA Q&A





1. HQL version of a SQL join with group by    stackoverflow.com

I have two tables, Band and Votes. Band has a name and an id, and Votes has a total_votes column and a foreign key called band_id pointing to band.id. I have ...

2. fetch="join" does not select column of table    stackoverflow.com

I have a table that has a column and has a

<many-to-one name="request" class="foo.bar" column="REQUEST_ID" fetch="join"/>
When the select happens, it fetches the request object, but is unable to fetch the version ...

3. HQL Outer Join Different Behavior from Previous Version    forum.hibernate.org

Author Message benw Post subject: HQL Outer Join Different Behavior from Previous Version Posted: Mon Oct 03, 2011 1:11 pm Newbie Joined: Wed Sep 17, 2003 5:36 pm Posts: 5 Hi guys, I have been running the HQL query below for ages and it was working fine until I upgraded to v3.6.6. The problem is the SQL being generated ...

4. Join, single class, 2 version columns    forum.hibernate.org

HI! In our application (to be ported to Hibernate), we optionally allow the customer to split a table into a common part and a specific part for each subsidiary. For example, items may have identical description, but different price for each subsidiary. So, this looks like some many-to-one mapping, but it has to be in a single class. Until now, this ...