XPath question on returning a list of elements

[Tony Evans]

I have the following XML

<RequestDetails>
		
			<Rooms>
				<Room Code="DB" NumberOfCots="0" NumberOfRooms="1">
					<ExtraBeds />
				</Room>
				<Room Code="DB" NumberOfCots="1" NumberOfRooms="2">
					<ExtraBeds />
				</Room>
				<Room Code="TB" NumberOfCots="2" NumberOfRooms="1">
					<ExtraBeds />
				</Room>
			</Rooms>
</RequestDetails>

Using XPath I just want to extract the three rooms.

I have the following java code

public List<RoomOccupancy> setRoomOccupancyFromXML(final String xml, final String element)
			throws XPathExpressionException, ParserConfigurationException,
			SAXException, IOException {
		String expression = REQUEST_ELEMENT + element;
		List<RoomOccupancy> occupancies = new ArrayList<RoomOccupancy>();
		XPath xPath = XPathFactory.newInstance().newXPath();
		NodeList rooms = (NodeList) xPath.compile("RequestDetails/Rooms").evaluate(readDoc(xml), XPathConstants.NODESET);
		if (rooms != null) {
			for (int i = 0; i < rooms.getLength(); i++) {
				Element room = (Element) rooms.item(i);
				String value = xPath.evaluate("Room/@Code", room);
				RoomOccupancy occupancy = createRoomOccupancy(value.toLowerCase());
				value = xPath.evaluate("Room/@NumberOfCots", room);
				Integer.parseInt(value);
				occupancies.add(occupancy);
			}
		}
		return occupancies;
	}

The problem is that it just rooms only has one room in it not the 3 I am expecting.

Thanks for any Help

[Tony Evans]

Solved it there is only one rooms element to get the room i rest the code as follows

 NodeList rooms = (NodeList) xPath.compile("RequestDetails/Rooms/Room").evaluate(readDoc(xml), XPathConstants.NODESET);   

and just remove the room before the attributes when extracting the values