add named query to room for select rooms for a location.
changed id in location_room from integer to bigint.
add implementation for RoomService and corresponding test.