public List getExamplesWithNoDefects(Integer buildingObjectId, Properties props) throws SQLException {
Connection dbConn = getConnection(props);
Statement st = (Statement) dbConn.createStatement();
System.out.println("select exampleId from constructionExamples where constructionExamples.noDeffects=false and objectConstructionId in (select typeId from objectConstructions where objectId="+buildingObjectId+")");
ResultSet rs = (ResultSet) st.executeQuery("select exampleId from constructionExamples where constructionExamples.noDeffects=false and objectConstructionId in (select typeId from objectConstructions where objectId="+buildingObjectId+")");
List list=new ArrayList();
while (rs.next()) {
list.add(new Integer(rs.getInt(1)));
}