Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 3.2.5
I am trying to recreate an SQL query using a Criteria query and was hoping someone could help.
The SQL is:
Code:
SELECT HTL_HOTELS.HOTL_ID
FROM HTL_HOTELS, LOCATIONS, LOC_LOCATION_NAMES
WHERE HTL_HOTELS.HOTL_LOCATION_ID = LOCATIONS.LOCATION_ID
AND LOCATIONS.LOCATION_ID = LOC_LOCATION_NAMES.LOCATION_ID
AND LOC_LOCATION_NAMES.LOCATION_NAME LIKE 'Fukuo%'
And I have the schema mapped as followed:
- HTL_HOTELS table -> Hotel.java
- LOCATIONS table -> Location.java
- LOC_LOCATION_NAMES table -> LocationName.java
where
- a Hotel.java object has a Location.java field
- a Location.java object has a set of LocationName objects
Any help much appreciated
Login
FAQ
Search