public static RepNotification GET_NOTIFICATIONS(OVNotification oVNotification) throws SQLException {
        RepNotification rep = new RepNotification();
        Connection connexion = GET_CONNECTION();

        try {
            int distance = oVNotification.getDistance();
            int major = oVNotification.getOvBeacon().getMajor();

            Statement statement = connexion.createStatement();
            ResultSet resultat = statement.executeQuery("SELECT notification.id,"
                    + "notification.distance, notification.reponseNeeded, notification.texte, notification.idPromotion "
                    + "FROM notification\n"
                    + "INNER JOIN beacon on (notification.idBeacon = beacon.id)\n"
                    + "WHERE distance = " + distance + " and major = " + major);

            while (resultat.next()) {
                OVNotification ovNotif = new OVNotification(
                        resultat.getInt("notification.id"),
                        resultat.getInt("notification.distance"),
                        resultat.getInt("notification.reponseNeeded"),
                        resultat.getString("notification.texte"),
                        resultat.getInt("notification.idPromotion")
                );

                rep.getListeNotification().add(ovNotif);
            }

            // Traitement des notifications qui ont besoin d'une réponse 
            if (rep.getListeNotification().size() > 0 && rep.getListeNotification().get(0).isResponseNeeded() == 1) {
                statement.close();
                statement = connexion.createStatement();
                OVReponse ovReponse = new OVReponse();
                ovReponse.setEtat(0);
                int resultatInsert = statement.executeUpdate("INSERT intO reponse (etat, idNotification) VALUES (0, " + rep.getListeNotification().get(0).getId() + ");", Statement.RETURN_GENERATED_KEYS);

                if (resultatInsert == 0) {
                    rep.erreur = true;
                    rep.messageErreur = "Aucune ligne inséré!";
                } else {
                    ResultSet gk = statement.getGeneratedKeys();
                    if (gk.next()) {
                        ovReponse.setId(gk.getInt(1));
                    } else {
                        rep.messageErreur = "Creating user failed, no ID obtained.";
                    }
                }
                rep.getListeNotification().get(0).setReponseEnvoye(ovReponse);
                rep.getListeNotification().get(0).setOvPromotion(GET_PROMOTIONS_BY_ID(rep.getListeNotification().get(0).getIdPromotion()).getListePromotion().get((0)));
            }

        } catch (SQLException ex) {
            rep.erreur = true;
            rep.messageErreur = ex.getMessage();
        }

        return rep;
    }