Beispiel #1
0
  public List<PlannedNotification> getPlannedNotificationsForCorrespondence() {
    List<PlannedNotification> result;

    SessionFactory sessionFactory = (SessionFactory) applicationContext.getBean("sessionFactory");
    Session session = sessionFactory.openSession(sessionFactory.getCurrentSession().connection());
    session.setFlushMode(FlushMode.MANUAL);
    result = new ArrayList<PlannedNotification>();
    try {
      Query query =
          session
              .createQuery(
                  "from PlannedNotification p left join fetch p.userBasedRecipientInternal where p.eventName = :var")
              .setString(
                  "var",
                  NotificationEventTypeEnum.CORRESPONDENCE_CREATED_OR_UPDATED_EVENT.toString());

      result = query.list().subList(0, 1);
    } catch (DataAccessResourceFailureException e) {
      log.error(e.getMessage());
    } catch (IllegalStateException e) {
      e.printStackTrace();
    } catch (HibernateException e) {
      log.error(e.getMessage());
    } catch (Exception e) {
      log.error(e.getMessage());
    } finally {
      session.close();
    }
    return result;
  }
  protected long getRowCountFromDataBase() {
    long rowCount = 0;
    SessionFactory factory = FLRSessionFactory.getFactory();
    Session session = null;
    try {
      session = factory.openSession();
      session = setFilter(session);

      String queryString =
          "SELECT COUNT(*) FROM FLRLohnartstundenfaktor AS lohnartstundenfaktor"
              + buildWhereClause();

      Query query = session.createQuery(queryString);
      List<?> rowCountResult = query.list();
      if (rowCountResult != null && rowCountResult.size() > 0) {
        rowCount = ((Long) rowCountResult.get(0)).longValue();
      }
    } catch (Exception e) {
      throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, e);
    } finally {
      if (session != null) {
        try {
          session.close();
        } catch (HibernateException he) {
          throw new EJBExceptionLP(EJBExceptionLP.FEHLER, he);
        }
      }
    }
    return rowCount;
  }
  public void insertTarjetaHistorico(PsTarjeta tarjeta, String xml) {

    try {

      SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
      Session newSession = sessionFactory.openSession();

      newSession.beginTransaction();
      ArmResponsePsTarjeta j = new ArmResponsePsTarjeta();
      j.setIdTarjetaArm(tarjeta.getIDTarjetaARM());
      j.setIdTarjetaFrida(tarjeta.getIDTarjetaFrida());
      j.setNombreTarjeta(tarjeta.getNombreTarjeta());
      j.setMeesageId(tarjeta.getMeesageID());
      j.setXmlMessage(xml);
      j.setFechaMensaje(new Date());

      newSession.persist(j);

      newSession.getTransaction().commit();
      newSession.close();

    } catch (HibernateException e) {

    } finally {

    }
  }
  /**
   * Create a single <code>Patient</code> record. The generated id will be available in the
   * patientRecord.
   *
   * @param patientRecord
   * @return boolean
   */
  public boolean create(Patient patientRecord) {
    log.debug("PatientDAO.create() - Begin");
    Session session = null;
    Transaction tx = null;
    boolean result = true;

    if (patientRecord != null) {
      try {
        SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
        session = sessionFactory.openSession();
        tx = session.beginTransaction();
        log.info("Inserting Record...");

        session.persist(patientRecord);

        log.info("Patient Inserted seccussfully...");
        tx.commit();
      } catch (Exception e) {
        result = false;
        if (tx != null) {
          tx.rollback();
        }
        log.error("Exception during insertion caused by :" + e.getMessage(), e);
      } finally {
        // Actual Patient insertion will happen at this step
        if (session != null) {
          session.close();
        }
      }
    }
    log.debug("PatientDAO.create() - End");
    return result;
  }
  /**
   * Gets Hibernate session.
   *
   * @param tx Cache transaction.
   * @return Session.
   */
  Session session(@Nullable GridCacheTx tx) {
    Session ses;

    if (tx != null) {
      ses = tx.meta(ATTR_SES);

      if (ses == null) {
        ses = sesFactory.openSession();

        ses.beginTransaction();

        // Store session in transaction metadata, so it can be accessed
        // for other operations on the same transaction.
        tx.addMeta(ATTR_SES, ses);

        if (log.isDebugEnabled())
          log.debug("Hibernate session open [ses=" + ses + ", tx=" + tx.xid() + "]");
      }
    } else {
      ses = sesFactory.openSession();

      ses.beginTransaction();
    }

    return ses;
  }
 @BeforeClass
 public void beforeClass() {
   SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
   publicMessageDao = new PublicMessageHibernateDao(sessionFactory);
   session = sessionFactory.getCurrentSession();
   session.beginTransaction();
 }
  @Override
  public void removeRequest(Requests request) {
    if (null != request) {

      org.hibernate.Session sess = sessionFactory.getCurrentSession();
      request = (Requests) sess.get(Requests.class, request.getId());
      List<Contacts> contTemp = request.getContacts();
      List<Products> prodTemp = request.getProducts();

      if (contTemp != null && contTemp.size() != 0) {

        sess.enableFetchProfile("requests-with-products");
        contTemp = contactsDAO.getFromProxy(contTemp);
        for (Contacts contact : contTemp) {
          contact.getConnectedRequests().remove(request);
          sess.update(contact);
        }
      }
      if (prodTemp != null && prodTemp.size() != 0) {
        sess.enableFetchProfile("requests-with-products");
        prodTemp = productsDAO.getFromProxy(prodTemp);
        for (Products product : prodTemp) {
          product.getRequestsForProduct().remove(request);
          sess.update(product);
        }
      }
      sess.update(request);
      sessionFactory.getCurrentSession().delete(request);
    }
  }
  @SuppressWarnings("unchecked")
  public static void main(String[] args) {
    SessionFactory factory = null;
    Session session = null;
    org.hibernate.Transaction tx = null;

    try {
      factory = HibernateUtil.getSessionFactory();
      session = factory.openSession();
      tx = session.beginTransaction();

      List<Transaction> transactions =
          session.createCriteria(Transaction.class).addOrder(Order.desc("title")).list();

      for (Transaction t : transactions) {
        System.out.println(t.getTitle());
      }

      tx.commit();

    } catch (Exception e) {
      e.printStackTrace();
      tx.rollback();
    } finally {
      session.close();
      factory.close();
    }
  }
Beispiel #9
0
  public static void main(String[] args) {
    Session session = null;
    Transaction tx = null;
    try {
      session = sessionFactory.openSession();
      tx = session.beginTransaction();

      // retieve all cars
      @SuppressWarnings("unchecked")
      Car car = (Car) session.createQuery("from Car c where id =1").uniqueResult();
      car.setPrice(car.getPrice() + 50);

      tx.commit();
      System.out.println(
          "brand= " + car.getBrand() + ", year= " + car.getYear() + ", price= " + car.getPrice());

    } catch (HibernateException e) {
      if (tx != null) {
        System.err.println("Rolling back: " + e.getMessage());
        tx.rollback();
      }
    } finally {
      if (session != null) {
        session.close();
      }
    }

    // Close the SessionFactory (not mandatory)
    sessionFactory.close();
    System.exit(0);
  }
  public List<DeviceList> getDeviceList(String location) {
    SessionFactory sessionFactory = HibernateSessionFactory.getSessionFactory();
    List<DeviceList> results = new ArrayList<DeviceList>();
    Session session = sessionFactory.openSession();
    if (session != null) {
      SQLQuery query =
          session.createSQLQuery(
              "select d.*,da.*,du.* "
                  + "from device_app.device d, device_app.device_availability da, device_app.device_user du "
                  + "where d.id=da.device_id and "
                  + "da.checked_out_user = du.email_id and "
                  + "d.device_status='active' and "
                  + "du.user_location=:location");
      query.addEntity(Device.class);
      query.addEntity(DeviceAvailability.class);
      query.addEntity(DeviceUser.class);
      query.setString("location", location);

      List<Object[]> resultList = query.list();
      if (resultList != null && resultList.size() > 0) {
        System.out.println("results size is " + resultList.size());
        for (Object[] array : resultList) {
          DeviceList row = new DeviceList();
          for (Object resultObject : array) {
            System.out.println(resultObject.getClass());
            if (resultObject instanceof Device) {
              Device device = (Device) resultObject;

              row.setBarCodeIdentifier(device.getBarCodeId());
              row.setDeviceCapacity(device.getDeviceCapacity());
              row.setDeviceName(device.getDeviceName());
              row.setDeviceNickname(device.getDeviceNickName());
              row.setDeviceOs(device.getDeviceOs());
              row.setDeviceOsVersion(device.getDeviceOsVersion());
              row.setDeviceSerialNumber(device.getDeviceSerialNumber());
              row.setDeviceStatus(device.getDeviceStatus());
              row.setDeviceType(device.getDeviceType());
              row.setId(device.getId());
              row.setOwnedBy(device.getDeviceOwner());

            } else if (resultObject instanceof DeviceAvailability) {
              DeviceAvailability availability = (DeviceAvailability) resultObject;
              //
              //	row.setCheckedOutAt(DateUtils.truncate(availability.getModifiedDate(),Calendar.MINUTE).toString());
              row.setCheckedOutAt(
                  DateFormatUtils.format(availability.getModifiedDate(), "yyyy-MM-dd HH:mm:ss"));
              row.setCurrentlyCheckedOutById(availability.getDeviceUser().getEmailId());
              row.setIsCheckedOut(availability.isIsCheckedOut());
              row.setLocation(location);
            } else {
              DeviceUser user = (DeviceUser) resultObject;
            }
          }
          results.add(row);
        }
      }
    }

    return results;
  }
 @Before
 public void setUp() throws Exception {
   logger.info("初始化Hibernate环境....");
   SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
   session = sessionFactory.openSession();
   session.beginTransaction();
 }
  public static void main(String[] args) {
    Session session = null;

    try {

      SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
      session = sessionFactory.openSession();

      Contact contact;

      String SQL_QUERY = "select c.id, c.firstName from Contact  c where c.id >= 3";

      Query query = session.createQuery(SQL_QUERY);
      Iterator it = query.iterate();
      while (it.hasNext()) {
        Object[] row = (Object[]) it.next();
        System.out.println("------------------------------------------------------");
        System.out.println("ID                : " + row[0]);
        System.out.println("First Name  : " + row[1]);
      }

      System.out.println("Done");
    } catch (Exception e) {
      // tx.rollback();
      System.out.println(e.getMessage());
    } finally {

      // session.flush();
      session.close();
    }
  }
Beispiel #13
0
 /*
  * loadStartandEndDates()-->this function is used for load the start and end date
  */
 private void loadStartandEndDates() {
   try {
     SessionFactory sf = serviceAttendanceProcess.getConnection();
     Session session = sf.openSession();
     session.beginTransaction();
     session.doWork(
         new Work() {
           @Override
           public void execute(Connection connection) throws SQLException {
             // TODO Auto-generated method stub
             statement = connection.prepareCall("{ call PROC_DATE_CALC (?,?,?) }");
             statement.setLong(1, payPeriodId);
             statement.registerOutParameter(2, Types.VARCHAR);
             statement.registerOutParameter(3, Types.VARCHAR);
             statement.execute();
             startDate = statement.getString(2);
             endDate = statement.getString(3);
             connection.close();
           }
         });
     tfProcessPeriod.setReadOnly(false);
     tfProcessPeriod.setValue(" " + startDate + " to " + endDate);
     tfProcessPeriod.setReadOnly(true);
   } catch (Exception e) {
     logger.info("Load Start and end Date Using Procedure" + e);
   } finally {
     try {
       statement.close();
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
       logger.info("Load Start and end Date Using Procedure" + e);
     }
   }
 }
  @Test
  public void test() {
    Configuration cfg = new Configuration();
    cfg.addAnnotatedClass(Employee.class);
    cfg.configure("hbm2ddl.xml");

    new SchemaExport(cfg).create(true, true);

    SessionFactory factory = cfg.buildSessionFactory();
    Session session = factory.getCurrentSession();
    session.beginTransaction();

    {
      Employee emp = new Employee();
      emp.setEmpName("seungbeomi");
      emp.setEmpPassword("password");
      emp.setEmpEmailAddress("*****@*****.**");
      emp.setPermanent(true);
      emp.setEmpJoinDate(new GregorianCalendar(2012, 9, 30));
      emp.setEmpLoginTime(new Date());

      session.save(emp);
    }
    session.getTransaction().commit();
  }
  public void AverageRatingByProductName(String prodName) {
    SessionFactory sf = HibernateUtility.getSessionfactory();

    Session session = sf.openSession();

    session.beginTransaction();
    String sql1 = "SELECT * FROM product where productName = :productName";
    SQLQuery query1 = session.createSQLQuery(sql1);
    query1.setParameter("productName", prodName);
    query1.addEntity(Product.class);
    Product product = (Product) query1.uniqueResult();

    String sql2 = "SELECT * FROM ratingdetails where productId = :productId";
    SQLQuery query2 = session.createSQLQuery(sql2);
    query2.setParameter("productId", product.getProductId());
    query2.addEntity(RatingDetails.class);

    List ratings = query2.list();
    session.getTransaction().commit();
    float count = ratings.size();

    int sum = 0;
    for (Object r : ratings) {
      RatingDetails rate = (RatingDetails) r;
      sum = sum + rate.getRating();
    }
    float averageRating = (sum / count);

    System.out.println("pid " + product + " avg " + averageRating);
  }
Beispiel #16
0
  public static Profile getProfile(Long id) {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      Profile profile =
          (Profile)
              session
                  .createQuery(
                      "SELECT distinct profile "
                          + "FROM Profile profile "
                          + "left join fetch profile.layoutProfiles laypro "
                          + "left join fetch laypro.layout "
                          + "WHERE profile.id = :pid ")
                  .setParameter("pid", id)
                  .uniqueResult();

      tx.commit();

      return profile;
    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
      return null;
    } finally {
      session.clear();
      session.close();
    }
  }
  public void insert(ValueObject vo) {
    // TODO Auto-generated method stub
    Session session = null;
    List ls = null;

    try {
      // This step will read hibernate.cfg.xml and prepare Hibernate for use
      SessionFactory sessionFactory =
          new
              // read cgf file.and create an object.
              Configuration()
              .configure()
              .buildSessionFactory();

      session = sessionFactory.openSession();
      // for more then transaction.
      Transaction y = session.beginTransaction();
      // Create new instance of Contact and set
      // values in it by reading them from form object
      session.save(vo); // insert query
      y.commit();

    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      session.flush();
      session.close();
    }
  }
Beispiel #18
0
  public static void deleteProfile(Profile profile) {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      for (LayoutProfile layoutProfile : profile.getLayoutProfiles()) {
        session.delete(layoutProfile);
      }

      session.delete(profile);

      tx.commit();

    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
    } finally {
      session.clear();
      session.close();
    }
  }
  @Override
  public void addRequest(Requests request) {

    sessionFactory.getCurrentSession().save(request);
    List<Contacts> contTemp = request.getContacts();
    List<Products> prodTemp = request.getProducts();

    if (contTemp != null && contTemp.size() != 0) {
      org.hibernate.Session sess = sessionFactory.getCurrentSession();
      sess.enableFetchProfile("requests-with-products");
      contTemp = contactsDAO.getFromProxy(contTemp);
      for (Contacts contact : contTemp) {
        contact.getConnectedRequests().add(request);
        contactsDAO.changeContact(contact);
      }
    }
    if (prodTemp != null && prodTemp.size() != 0) {
      org.hibernate.Session sess = sessionFactory.getCurrentSession();
      sess.enableFetchProfile("requests-with-products");
      prodTemp = productsDAO.getFromProxy(prodTemp);
      for (Products product : prodTemp) {
        product.getRequestsForProduct().add(request);
        productsDAO.changeProduct(product);
      }
    }
  }
Beispiel #20
0
  public static List<Object[]> executeTerminal(String sql) {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      List<Object[]> result = session.createSQLQuery(sql).list();

      tx.commit();

      return result;
    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
      return null;
    } finally {
      session.clear();
      session.close();
    }
  }
  public void addMansion(Mansion m) {

    Session session = sf.getCurrentSession();

    session.beginTransaction();

    session.save(m);

    session.getTransaction().commit();

    Session session2 = sf.getCurrentSession();

    session2.beginTransaction();

    Query query = session2.createQuery("from Mansion");
    List<Mansion> mlist = query.list();
    for (Mansion onem : mlist) {
      System.out.println(onem.getA().size());
    }

    Query query2 = session2.createQuery("from Aristocrat");
    List<Aristocrat> alist = query2.list();
    for (Aristocrat onea : alist) {
      System.out.println("An aristocrat...");
    }

    session2.close();
  }
Beispiel #22
0
  public static Panel savePanel(Panel panel) {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      session.saveOrUpdate(panel);

      tx.commit();

      return panel;
    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
      return null;
    } finally {
      session.clear();
      session.close();
    }
  }
  public RoleView() {

    SessionFactory sessionFactory = DatabaseUtil.getSessionFactory();
    Session openSession = sessionFactory.openSession();
    openSession.beginTransaction();

    Query query = openSession.createQuery("from Role");

    list = query.list();

    for (Role acconunt : list) {
      addComponent(new Label(acconunt.getRoleName()));
    }

    openSession.getTransaction().commit();
    openSession.flush();

    Button button = new Button("roles");

    button.addClickListener(
        new ClickListener() {

          @Override
          public void buttonClick(ClickEvent event) {

            for (Role account : list) {
              for (Permission role : account.getPermissions()) {
                System.out.println(role.getPermissionName());
              }
            }
          }
        });

    addComponent(button);
  }
Beispiel #24
0
  public static List<ClientProfile> getClientProfileList() {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      List<ClientProfile> profiles =
          session.createQuery("SELECT distinct profile " + "FROM ClientProfile profile ").list();

      tx.commit();
      return profiles;
    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
      return null;
    } finally {
      session.clear();
      session.close();
    }
  }
 protected Session getSession() {
   Session session = sessionFactory.getCurrentSession();
   if (null == session || false == session.isOpen()) {
     session = sessionFactory.openSession();
   }
   return session;
 }
Beispiel #26
0
  public static ClientProfile getClientProfileByDisplay(String display) {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      ClientProfile profiles =
          (ClientProfile)
              session
                  .createQuery(
                      "SELECT distinct client "
                          + "FROM ClientProfile client "
                          + "left join fetch client.layout layout "
                          + "left join fetch client.profile profile "
                          + "left join fetch profile.layoutProfiles laypro "
                          + "left join fetch layout.panels panel "
                          + "left join fetch panel.texts "
                          + "left join fetch panel.videos "
                          + "left join fetch panel.images "
                          + "left join fetch panel.webs "
                          + "left join fetch panel.slideShows "
                          + "left join fetch panel.feeds "
                          + "left join fetch laypro.layout lay "
                          + "left join fetch lay.panels pan "
                          + "left join fetch pan.texts "
                          + "left join fetch pan.videos "
                          + "left join fetch pan.images "
                          + "left join fetch pan.webs "
                          + "left join fetch pan.slideShows "
                          + "left join fetch pan.feeds "
                          + "WHERE client.clientName = :pname")
                  .setParameter("pname", display)
                  .uniqueResult();

      tx.commit();

      if (profiles != null && profiles.getProfile() != null) {
        Map<Long, LayoutProfile> map = new LinkedHashMap<Long, LayoutProfile>();
        for (LayoutProfile layoutProfile : profiles.getProfile().getLayoutProfiles()) {
          map.put(layoutProfile.getId(), layoutProfile);
        }
        profiles.getProfile().getLayoutProfiles().clear();
        profiles.getProfile().getLayoutProfiles().addAll(map.values());
      }

      return profiles;
    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
      return null;
    } finally {
      session.clear();
      session.close();
    }
  }
  public static void main(String[] args) {

    SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
    Session session = sessionFactory.openSession();
    session.beginTransaction();
    // CREATE
    for (int i = 1; i <= 30; i++) {
      UserInfo user = new UserInfo();

      user.setName("User" + i);
      session.save(user);
    }
    session.getTransaction().commit();
    session.close();

    UserInfo user = new UserInfo();
    session = sessionFactory.openSession();
    session.beginTransaction();
    // Retreive
    user = (UserInfo) session.get(UserInfo.class, 6);
    // Update
    user.setName("Updated User Name");
    session.update(user);

    // Delete
    user = (UserInfo) session.get(UserInfo.class, 5);
    session.delete(user);
    session.getTransaction().commit();
    session.close();

    //		System.out.println("User Object retrieved is: " + user);

  }
Beispiel #28
0
  @SuppressWarnings("unchecked")
  public static List<Profile> getProfileList() {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = null;
    Transaction tx = null;

    try {
      session = sf.openSession();
      tx = session.beginTransaction();

      List<Profile> profiles =
          session
              .createQuery(
                  "SELECT distinct profile "
                      + "FROM Profile profile "
                      + "left join fetch profile.layoutProfiles laypro "
                      + "left join fetch laypro.layout "
                      + "ORDER BY profile.name, laypro.ordering ")
              .list();

      tx.commit();
      return profiles;
    } catch (Exception e) {
      e.printStackTrace();
      if (tx != null) {
        tx.rollback();
      }
      return null;
    } finally {
      session.clear();
      session.close();
    }
  }
  public static void reservar(
      Hospede hospede, Apartamento apartamento, Date dt_inicio, Date dt_fim) {
    Session session = null;
    Transaction tx = null;

    try {
      SessionFactory factory = new Configuration().configure().buildSessionFactory();
      session = factory.openSession();

      tx = session.beginTransaction();
      Reserva reserva = new Reserva();
      reserva.setHospede(hospede);
      reserva.setApartamento(apartamento);
      reserva.setDataInicio(dt_inicio);
      reserva.setDataFim(dt_fim);
      session.save(reserva);

      /*Depois de salvar a RESERVA tem que mudar a situação do apartamento para não disponível*/
      // Apartamento apBd = ApartamentoDAO.buscarApartamento(apartamento.getId());
      // apBd.setDisponivel(false);
      session.update(apartamento);
      tx.commit();

    } catch (Exception e) {
      if (tx != null) tx.rollback();
      System.out.println("Erro: " + e.getMessage());
    } finally {
      session.close();
    }
  }
Beispiel #30
0
  /**
   * Gets the planned notifications for the list of sites that are passed in. This method access the
   * db using a new session from the hibernate session factory.
   *
   * @param hcsList the hcs list
   * @return the planned notifications
   */
  public List<PlannedNotification> getPlannedNotificationsForUpdateMasterSubject() {
    List<PlannedNotification> result;

    SessionFactory sessionFactory = (SessionFactory) applicationContext.getBean("sessionFactory");
    Session session = sessionFactory.openSession(sessionFactory.getCurrentSession().connection());
    session.setFlushMode(FlushMode.MANUAL);
    result = new ArrayList<PlannedNotification>();
    try {
      Query query =
          session
              .createQuery("from PlannedNotification p where p.eventName = :var")
              .setString("var", NotificationEventTypeEnum.MASTER_SUBJECT_UPDATED_EVENT.toString());

      result = query.list();
    } catch (DataAccessResourceFailureException e) {
      log.error(e.getMessage());
    } catch (IllegalStateException e) {
      e.printStackTrace();
    } catch (HibernateException e) {
      log.error(e.getMessage());
    } catch (Exception e) {
      log.error(e.getMessage());
    } finally {
      session.close();
    }
    return result;
  }