@Override public Query getQuery(Session s) { return s.createQuery( "from Student s left join s.preferredCourse p left join s.addresses a order by s.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select e.student as student, e.semester as semester, e.year as year, e.course as course from Enrolment e order by e.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select s as s, pc as pc from Student s left join s.preferredCourse pc left join fetch s.enrolments order by s.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select e.student as student from Enrolment e order by e.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select min( e.studentNumber ) as minStudentNumber, max( e.studentNumber ) as maxStudentNumber from Enrolment e" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select e.student as student, e.semester, e.year, e.course as course from Enrolment e order by e.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
@Override public Query getQuery(Session s) { return s.createQuery( "from Student s left join s.enrolments e left join e.course c order by s.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
@Override public Query getQuery(Session s) { return s.createQuery( "from Student s left join s.addresses a left join s.preferredCourse order by s.studentNumber" ) .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); } };
public Query getQuery(Session s) { return s.createQuery( "select st.name as studentName, co.description as courseDescription from Enrolment e join e.student st join e.course co order by e.studentNumber" ) .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); } };
public Query getQuery(Session s) { return s.createQuery( "select st.name as studentName, 'lame description' as courseDescription from Enrolment e join e.student st join e.course co order by e.studentNumber" ) .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); } };
public Query getQuery(Session s) { return s.createQuery( "select st.name as studentName, co.description as courseDescription from Enrolment e join e.student st join e.course co order by e.studentNumber" ) .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); } };
public Query getQuery(Session s) { return s.createQuery( "select st.name as studentName from Student st order by st.studentNumber" ) .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); } };
@Test public void testNoScroll() { Session s = openSession(); s.beginTransaction(); List list = s.createQuery( QUERY ).setResultTransformer( DistinctRootEntityResultTransformer.INSTANCE ).list(); assertResultFromAllUsers( list ); s.getTransaction().commit(); s.close(); }
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list(); assertEquals( "Incorrect result size", results.size(), 2 ); assertTrue( "Incorrect return type", results.get(0) instanceof Map ); .setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).iterate(); assertTrue( "Incorrect result size", iter.hasNext() ); map = (Map) iter.next(); .setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).scroll();
.setResultTransformer(Transformers.aliasToBean(Animal.class)).list(); t = session.beginTransaction(); Iterator iter = session.createQuery( query ) .setResultTransformer(Transformers.aliasToBean(Animal.class)).iterate(); assertTrue( "Incorrect result size", iter.hasNext() ); assertTrue( "Incorrect return type", iter.next() instanceof Animal ); .setResultTransformer(Transformers.aliasToBean(Animal.class)).scroll(); .setResultTransformer( DistinctRootEntityResultTransformer.INSTANCE ) .list(); assertEquals( "Incorrect result size", 2, results.size());
assertTrue( result.contains( "JBoss" ) ); result = s.getNamedQuery( "orgNamesOnly" ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list(); Map m = (Map) result.get(0); assertEquals( 2, result.size() );
@Override public <DTO> List<DTO> listSQL(String sql, Class<DTO> otoclass) { List<DTO> result = null; Query query = getSessionFactory().getCurrentSession().createNativeQuery(sql); query.setResultTransformer(Transformers.aliasToBean(otoclass)); result = query.list(); return result; }
@Override public <DTO> List<DTO> listSQL(String sql, Class<DTO> otoclass) { List<DTO> result = null; Query query = getSessionFactory().getCurrentSession().createNativeQuery(sql); query.setResultTransformer(Transformers.aliasToBean(otoclass)); result = query.list(); return result; }
@Override public <DTO> List<DTO> listSQL(String sql, Integer stat, Integer max, Class<DTO> otoclass) { List<DTO> result = null; Query query = getSessionFactory().getCurrentSession().createNativeQuery(sql); query.setResultTransformer(Transformers.aliasToBean(otoclass)); query.setFirstResult(stat); query.setMaxResults(max); result = query.list(); return result; }
@Override public <DTO> List<DTO> listSQL(String sql, Integer stat, Integer max, Class<DTO> otoclass) { List<DTO> result = null; Query query = getSessionFactory().getCurrentSession().createNativeQuery(sql); query.setResultTransformer(Transformers.aliasToBean(otoclass)); query.setFirstResult(stat); query.setMaxResults(max); result = query.list(); return result; }