Examples of org.hibernate.Session.createQuery()

org.hibernate.Session.createQuery()
Create a new instance of Query for the given HQL query string. @param queryString a HQL query @return Query @throws HibernateException

    }
    try {
      //old: deleted = getSession().delete(query, value, type);
      
      Session si = getSession();
      Query qu = si.createQuery(query);
      qu.setParameter(0, value, type);
      List foundToDel = qu.list();
      int deletionCount = foundToDel.size();
      for (int i = 0; i < deletionCount; i++ ) {
        si.delete( foundToDel.get(i) );

View Full Code Here

      throw new DBRuntimeException("cannot delete in a transaction that is rolledback or committed " + values);
    }
    try {
      //old: deleted = getSession().delete(query, values, types);
      Session si = getSession();
      Query qu = si.createQuery(query);
      qu.setParameters(values, types);
      List foundToDel = qu.list();
      int deletionCount = foundToDel.size();
      for (int i = 0; i < deletionCount; i++ ) {
        si.delete( foundToDel.get(i) );

View Full Code Here

                assert newForum.getAreaNumber().equals(100l);


                assert newForum.getFeed() != null;


                Session s = getHibernateSession();
                WikiMenuItem newMenuItem = (WikiMenuItem)s
                        .createQuery("select m from WikiMenuItem m where m.directory.id = :dir")
                        .setParameter("dir", newId)
                        .uniqueResult();
                assert newMenuItem.getDisplayPosition() == 2l;
                s.close();

View Full Code Here

        }.run();
    }


    private boolean checkDirectoryInDatabase(long nodeId) throws Exception {
        Session s = getHibernateSession();
        WikiDirectory dir = (WikiDirectory ) s.createQuery("select d from WikiDirectory d left join fetch d.parent where d.id = :id").setParameter("id", nodeId).uniqueResult();
        s.close();
        return dir != null;
    }


    private boolean checkDocumentInDatabase(long nodeId) throws Exception {

View Full Code Here

        return dir != null;
    }


    private boolean checkDocumentInDatabase(long nodeId) throws Exception {
        Session s = getHibernateSession();
        WikiDocument doc = (WikiDocument) s.createQuery("select d from WikiDocument d left join fetch d.parent left join fetch d.tags where d.id = :id").setParameter("id", nodeId).uniqueResult();
        s.close();
        return doc != null;
    }


    private Session getHibernateSession() throws Exception {

View Full Code Here

          }


          try {


          final java.util.List results =
              session.createQuery("from VisualElement as el where el.item = ?")
              .setString(0, config.getString("targets")).list();
          if (results.size() > 1) log.error("database contains multiple root targets");
          
          if (results.size() > 0) {
            visual_transient = (VisualElement) results.get(0);

View Full Code Here

              // remove very old events
              final EventGeneric ev =
                getEventByIndex(new Integer(getConfig().getProperty("events.merge.threshold." + (idx - 1))),
                    target.getEventLists().get(event_type).getId());
              if (ev != null) {
                query = session.createQuery("delete EventGeneric as ev " +
                "where ev.eventList = :event_list and ev.date < :stop_date")
                .setString("event_list", target.getEventLists().get(event_type).getId().toString())
                .setString("stop_date", ev.getDate().toString());
                query.executeUpdate();
              }

View Full Code Here

      String str = "<HR/><B>Database statistics</B><BR/>";


      Session session = getSynchro().getSessionFactory().getCurrentSession();
      session.beginTransaction();
      try {
        Integer count = (Integer) session.createQuery("select count(*) from EventGeneric").uniqueResult();
        str += "total number of events: " + count + "<BR/>";
        count = (Integer) session.createQuery("select count(*) from Target").uniqueResult();
        str += "total number of targets: " + count + "<BR/>";


        session.getTransaction().commit();

View Full Code Here

      Session session = getSynchro().getSessionFactory().getCurrentSession();
      session.beginTransaction();
      try {
        Integer count = (Integer) session.createQuery("select count(*) from EventGeneric").uniqueResult();
        str += "total number of events: " + count + "<BR/>";
        count = (Integer) session.createQuery("select count(*) from Target").uniqueResult();
        str += "total number of targets: " + count + "<BR/>";


        session.getTransaction().commit();


        appendConsole(str);

View Full Code Here

          "<TD bgcolor='lightyellow' align='right'><B>" + htmlFace("events") + "</B></TD></TR>";
          for (final VisualElement elt : visual_transient.getSubElements(Target.class)) {
            final Target target = (Target) elt;
            session.update(target);
            for (final String event_type : target.getEventLists().keySet()) {
              final Integer count = (Integer) session.createQuery("select count(*) from EventGeneric ev " +
                  "where ev.eventList = :event_list")
                  .setString("event_list", target.getEventLists().get(event_type).getId().toString()).uniqueResult();


              str += "<TR><TD bgcolor='lightyellow' align='left'>"
                + htmlFace((TargetInterface.class.isInstance(target) ? target.getParents().get(0).getItem() + ": " : "") + target.getItem()) +

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.