CRS/src/main/java/com/epam/indigo/crs/services/search/BingoSearchImpl.java [168:182]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
            ResultSet rs = ps.executeQuery();

            List<FullCompoundInfo> resultList = new ArrayList<FullCompoundInfo>();
            while (rs.next()) {
                resultList.add(new FullCompoundInfo(rs.getString(1), rs.getString(2), rs.getString(3),
                        rs.getString(4), rs.getDouble(5), rs.getString(6), rs.getString(7), rs.getString(8),
                        rs.getString(9), rs.getString(10), rs.getString(11), CompoundRegistrationStatus.SUCCESSFUL));

            }

            return resultList;
        } catch (Exception e) {
            throw new CRSException(e.getMessage(), e);
        } finally {
            closeConnection(dbConnection);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



CRS/src/main/java/com/epam/indigo/crs/services/search/BingoSearchImpl.java [222:235]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
            ResultSet rs = ps.executeQuery();

            List<FullCompoundInfo> resultList = new ArrayList<FullCompoundInfo>();
            while (rs.next()) {
                resultList.add(new FullCompoundInfo(rs.getString(1), rs.getString(2), rs.getString(3),
                        rs.getString(4), rs.getDouble(5), rs.getString(6), rs.getString(7), rs.getString(8),
                        rs.getString(9), rs.getString(10), rs.getString(11), CompoundRegistrationStatus.SUCCESSFUL));
            }

            return resultList;
        } catch (Exception e) {
            throw new CRSException(e.getMessage(), e);
        } finally {
            closeConnection(dbConnection);
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -