@Test public void testGetResidential() throws SQLException { rp = new ResidentialProperty(); rp.setPropertyId(100); ResultSet rs = rp.getResidential(); assertNotNull(rs); if (rs.next()) { assertEquals(15, rs.getLong("specificationid")); } }