@Deprecated @Override @SuppressWarnings({"rawtypes", "deprecation"}) public Iterator<?> iterate(final String queryString, @Nullable final Object... values) throws DataAccessException { return nonNull(executeWithNativeSession((HibernateCallback<Iterator<?>>) session -> { org.hibernate.Query queryObject = queryObject( ReflectionUtils.invokeMethod(createQueryMethod, session, queryString)); prepareQuery(queryObject); if (values != null) { for (int i = 0; i < values.length; i++) { queryObject.setParameter(i, values[i]); } } return queryObject.iterate(); })); }
@Deprecated @Override @SuppressWarnings({"rawtypes", "deprecation"}) public Iterator<?> iterate(final String queryString, @Nullable final Object... values) throws DataAccessException { return nonNull(executeWithNativeSession((HibernateCallback<Iterator<?>>) session -> { org.hibernate.Query queryObject = queryObject( ReflectionUtils.invokeMethod(createQueryMethod, session, queryString)); prepareQuery(queryObject); if (values != null) { for (int i = 0; i < values.length; i++) { queryObject.setParameter(i, values[i]); } } return queryObject.iterate(); })); }
public SyntaxChecker checkIterate() { Session s = openSession(); s.beginTransaction(); Query query = s.createQuery( hql ); preparer.prepare( query ); query.iterate(); s.getTransaction().commit(); s.close(); return this; } }
Query query = s.createQuery("from DataPoint dp order by dp.x asc"); s.setDefaultReadOnly( true ); Iterator it = query.iterate(); s.setDefaultReadOnly( false ); while ( it.hasNext() ) {
q.setString( 0, "Simple 1" ); q.setFirstResult(0); assertTrue( q.iterate().hasNext() ); q = s.createQuery("from Simple s where s.name = :foo and upper(s.name) = :bar or s.count=:count or s.count=:count + 1"); q.setParameter( "bar", "SIMPLE 1" ); q.setInteger("count", 69); q.setFirstResult(0); assertTrue( q.iterate().hasNext() ); q = s.createQuery("select s.id from Simple s"); q.setFirstResult(1); q.setMaxResults( 2 ); iter = q.iterate(); int i=0; while ( iter.hasNext() ) {
assertEquals( ( (ManyToOneType) type ).getAssociatedEntityName(), "org.hibernate.test.hql.Zoo" ); zoo = (Zoo) q .iterate().next(); assertEquals( zoo.getMammals().size(), 1 ); assertEquals( zoo.getAnimals().size(), 1 );
q.setString(0, "Simple 1"); q.setFirstResult(0); assertTrue( q.iterate().hasNext() ); q = s.createQuery("from Simple s where s.name = :foo and upper(s.name) = :bar or s.count=:count or s.count=:count + 1"); q.setParameter("bar", "SIMPLE 1"); q.setInteger("count", 69); q.setFirstResult(0); assertTrue( q.iterate().hasNext() ); q = s.createQuery("select s.id from Simple s"); q.setFirstResult(1); q.setMaxResults(2); iter = q.iterate(); int i=0; while ( iter.hasNext() ) {
assertTrue( q.iterate().hasNext() ); assertTrue( s.createFilter( master.getIncoming(), "where this.id > -1 and this.name is not null" ).list().size()==0 ); assertTrue( s.createFilter( master.getDetails(), "select max(this.i)" ).iterate().next() instanceof Integer ); assertTrue( s.createFilter( master.getDetails(), "select max(this.i) group by this.id" ).iterate().next() instanceof Integer ); assertTrue( s.createFilter( master.getDetails(), "select count(*)" ).iterate().next() instanceof Long ); f.setInteger("top", 100); f.setInteger("bottom", 0); assertEquals( f.iterate().next(), new Integer(12) ); f.setInteger("top", 2); assertEquals( f.iterate().next(), new Integer(0) ); coll.add( new Integer(0) ); f.setParameterList("list", coll); assertEquals( f.iterate().next(), new Integer(12) ); assertEquals( f.iterate().next(), new Integer(12) );
getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).iterate(); fail("'select new' together with a resulttransformer should result in error!");
s.setDefaultReadOnly( false ); assertFalse( s.isDefaultReadOnly() ); Iterator it = query.iterate(); assertTrue( query.isReadOnly() ); DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class, dp.getId() );
s.setDefaultReadOnly( true ); assertTrue( s.isDefaultReadOnly() ); Iterator it = query.iterate(); assertFalse( query.isReadOnly() ); DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class, dp.getId() );
@Override public Iterator<T> iterator() { return new CloseableIterator<T>((HibernateIterator) query.iterate()); } }
public Iterator<Interaction> getInteractionsForExperimentWithAcIterator( String ac ) { Query query = getSession().createQuery("from InteractionImpl as interaction left join interaction.experiments as exp where exp.ac = :ac"); query.setParameter("ac", ac); return query.iterate(); }
public long getCount(String procedure) { LOGGER.debug("getCount({})", procedure); Session currentSession = getCurrentSession(); Query query = currentSession.createQuery("select count(*) from SensorConfiguration"); return ((Long) query.iterate().next()).longValue(); }
public boolean isEmpty(final String courseSetEid) { HibernateCallback hc = session -> { Query q = session.getNamedQuery("findNonEmptyCourseSet"); q.setParameter("eid", courseSetEid); return Boolean.valueOf( ! q.iterate().hasNext()); }; return ((Boolean)getHibernateTemplate().execute(hc)).booleanValue(); }
public boolean isEnrolled(final String userId, final Set<String> enrollmentSetEids) { HibernateCallback hc = session -> { Query q = session.getNamedQuery("countEnrollments"); q.setParameter("userId", userId); q.setParameterList("enrollmentSetEids", enrollmentSetEids); return q.iterate().next(); }; int i = ((Number)getHibernateTemplate().execute(hc)).intValue(); if(log.isDebugEnabled()) log.debug(userId + " is enrolled in " + i + " of these " + enrollmentSetEids.size() + " EnrollmentSets" ); return i > 0; }
@Transactional(propagation = Propagation.MANDATORY) public Iterator<T> getByShortLabelLikeIterator(String value, boolean ignoreCase) { Query query; if (ignoreCase) { query = getEntityManager().createQuery("from " + getEntityClass().getSimpleName() + " where lower(shortlabel) = lower(:label)"); } else { query = getEntityManager().createQuery("from " + getEntityClass().getSimpleName() + " where shortlabel = :label"); } query.setParameter("label", value); return ((HibernateQuery) query).getHibernateQuery().iterate(); }
@Override public List<LabelImpl> getUserCustomLabels(final String ownerName) { final List<LabelImpl> result = new ArrayList<LabelImpl>(); final Query query = getSession().getNamedQuery("getUserCustomLabels"); query.setString("ownerName", ownerName); CollectionUtils.addAll(result, query.iterate()); return result; }
@Override public Set<TaskInstance> getUserTasks(final String userId, final Collection<ActivityState> taskStates) { final Query query = getSession().getNamedQuery("getUserTasksWithStates"); query.setString("userId", userId); query.setParameterList("states", taskStates, ACTIVITY_STATE_USER_TYPE); final Set<TaskInstance> result = new HashSet<TaskInstance>(); CollectionUtils.addAll(result, query.iterate()); return result; }
@Override public Set<IncomingEventInstance> getIncomingEvents(final ActivityInstanceUUID activityUUID) { final Set<IncomingEventInstance> result = new HashSet<IncomingEventInstance>(); final Query query = getSession().getNamedQuery("getActivityInstanceIncomingEvents"); query.setString("activityUUID", activityUUID.getValue()); CollectionUtils.addAll(result, query.iterate()); return result; }