Author: gbadner Date: 2010-07-28 14:55:13 -0400 (Wed, 28 Jul 2010) New Revision: 20074 Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/AbstractQueryCacheResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Address.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Course.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeeting.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeetingId.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheIgnoreResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheNormalResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCachePutResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.hbm.xml core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheIgnoreResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheNormalResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCachePutResultTransformerTest.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/PersonName.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Student.java core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/StudentDTO.java Modified: core/trunk/core/src/main/java/org/hibernate/cache/QueryKey.java core/trunk/core/src/main/java/org/hibernate/loader/Loader.java Log: HHH-5163 : added logging and test cases for ClassCastException when caching transformed query results Modified: core/trunk/core/src/main/java/org/hibernate/cache/QueryKey.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/cache/QueryKey.java 2010-07-27 16:17:42 UTC (rev 20073) +++ core/trunk/core/src/main/java/org/hibernate/cache/QueryKey.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -173,6 +173,10 @@ this.hashCode = generateHashCode(); } + public ResultTransformer getResultTransformer() { + return customTransformer; + } + /** * Deserialization hook used to re-init the cached hashcode which is needed for proper clustering support. * Modified: core/trunk/core/src/main/java/org/hibernate/loader/Loader.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/loader/Loader.java 2010-07-27 16:17:42 UTC (rev 20073) +++ core/trunk/core/src/main/java/org/hibernate/loader/Loader.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -2275,6 +2275,13 @@ session ); + if ( querySpaces == null || querySpaces.size() == 0 ) { + log.trace( "unexpected querySpaces is "+( querySpaces == null ? "null" : "empty" ) ); + } + else { + log.trace( "querySpaces is "+querySpaces.toString() ); + } + List result = getResultFromQueryCache( session, queryParameters, @@ -2327,6 +2334,11 @@ } try { result = queryCache.get( key, resultTypes, isImmutableNaturalKeyLookup, querySpaces, session ); + logCachedResultDetails( + key.getResultTransformer(), + resultTypes, + result + ); } finally { persistenceContext.setDefaultReadOnly( defaultReadOnlyOrig ); @@ -2355,6 +2367,13 @@ final QueryKey key, final List result) { if ( session.getCacheMode().isPutEnabled() ) { + if ( log.isTraceEnabled() ) { + logCachedResultDetails( + key.getResultTransformer(), + resultTypes, + result + ); + } boolean put = queryCache.put( key, resultTypes, result, queryParameters.isNaturalKeyLookup(), session ); if ( put && factory.getStatistics().isStatisticsEnabled() ) { factory.getStatisticsImplementor() @@ -2363,6 +2382,86 @@ } } + + private void logCachedResultDetails(ResultTransformer resultTransformer, Type[] returnTypes, List result) { + if ( ! log.isTraceEnabled() ) { + return; + } + if ( returnTypes == null || returnTypes.length == 0 ) { + log.trace( "unexpected returnTypes is "+( returnTypes == null ? "null" : "empty" )+ + "! transformer="+( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " result"+( result == null ? " is null": ".size()=" + result.size() ) ); + } + else { + StringBuffer returnTypeNames = new StringBuffer(); + StringBuffer returnClassNames = new StringBuffer(); + for ( int i=0; i<returnTypes.length; i++ ) { + returnTypeNames.append( returnTypes[ i ].getName() ).append(' '); + returnClassNames.append( returnTypes[ i ].getReturnedClass() ).append(' '); + } + log.trace( "transformer="+( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " returnTypes=[ "+returnTypeNames+"]"+" returnClasses=[ "+returnClassNames+"]" ); + } + if ( result != null && result.size() != 0 ) { + for ( Iterator it = result.iterator(); it.hasNext(); ) { + Object value = it.next(); + if ( value == null ) { + log.trace( "transformer="+( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " value is null; returnTypes is "+( returnTypes == null ? "null" : "Type["+returnTypes.length+"]" ) ); + if ( returnTypes != null && returnTypes.length > 1 ) { + log.trace( "unexpected result value! "+ + "transformer="+( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + "value is null; should be Object["+returnTypes.length+"]!" ); + } + } + else { + if ( returnTypes == null || returnTypes.length == 0 ) { + log.trace( "unexpected result value! "+ + "transformer="+( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + "value is non-null; returnTypes is "+( returnTypes == null ? "null" : "empty" ) ); + } + else if ( Object[].class.isInstance( value ) ) { + Object[] tuple = ( Object[] ) value; + log.trace( "transformer="+( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " value is Object["+tuple.length+ + "]; returnTypes is Type["+returnTypes.length+"]" ); + if ( tuple.length != returnTypes.length ) { + log.trace( "unexpected tuple length! transformer="+ + ( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " expected="+returnTypes.length+ + " got="+tuple.length ); + } + else { + for ( int j = 0; j < tuple.length; j++ ) { + if ( tuple[ j ] != null && ! returnTypes[ j ].getReturnedClass().isInstance( tuple[ j ] ) ) { + log.trace( "unexpected tuple value type! transformer="+ + ( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " expected="+returnTypes[ j ].getReturnedClass().getName()+ + " got="+tuple[ j ].getClass().getName() ); + } + } + } + } + else { + if ( returnTypes.length != 1 ) { + log.trace( "unexpected number of result columns! should be Object["+returnTypes.length+"]! transformer="+ + ( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " value type="+value.getClass().getName()+ + " returnTypes is Type["+returnTypes.length+"]" ); + } + else if ( ! returnTypes[ 0 ].getReturnedClass().isInstance( value ) ) { + log.trace( "unexpected value type! transformer="+ + ( resultTransformer == null ? "null" : resultTransformer.getClass().getName() )+ + " expected="+returnTypes[ 0 ].getReturnedClass().getName()+ + " got="+ value.getClass().getName() ); + } + } + } + } + } + } + + /** * Actually execute a query, ignoring the query cache */ Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/AbstractQueryCacheResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/AbstractQueryCacheResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/AbstractQueryCacheResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,2170 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import java.lang.reflect.Constructor; +import java.util.ArrayList; +import java.util.Iterator; +import java.util.List; +import java.util.Map; + +import org.hibernate.CacheMode; +import org.hibernate.Criteria; +import org.hibernate.FetchMode; +import org.hibernate.Hibernate; +import org.hibernate.Query; +import org.hibernate.Session; +import org.hibernate.Transaction; +import org.hibernate.cfg.Configuration; +import org.hibernate.cfg.Environment; +import org.hibernate.criterion.Order; +import org.hibernate.criterion.Projections; +import org.hibernate.criterion.Property; +import org.hibernate.criterion.Restrictions; +import org.hibernate.impl.SessionFactoryImpl; +import org.hibernate.testing.junit.functional.FunctionalTestCase; +import org.hibernate.proxy.HibernateProxy; +import org.hibernate.transform.AliasToBeanConstructorResultTransformer; +import org.hibernate.transform.Transformers; +import org.hibernate.type.Type; +import org.hibernate.util.ReflectHelper; + +/** + * @author Gail Badner + */ +public abstract class AbstractQueryCacheResultTransformerTest extends FunctionalTestCase { + + private Student yogiExpected; + private Student shermanExpected; + private CourseMeeting courseMeetingExpected1; + private CourseMeeting courseMeetingExpected2; + private Course courseExpected; + private Enrolment yogiEnrolmentExpected; + private Enrolment shermanEnrolmentExpected; + + public AbstractQueryCacheResultTransformerTest(String str) { + super( str ); + } + + public String[] getMappings() { + return new String[] { "querycache/Enrolment.hbm.xml" }; + } + + public void configure(Configuration cfg) { + super.configure( cfg ); + cfg.setProperty( Environment.USE_QUERY_CACHE, "true" ); + cfg.setProperty( Environment.CACHE_REGION_PREFIX, "foo" ); + cfg.setProperty( Environment.USE_SECOND_LEVEL_CACHE, "true" ); + cfg.setProperty( Environment.GENERATE_STATISTICS, "true" ); + } + + protected abstract class CriteriaExecutor extends QueryExecutor { + protected abstract Criteria getCriteria(Session s) throws Exception; + protected Object getResults(Session s, boolean isSingleResult) throws Exception { + Criteria criteria = getCriteria( s ).setCacheable( getQueryCacheMode() != CacheMode.IGNORE ).setCacheMode( getQueryCacheMode() ); + return ( isSingleResult ? criteria.uniqueResult() : criteria.list() ); + } + } + + protected abstract class HqlExecutor extends QueryExecutor { + protected abstract Query getQuery(Session s); + protected Object getResults(Session s, boolean isSingleResult) { + Query query = getQuery( s ).setCacheable( getQueryCacheMode() != CacheMode.IGNORE ).setCacheMode( getQueryCacheMode() ); + return ( isSingleResult ? query.uniqueResult() : query.list() ); + } + } + + protected abstract class QueryExecutor { + public Object execute(boolean isSingleResult) throws Exception{ + Session s = openSession(); + Transaction t = s.beginTransaction(); + Object result = getResults( s, isSingleResult ); + t.commit(); + s.close(); + return result; + } + protected abstract Object getResults(Session s, boolean isSingleResult) throws Exception; + } + + protected interface ResultChecker { + void check(Object results); + } + + protected abstract CacheMode getQueryCacheMode(); + + protected boolean areDynamicNonLazyAssociationsChecked() { + return true; + } + + protected void createData() { + Session s = openSession(); + Transaction t = s.beginTransaction(); + + courseExpected = new Course(); + courseExpected.setCourseCode( "HIB" ); + courseExpected.setDescription( "Hibernate Training" ); + courseMeetingExpected1 = new CourseMeeting( courseExpected, "Monday", 1, "1313 Mockingbird Lane" ); + courseMeetingExpected2 = new CourseMeeting( courseExpected, "Tuesday", 2, "1313 Mockingbird Lane" ); + courseExpected.getCourseMeetings().add( courseMeetingExpected1 ); + courseExpected.getCourseMeetings().add( courseMeetingExpected2 ); + s.save( courseExpected ); + + yogiExpected = new Student(); + yogiExpected.setName( new PersonName( "Yogi", "The", "Bear" ) ); + yogiExpected.setStudentNumber( 111 ); + yogiExpected.setPreferredCourse( courseExpected ); + List yogiSecretCodes = new ArrayList(); + yogiSecretCodes.add( Integer.valueOf( 0 ) ); + yogiExpected.setSecretCodes( yogiSecretCodes ); + s.save( yogiExpected ); + + Address address1 = new Address( yogiExpected, "home", "1 Main Street", "Podunk", "WA", "98000", "USA" ); + Address address2 = new Address( yogiExpected, "work", "2 Main Street", "NotPodunk", "WA", "98001", "USA" ); + yogiExpected.getAddresses().put( address1.getAddressType(), address1 ); + yogiExpected.getAddresses().put( address2.getAddressType(), address2 ); + s.save( address1 ); + s.save( address2 ); + + shermanExpected = new Student(); + shermanExpected.setName( new PersonName( "Sherman", null, "Grote" ) ); + shermanExpected.setStudentNumber( 999 ); + List shermanSecretCodes = new ArrayList(); + shermanSecretCodes.add( Integer.valueOf( 1 ) ); + shermanSecretCodes.add( Integer.valueOf( 2 ) ); + shermanExpected.setSecretCodes( shermanSecretCodes ); + s.save( shermanExpected ); + + shermanEnrolmentExpected = new Enrolment(); + shermanEnrolmentExpected.setCourse( courseExpected ); + shermanEnrolmentExpected.setCourseCode( courseExpected.getCourseCode() ); + shermanEnrolmentExpected.setSemester( ( short ) 1 ); + shermanEnrolmentExpected.setYear( ( short ) 1999 ); + shermanEnrolmentExpected.setStudent( shermanExpected ); + shermanEnrolmentExpected.setStudentNumber( shermanExpected.getStudentNumber() ); + shermanExpected.getEnrolments().add( shermanEnrolmentExpected ); + s.save( shermanEnrolmentExpected ); + + yogiEnrolmentExpected = new Enrolment(); + yogiEnrolmentExpected.setCourse( courseExpected ); + yogiEnrolmentExpected.setCourseCode( courseExpected.getCourseCode() ); + yogiEnrolmentExpected.setSemester( ( short ) 3 ); + yogiEnrolmentExpected.setYear( ( short ) 1998 ); + yogiEnrolmentExpected.setStudent( yogiExpected ); + yogiEnrolmentExpected.setStudentNumber( yogiExpected.getStudentNumber() ); + yogiExpected.getEnrolments().add( yogiEnrolmentExpected ); + s.save( yogiEnrolmentExpected ); + + t.commit(); + s.close(); + } + + protected void deleteData() { + Session s = openSession(); + Transaction t = s.beginTransaction(); +/* + List students = s.createQuery( "from Student" ).list(); + for ( Iterator it = students.iterator(); it.hasNext(); ) { + s.delete( it.next() ); + } + s.createQuery( "delete from Enrolment" ).executeUpdate(); + s.createQuery( "delete from CourseMeeting" ).executeUpdate(); + s.createQuery( "delete from Course" ).executeUpdate(); +*/ + s.delete( yogiExpected ); + s.delete( shermanExpected ); + s.delete( yogiEnrolmentExpected ); + s.delete( shermanEnrolmentExpected ); + s.delete( courseMeetingExpected1 ); + s.delete( courseMeetingExpected2 ); + s.delete( courseExpected ); + t.commit(); + s.close(); + } + + public void testEntityWithNonLazyOneToManyUnique() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Course.class ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Course" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Course ); + assertEquals( courseExpected, results ); + assertTrue( Hibernate.isInitialized( ( ( Course ) courseExpected ).getCourseMeetings() ) ); + assertEquals( courseExpected.getCourseMeetings(), ( ( Course ) courseExpected ).getCourseMeetings() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testEntityWithNonLazyManyToOneList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( CourseMeeting.class ) + .addOrder( Order.asc( "id.day") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + protected Query getQuery(Session s) { + return s.createQuery( "from CourseMeeting order by id.day" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( courseMeetingExpected1, resultList.get( 0 ) ); + assertEquals( courseMeetingExpected2, resultList.get( 1 ) ); + assertTrue( Hibernate.isInitialized( ( ( CourseMeeting ) resultList.get( 0 ) ).getCourse() ) ); + assertTrue( Hibernate.isInitialized( ( ( CourseMeeting ) resultList.get( 1 ) ).getCourse() ) ); + assertEquals( courseExpected, ( ( CourseMeeting ) resultList.get( 0 ) ).getCourse() ); + assertEquals( courseExpected, ( ( CourseMeeting ) resultList.get( 1 ) ).getCourse() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testEntityWithLazyAssnUnique() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .add( Restrictions.eq( "studentNumber", shermanExpected.getStudentNumber() ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s where s.studentNumber = :studentNumber" ) + .setParameter( "studentNumber", shermanExpected.getStudentNumber() ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Student ); + assertEquals( shermanExpected, results ); + assertFalse( Hibernate.isInitialized( ( ( Student ) results ).getEnrolments() ) ); + assertNull( ( ( Student ) results ).getPreferredCourse() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + // should use RootEntityTransformer by default + public void testEntityWithLazyAssnList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class ) + .addOrder( Order.asc( "studentNumber") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student order by studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertEquals( shermanExpected, resultList.get( 1 ) ); + assertFalse( Hibernate.isInitialized( ( ( Student ) resultList.get( 0 ) ).getEnrolments() ) ); + assertFalse( Hibernate.isInitialized( ( ( Student ) resultList.get( 0 ) ).getPreferredCourse() ) ); + assertFalse( Hibernate.isInitialized( ( ( Student ) resultList.get( 1 ) ).getEnrolments() ) ); + assertNull( ( ( Student ) resultList.get( 1 ) ).getPreferredCourse() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testEntityWithJoinFetchedLazyOneToManySingleElementList() throws Exception { + // unaliased + CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .setFetchMode( "enrolments", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutorUnaliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join fetch s.enrolments order by s.studentNumber" ); + } + }; + + // aliased + CriteriaExecutor criteriaExecutorAliased1 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .setFetchMode( "enrolments", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased2 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .setFetchMode( "e", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased3 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .setFetchMode( "enrolments", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased4 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .setFetchMode( "e", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutorAliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join fetch s.enrolments e order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertEquals( shermanExpected, resultList.get( 1 ) ); + if ( areDynamicNonLazyAssociationsChecked() ) { + assertTrue( Hibernate.isInitialized( ( ( Student ) resultList.get( 0 ) ).getEnrolments() ) ); + assertEquals( yogiExpected.getEnrolments(), ( ( Student ) resultList.get( 0 ) ).getEnrolments() ); + assertTrue( Hibernate.isInitialized( ( ( Student ) resultList.get( 1 ) ).getEnrolments() ) ); + assertEquals( shermanExpected.getEnrolments(), ( ( Student ) resultList.get( 1 ) ).getEnrolments() ); + } + } + }; + + runTest( hqlExecutorUnaliased, criteriaExecutorUnaliased, checker, false); + runTest( hqlExecutorAliased, criteriaExecutorAliased1, checker, false); + runTest( null, criteriaExecutorAliased2, checker, false); + runTest( null, criteriaExecutorAliased3, checker, false); + runTest( null, criteriaExecutorAliased4, checker, false); + + } + + public void testEntityWithJoinFetchedLazyOneToManyMultiAndNullElementList() throws Exception { + //unaliased + CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .setFetchMode( "addresses", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutorUnaliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join fetch s.addresses order by s.studentNumber" ); + } + }; + + //aliased + CriteriaExecutor criteriaExecutorAliased1 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a", Criteria.LEFT_JOIN ) + .setFetchMode( "addresses", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased2 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a", Criteria.LEFT_JOIN ) + .setFetchMode( "a", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased3 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.addresses", "a", Criteria.LEFT_JOIN ) + .setFetchMode( "addresses", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased4 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.addresses", "a", Criteria.LEFT_JOIN ) + .setFetchMode( "a", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutorAliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join fetch s.addresses a order by s.studentNumber" ); + } + }; + + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 3, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertSame( resultList.get( 0 ), resultList.get( 1 ) ); + assertEquals( shermanExpected, resultList.get( 2 ) ); + if ( areDynamicNonLazyAssociationsChecked() ) { + assertTrue( Hibernate.isInitialized( ( ( Student ) resultList.get( 0 ) ).getAddresses() ) ); + assertEquals( yogiExpected.getAddresses(), ( ( Student ) resultList.get( 0 ) ).getAddresses() ); + assertTrue( ( ( Student ) resultList.get( 2 ) ).getAddresses().isEmpty() ); + } + } + }; + runTest( hqlExecutorUnaliased, criteriaExecutorUnaliased, checker, false ); + runTest( hqlExecutorAliased, criteriaExecutorAliased1, checker, false ); + runTest( null, criteriaExecutorAliased2, checker, false ); + runTest( null, criteriaExecutorAliased3, checker, false ); + runTest( null, criteriaExecutorAliased4, checker, false ); + } + + public void testEntityWithJoinFetchedLazyManyToOneList() throws Exception { + // unaliased + CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .setFetchMode( "preferredCourse", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutorUnaliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join fetch s.preferredCourse order by s.studentNumber" ); + } + }; + + // aliased + CriteriaExecutor criteriaExecutorAliased1 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.preferredCourse", "pCourse", Criteria.LEFT_JOIN ) + .setFetchMode( "preferredCourse", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased2 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.preferredCourse", "pCourse", Criteria.LEFT_JOIN ) + .setFetchMode( "pCourse", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased3 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.preferredCourse", "pCourse", Criteria.LEFT_JOIN ) + .setFetchMode( "preferredCourse", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased4 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.preferredCourse", "pCourse", Criteria.LEFT_JOIN ) + .setFetchMode( "pCourse", FetchMode.JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutorAliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join fetch s.preferredCourse pCourse order by s.studentNumber" ); + } + }; + + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertEquals( shermanExpected, resultList.get( 1 ) ); + assertEquals( yogiExpected.getPreferredCourse().getCourseCode(), + ( ( Student ) resultList.get( 0 ) ).getPreferredCourse().getCourseCode() ); + assertNull( ( ( Student ) resultList.get( 1 ) ).getPreferredCourse() ); + } + }; + runTest( hqlExecutorUnaliased, criteriaExecutorUnaliased, checker, false ); + runTest( hqlExecutorAliased, criteriaExecutorAliased1, checker, false ); + runTest( null, criteriaExecutorAliased2, checker, false ); + runTest( null, criteriaExecutorAliased3, checker, false ); + runTest( null, criteriaExecutorAliased4, checker, false ); + } + + public void testEntityWithJoinedLazyOneToManySingleElementListCriteria() throws Exception { + CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.enrolments", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased1 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased2 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertEquals( shermanExpected, resultList.get( 1 ) ); + if ( areDynamicNonLazyAssociationsChecked() ) { + assertTrue( Hibernate.isInitialized( ( ( Student ) resultList.get( 0 ) ).getEnrolments() ) ); + assertEquals( yogiExpected.getEnrolments(), ( ( Student ) resultList.get( 0 ) ).getEnrolments() ); + assertTrue( Hibernate.isInitialized( ( ( Student ) resultList.get( 1 ) ).getEnrolments() ) ); + assertEquals( shermanExpected.getEnrolments(), ( ( Student ) resultList.get( 1 ) ).getEnrolments() ); + } + } + }; + runTest( null, criteriaExecutorUnaliased, checker, false ); + runTest( null, criteriaExecutorAliased1, checker, false ); + runTest( null, criteriaExecutorAliased2, checker, false ); + } + + public void testEntityWithJoinedLazyOneToManyMultiAndNullListCriteria() throws Exception { + CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.addresses", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased1 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.addresses", "a", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased2 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 3, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertSame( resultList.get( 0 ), resultList.get( 1 ) ); + assertEquals( shermanExpected, resultList.get( 2 ) ); + if ( areDynamicNonLazyAssociationsChecked() ) { + assertTrue( Hibernate.isInitialized( ( ( Student ) resultList.get( 0 ) ).getAddresses() ) ); + assertEquals( yogiExpected.getAddresses(), ( ( Student ) resultList.get( 0 ) ).getAddresses() ); + assertTrue( ( ( Student ) resultList.get( 2 ) ).getAddresses().isEmpty() ); + } + } + }; + runTest( null, criteriaExecutorUnaliased, checker, false ); + runTest( null, criteriaExecutorAliased1, checker, false ); + runTest( null, criteriaExecutorAliased2, checker, false ); + } + + public void testEntityWithJoinedLazyManyToOneListCriteria() throws Exception { + CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.preferredCourse", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased1 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.preferredCourse", "p", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + CriteriaExecutor criteriaExecutorAliased2 = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use RootEntityTransformer by default + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.preferredCourse", "p", Criteria.LEFT_JOIN ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( yogiExpected, resultList.get( 0 ) ); + assertEquals( shermanExpected, resultList.get( 1 ) ); + assertEquals( yogiExpected.getPreferredCourse().getCourseCode(), + ( ( Student ) resultList.get( 0 ) ).getPreferredCourse().getCourseCode() ); + assertNull( ( ( Student ) resultList.get( 1 ) ).getPreferredCourse() ); + } + }; + runTest( null, criteriaExecutorUnaliased, checker, false ); + runTest( null, criteriaExecutorAliased1, checker, false ); + runTest( null, criteriaExecutorAliased2, checker, false ); + } + + public void testEntityWithJoinedLazyOneToManySingleElementListHql() throws Exception { + HqlExecutor hqlExecutorUnaliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join s.enrolments order by s.studentNumber" ); + } + }; + HqlExecutor hqlExecutorAliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join s.enrolments e order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertTrue( resultList.get( 0 ) instanceof Object[] ); + Object[] yogiObjects = ( Object[] ) resultList.get( 0 ); + assertEquals( yogiExpected, yogiObjects[ 0 ] ); + assertEquals( yogiEnrolmentExpected, yogiObjects[ 1 ] ); + assertTrue( resultList.get( 0 ) instanceof Object[] ); + Object[] shermanObjects = ( Object[] ) resultList.get( 1 ); + assertEquals( shermanExpected, shermanObjects[ 0 ] ); + assertEquals( shermanEnrolmentExpected, shermanObjects[ 1 ] ); + } + }; + runTest( hqlExecutorUnaliased, null, checker, false ); + runTest( hqlExecutorAliased, null, checker, false ); + } + + public void testEntityWithJoinedLazyOneToManyMultiAndNullListHql() throws Exception { + HqlExecutor hqlExecutorUnaliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join s.addresses order by s.studentNumber" ); + } + }; + HqlExecutor hqlExecutorAliased = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "from Student s left join s.addresses a order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 3, resultList.size() ); + assertTrue( resultList.get( 0 ) instanceof Object[] ); + Object[] yogiObjects1 = ( Object[] ) resultList.get( 0 ); + assertEquals( yogiExpected, yogiObjects1[ 0 ] ); + Address address1 = ( Address ) yogiObjects1[ 1 ]; + assertEquals( yogiExpected.getAddresses().get( address1.getAddressType() ), address1 ); + Object[] yogiObjects2 = ( Object[] ) resultList.get( 1 ); + assertSame( yogiObjects1[ 0 ], yogiObjects2[ 0 ] ); + Address address2 = ( Address ) yogiObjects2[ 1 ]; + assertEquals( yogiExpected.getAddresses().get( address2.getAddressType() ), address2 ); + assertFalse( address1.getAddressType().equals( address2.getAddressType() ) ); + Object[] shermanObjects = ( Object[] ) resultList.get( 2 ); + assertEquals( shermanExpected, shermanObjects[ 0 ] ); + assertNull( shermanObjects[ 1 ] ); + } + }; + runTest( hqlExecutorUnaliased, null, checker, false ); + runTest( hqlExecutorAliased, null, checker, false ); + } + + public void testEntityWithJoinedLazyManyToOneListHql() throws Exception { + HqlExecutor hqlExecutorUnaliased = new HqlExecutor() { + protected Query getQuery(Session s) { + // should use RootEntityTransformer by default + return s.createQuery( "from Student s left join s.preferredCourse order by s.studentNumber" ); + } + }; + HqlExecutor hqlExecutorAliased = new HqlExecutor() { + protected Query getQuery(Session s) { + // should use RootEntityTransformer by default + return s.createQuery( "from Student s left join s.preferredCourse p order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Object[] yogiObjects = ( Object[] ) resultList.get( 0 ); + assertEquals( yogiExpected, yogiObjects[ 0 ] ); + assertEquals( yogiExpected.getPreferredCourse(), yogiObjects[ 1 ] ); + Object[] shermanObjects = ( Object[] ) resultList.get( 1 ); + assertEquals( shermanExpected, shermanObjects[ 0 ] ); + assertNull( shermanObjects[ 1 ] ); + } + }; + runTest( hqlExecutorUnaliased, null, checker, false ); + runTest( hqlExecutorAliased, null, checker, false ); + } + + public void testAliasToEntityMapNoProjectionList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.enrolments", "e", Criteria.LEFT_JOIN ) + .createAlias( "e.course", "c", Criteria.LEFT_JOIN ) + .setResultTransformer( Criteria.ALIAS_TO_ENTITY_MAP ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Map yogiMap = ( Map ) resultList.get( 0 ); + assertEquals( 3, yogiMap.size() ); + Map shermanMap = ( Map ) resultList.get( 1 ); + assertEquals( 3, shermanMap.size() ); + assertEquals( yogiExpected, yogiMap.get( "s" ) ); + assertEquals( yogiEnrolmentExpected, yogiMap.get( "e" ) ); + assertEquals( courseExpected, yogiMap.get( "c" ) ); + assertEquals( shermanExpected, shermanMap.get( "s" ) ); + assertEquals( shermanEnrolmentExpected, shermanMap.get( "e" ) ); + assertEquals( courseExpected, shermanMap.get( "c" ) ); + assertSame( ( ( Map ) resultList.get( 0 ) ).get( "c" ), shermanMap.get( "c" ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToEntityMapNoProjectionMultiAndNullList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.preferredCourse", "p", Criteria.LEFT_JOIN ) + .createAlias( "s.addresses", "a", Criteria.LEFT_JOIN ) + .setResultTransformer( Criteria.ALIAS_TO_ENTITY_MAP ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 3, resultList.size() ); + Map yogiMap1 = ( Map ) resultList.get( 0 ); + assertEquals( 3, yogiMap1.size() ); + Map yogiMap2 = ( Map ) resultList.get( 1 ); + assertEquals( 3, yogiMap2.size() ); + Map shermanMap = ( Map ) resultList.get( 2 ); + assertEquals( 3, shermanMap.size() ); + assertEquals( yogiExpected, yogiMap1.get( "s" ) ); + assertEquals( courseExpected, yogiMap1.get( "p" ) ); + Address yogiAddress1 = ( Address ) yogiMap1.get( "a" ); + assertEquals( yogiExpected.getAddresses().get( yogiAddress1.getAddressType() ), + yogiMap1.get( "a" )); + assertEquals( yogiExpected, yogiMap2.get( "s" ) ); + assertEquals( courseExpected, yogiMap2.get( "p" ) ); + Address yogiAddress2 = ( Address ) yogiMap2.get( "a" ); + assertEquals( yogiExpected.getAddresses().get( yogiAddress2.getAddressType() ), + yogiMap2.get( "a" )); + assertSame( yogiMap1.get( "s" ), yogiMap2.get( "s" ) ); + assertSame( yogiMap1.get( "p" ), yogiMap2.get( "p" ) ); + assertFalse( yogiAddress1.getAddressType().equals( yogiAddress2.getAddressType() ) ); + assertEquals( shermanExpected, shermanMap.get( "s" ) ); + assertEquals( shermanExpected.getPreferredCourse(), shermanMap.get( "p" ) ); + assertNull( shermanMap.get( "a") ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToEntityMapOneProjectionList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( Projections.property( "e.student" ).as( "student" ) ) + .addOrder( Order.asc( "e.studentNumber") ) + .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Map yogiMap = ( Map ) resultList.get( 0 ); + Map shermanMap = ( Map ) resultList.get( 1 ); + assertEquals( 1, yogiMap.size() ); + //assertTrue( yogiMap[ 0 ] instanceof HibernateProxy ); + assertTrue( yogiMap.get( "student" ) instanceof Student ); + if( Hibernate.isInitialized( yogiMap.get( "student" ) ) ) { + assertEquals( yogiExpected, yogiMap.get( "student" ) ); + } + else { + assertEquals( yogiExpected.getStudentNumber(), ( ( Student ) yogiMap.get( "student" ) ).getStudentNumber() ); + } + assertEquals( 1, shermanMap.size() ); + //assertTrue( shermanMap[ 0 ] instanceof HibernateProxy ); + assertTrue( shermanMap.get( "student" ) instanceof Student ); + if( Hibernate.isInitialized( shermanMap.get( "student" ) ) ) { + assertEquals( shermanExpected, shermanMap.get( "student" ) ); + } + else { + assertEquals( shermanExpected.getStudentNumber(), ( ( Student ) shermanMap.get( "student" ) ).getStudentNumber() ); + } + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false); + } + + public void testAliasToEntityMapMultiProjectionList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "e.student" ), "student" ) + .add( Property.forName( "e.semester" ), "semester" ) + .add( Property.forName( "e.year" ), "year" ) + .add( Property.forName( "e.course" ), "course" ) + ) + .addOrder( Order.asc( "studentNumber") ) + .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Map yogiMap = ( Map ) resultList.get( 0 ); + Map shermanMap = ( Map ) resultList.get( 1 ); + assertEquals( 4, yogiMap.size() ); + //assertTrue( yogiMap[ 0 ] instanceof HibernateProxy ); + assertTrue( yogiMap.get( "student" ) instanceof Student ); + if( Hibernate.isInitialized( yogiMap.get( "student" ) ) ) { + assertEquals( yogiExpected, yogiMap.get( "student" ) ); + } + else { + assertEquals( yogiExpected.getStudentNumber(), ( ( Student ) yogiMap.get( "student" ) ).getStudentNumber() ); + } + assertEquals( yogiEnrolmentExpected.getSemester(), yogiMap.get( "semester" ) ); + assertEquals( yogiEnrolmentExpected.getYear(), yogiMap.get( "year" ) ); + assertEquals( courseExpected, yogiMap.get( "course" ) ); + assertEquals( 4, shermanMap.size() ); + //assertTrue( shermanMap[ 0 ] instanceof HibernateProxy ); + assertTrue( shermanMap.get( "student" ) instanceof Student ); + if( Hibernate.isInitialized( shermanMap.get( "student" ) ) ) { + assertEquals( shermanExpected, shermanMap.get( "student" ) ); + } + else { + assertEquals( shermanExpected.getStudentNumber(), ( ( Student ) shermanMap.get( "student" ) ).getStudentNumber() ); + } + assertEquals( shermanEnrolmentExpected.getSemester(), shermanMap.get( "semester" ) ); + assertEquals( shermanEnrolmentExpected.getYear(), shermanMap.get( "year" ) ); + assertEquals( courseExpected, shermanMap.get( "course" ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToEntityMapMultiProjectionWithNullAliasList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "e.student" ), "student" ) + .add( Property.forName( "e.semester" ) ) + .add( Property.forName( "e.year" ) ) + .add( Property.forName( "e.course" ), "course" ) + ) + .addOrder( Order.asc( "e.studentNumber") ) + .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Map yogiMap = ( Map ) resultList.get( 0 ); + Map shermanMap = ( Map ) resultList.get( 1 ); + //assertEquals( 2, yogiMap.size() ); + //assertTrue( yogiMap[ 0 ] instanceof HibernateProxy ); + assertTrue( yogiMap.get( "student" ) instanceof Student ); + if( Hibernate.isInitialized( yogiMap.get( "student" ) ) ) { + assertEquals( yogiExpected, yogiMap.get( "student" ) ); + } + else { + assertEquals( yogiExpected.getStudentNumber(), ( ( Student ) yogiMap.get( "student" ) ).getStudentNumber() ); + } + assertNull( yogiMap.get( "semester" ) ); + assertNull( yogiMap.get( "year" ) ); + assertEquals( courseExpected, yogiMap.get( "course" ) ); + //assertEquals( 2, shermanMap.size() ); + //assertTrue( shermanMap[ 0 ] instanceof HibernateProxy ); + assertTrue( shermanMap.get( "student" ) instanceof Student ); + if( Hibernate.isInitialized( shermanMap.get( "student" ) ) ) { + assertEquals( shermanExpected, shermanMap.get( "student" ) ); + } + else { + assertEquals( shermanExpected.getStudentNumber(), ( ( Student ) shermanMap.get( "student" ) ).getStudentNumber() ); + } + assertNull( shermanMap.get( "semester" ) ); + assertNull( shermanMap.get( "year" ) ); + assertEquals( courseExpected, shermanMap.get( "course" ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToEntityMapMultiAggregatedPropProjectionSingleResult() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class ) + .setProjection( + Projections.projectionList() + .add( Projections.min( "studentNumber" ).as( "minStudentNumber" ) ) + .add( Projections.max( "studentNumber" ).as( "maxStudentNumber" ) ) + ) + .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Map ); + Map resultMap = ( Map ) results; + assertEquals( 2, resultMap.size() ); + assertEquals( yogiExpected.getStudentNumber(), resultMap.get( "minStudentNumber" ) ); + assertEquals( shermanExpected.getStudentNumber(), resultMap.get( "maxStudentNumber" ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testOneNonEntityProjectionUnique() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use PassThroughTransformer by default + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( Projections.property( "e.semester" ) ) + .add( Restrictions.eq( "e.studentNumber", shermanEnrolmentExpected.getStudentNumber() ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select e.semester from Enrolment e where e.studentNumber = :studentNumber" ) + .setParameter( "studentNumber", shermanEnrolmentExpected.getStudentNumber() ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Short ); + assertEquals( Short.valueOf( shermanEnrolmentExpected.getSemester() ), results ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testOneNonEntityProjectionList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use PassThroughTransformer by default + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( Projections.property( "e.semester" ) ) + .addOrder( Order.asc( "e.studentNumber") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select e.semester from Enrolment e order by e.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertEquals( yogiEnrolmentExpected.getSemester(), resultList.get( 0 ) ); + assertEquals( shermanEnrolmentExpected.getSemester(), resultList.get( 1 ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testListElementsProjectionList() throws Exception { + /* + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use PassThroughTransformer by default + return s.createCriteria( Student.class, "s" ) + .createCriteria( "s.secretCodes" ) + .setProjection( Projections.property( "s.secretCodes" ) ) + .addOrder( Order.asc( "s.studentNumber") ); + } + }; + */ + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select elements(s.secretCodes) from Student s" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 3, resultList.size() ); + assertTrue( resultList.contains( yogiExpected.getSecretCodes().get( 0 ) ) ); + assertTrue( resultList.contains( shermanExpected.getSecretCodes().get( 0 ) ) ); + assertTrue( resultList.contains( shermanExpected.getSecretCodes().get( 1 ) ) ); + } + }; + runTest( hqlExecutor, null, checker, false ); + } + + public void testOneEntityProjectionUnique() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use PassThroughTransformer by default + return s.createCriteria( Enrolment.class ) + .setProjection( Projections.property( "student" ) ) + .add( Restrictions.eq( "studentNumber", Long.valueOf( yogiExpected.getStudentNumber() ) ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select e.student from Enrolment e where e.studentNumber = :studentNumber" ) + .setParameter( "studentNumber", Long.valueOf( yogiExpected.getStudentNumber() ) ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Student ); + Student student = ( Student ) results; + if ( Hibernate.isInitialized( student ) ) { + assertEquals( yogiExpected, student ); + } + else { + assertEquals( yogiExpected.getStudentNumber(), student.getStudentNumber() ); + } + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testOneEntityProjectionList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + // should use PassThroughTransformer by default + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( Projections.property( "e.student" ) ) + .addOrder( Order.asc( "e.studentNumber") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select e.student from Enrolment e order by e.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + if ( Hibernate.isInitialized( resultList.get( 0 ) ) ) { + assertEquals( yogiExpected, resultList.get( 0 ) ); + } + else { + assertEquals( yogiExpected.getStudentNumber(), ( ( Student ) resultList.get( 0 ) ).getStudentNumber() ); + } + if ( Hibernate.isInitialized( resultList.get( 1 ) ) ) { + assertEquals( shermanExpected, resultList.get( 1 ) ); + } + else { + assertEquals( shermanExpected.getStudentNumber(), ( ( Student ) resultList.get( 1 ) ).getStudentNumber() ); + } + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMultiEntityProjectionUnique() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use PassThroughTransformer by default + return s.createCriteria( Enrolment.class ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "student" ) ) + .add( Property.forName( "semester" ) ) + .add( Property.forName( "year" ) ) + .add( Property.forName( "course" ) ) + ) + .add( Restrictions.eq( "studentNumber", Long.valueOf( shermanEnrolmentExpected.getStudentNumber() ) ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( + "select e.student, e.semester, e.year, e.course from Enrolment e where e.studentNumber = :studentNumber" ) + .setParameter( "studentNumber", shermanEnrolmentExpected.getStudentNumber() ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Object[] ); + Object shermanObjects[] = ( Object [] ) results; + assertEquals( 4, shermanObjects.length ); + //assertTrue( shermanObjects[ 0 ] instanceof HibernateProxy ); + assertTrue( shermanObjects[ 0 ] instanceof Student ); + if ( Hibernate.isInitialized( shermanObjects[ 0 ] ) ) { + assertEquals( shermanExpected, shermanObjects[ 0 ] ); + } + assertEquals( shermanEnrolmentExpected.getSemester(), ( (Short) shermanObjects[ 1 ] ).shortValue() ); + assertEquals( shermanEnrolmentExpected.getYear(), ( (Short) shermanObjects[ 2 ] ).shortValue() ); + assertTrue( ! ( shermanObjects[ 3 ] instanceof HibernateProxy ) ); + assertTrue( shermanObjects[ 3 ] instanceof Course ); + assertEquals( courseExpected, shermanObjects[ 3 ] ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testMultiEntityProjectionList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + // should use PassThroughTransformer by default + return s.createCriteria( Enrolment.class, "e" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "e.student" ) ) + .add( Property.forName( "e.semester" ) ) + .add( Property.forName( "e.year" ) ) + .add( Property.forName( "e.course" ) ) + ) + .addOrder( Order.asc( "e.studentNumber") ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select e.student, e.semester, e.year, e.course from Enrolment e order by e.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Object[] yogiObjects = ( Object[] ) resultList.get( 0 ); + Object[] shermanObjects = ( Object[] ) resultList.get( 1 ); + assertEquals( 4, yogiObjects.length ); + //assertTrue( yogiObjects[ 0 ] instanceof HibernateProxy ); + assertTrue( yogiObjects[ 0 ] instanceof Student ); + if( Hibernate.isInitialized( yogiObjects[ 0 ] ) ) { + assertEquals( yogiExpected, yogiObjects[ 0 ] ); + } + assertEquals( yogiEnrolmentExpected.getSemester(), ( (Short) yogiObjects[ 1 ] ).shortValue() ); + assertEquals( yogiEnrolmentExpected.getYear(), ( (Short) yogiObjects[ 2 ] ).shortValue() ); + assertEquals( courseExpected, yogiObjects[ 3 ] ); + //assertTrue( shermanObjects[ 0 ] instanceof HibernateProxy ); + assertTrue( shermanObjects[ 0 ] instanceof Student ); + if ( Hibernate.isInitialized( shermanObjects[ 0 ] ) ) { + assertEquals( shermanExpected, shermanObjects[ 0 ] ); + } + assertEquals( shermanEnrolmentExpected.getSemester(), ( (Short) shermanObjects[ 1 ] ).shortValue() ); + assertEquals( shermanEnrolmentExpected.getYear(), ( (Short) shermanObjects[ 2 ] ).shortValue() ); + //assertTrue( ! ( shermanObjects[ 3 ] instanceof HibernateProxy ) ); + assertTrue( shermanObjects[ 3 ] instanceof Course ); + assertEquals( courseExpected, shermanObjects[ 3 ] ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testSingleAggregatedPropProjectionSingleResult() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class ) + .setProjection( Projections.min( "studentNumber" ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select min( e.studentNumber ) from Enrolment e" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Long ); + assertEquals( Long.valueOf( yogiExpected.getStudentNumber() ), results ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testMultiAggregatedPropProjectionSingleResult() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class ) + .setProjection( + Projections.projectionList() + .add( Projections.min( "studentNumber" ).as( "minStudentNumber" ) ) + .add( Projections.max( "studentNumber" ).as( "maxStudentNumber" ) ) + ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( + "select min( e.studentNumber ) as minStudentNumber, max( e.studentNumber ) as maxStudentNumber from Enrolment e" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + assertTrue( results instanceof Object[] ); + Object[] resultObjects = ( Object[] ) results; + assertEquals( Long.valueOf( yogiExpected.getStudentNumber() ), resultObjects[ 0 ] ); + assertEquals( Long.valueOf( shermanExpected.getStudentNumber() ), resultObjects[ 1 ] ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, true ); + } + + public void testAliasToBeanDtoOneArgList() throws Exception { + + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .createAlias( "e.student", "st" ) + .createAlias( "e.course", "co" ) + .setProjection( Projections.property( "st.name" ).as( "studentName" ) ) + .addOrder( Order.asc( "st.studentNumber" ) ) + .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ) ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + StudentDTO dto = ( StudentDTO ) resultList.get( 0 ); + assertNull( dto.getDescription() ); + assertEquals( yogiExpected.getName(), dto.getName() ); + dto = ( StudentDTO ) resultList.get( 1 ); + assertNull( dto.getDescription() ); + assertEquals( shermanExpected.getName(), dto.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToBeanDtoMultiArgList() throws Exception { + + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .createAlias( "e.student", "st" ) + .createAlias( "e.course", "co" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "st.name" ).as( "studentName" ) ) + .add( Property.forName( "co.description" ).as( "courseDescription" ) ) + ) + .addOrder( Order.asc( "e.studentNumber" ) ) + .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ) ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + StudentDTO dto = ( StudentDTO ) resultList.get( 0 ); + assertEquals( courseExpected.getDescription(), dto.getDescription() ); + assertEquals( yogiExpected.getName(), dto.getName() ); + dto = ( StudentDTO ) resultList.get( 1 ); + assertEquals( courseExpected.getDescription(), dto.getDescription() ); + assertEquals( shermanExpected.getName(), dto.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToBeanDtoLiteralArgList() throws Exception { + + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .createAlias( "e.student", "st" ) + .createAlias( "e.course", "co" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "st.name" ).as( "studentName" ) ) + .add( Projections.sqlProjection( + "'lame description' as courseDescription", + new String[] { "courseDescription" }, + new Type[] { Hibernate.STRING } + ) + ) + ) + .addOrder( Order.asc( "e.studentNumber" ) ) + .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ) ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + StudentDTO dto = ( StudentDTO ) resultList.get( 0 ); + assertEquals( "lame description", dto.getDescription() ); + assertEquals( yogiExpected.getName(), dto.getName() ); + dto = ( StudentDTO ) resultList.get( 1 ); + assertEquals( "lame description", dto.getDescription() ); + assertEquals( shermanExpected.getName(), dto.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testAliasToBeanDtoWithNullAliasList() throws Exception { + + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Enrolment.class, "e" ) + .createAlias( "e.student", "st" ) + .createAlias( "e.course", "co" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "st.name" ).as( "studentName" ) ) + .add( Property.forName( "st.studentNumber" ) ) + .add( Property.forName( "co.description" ).as( "courseDescription" ) ) + ) + .addOrder( Order.asc( "e.studentNumber" ) ) + .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + 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 ) ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + StudentDTO dto = ( StudentDTO ) resultList.get( 0 ); + assertEquals( courseExpected.getDescription(), dto.getDescription() ); + assertEquals( yogiExpected.getName(), dto.getName() ); + dto = ( StudentDTO ) resultList.get( 1 ); + assertEquals( courseExpected.getDescription(), dto.getDescription() ); + assertEquals( shermanExpected.getName(), dto.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testOneSelectNewList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) throws Exception { + return s.createCriteria( Student.class, "s" ) + .setProjection( Projections.property( "s.name" ) ) + .addOrder( Order.asc( "s.studentNumber" ) ) + .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) ); + } + private Constructor getConstructor() throws NoSuchMethodException { + return StudentDTO.class.getConstructor( PersonName.class ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select new org.hibernate.test.querycache.StudentDTO(s.name) from Student s order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + StudentDTO yogi = ( StudentDTO ) resultList.get( 0 ); + assertNull( yogi.getDescription() ); + assertEquals( yogiExpected.getName(), yogi.getName() ); + StudentDTO sherman = ( StudentDTO ) resultList.get( 1 ); + assertEquals( shermanExpected.getName(), sherman.getName() ); + assertNull( sherman.getDescription() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMultiSelectNewList() throws Exception{ + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) throws Exception { + return s.createCriteria( Student.class, "s" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "s.studentNumber" ) ) + .add( Property.forName( "s.name" ) ) + ) + .addOrder( Order.asc( "s.studentNumber" ) ) + .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) ); + } + private Constructor getConstructor() throws NoSuchMethodException { + return Student.class.getConstructor( long.class, PersonName.class ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select new Student(s.studentNumber, s.name) from Student s order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Student yogi = ( Student ) resultList.get( 0 ); + assertEquals( yogiExpected.getStudentNumber(), yogi.getStudentNumber() ); + assertEquals( yogiExpected.getName(), yogi.getName() ); + Student sherman = ( Student ) resultList.get( 1 ); + assertEquals( shermanExpected.getStudentNumber(), sherman.getStudentNumber() ); + assertEquals( shermanExpected.getName(), sherman.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMultiSelectNewWithLiteralList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) throws Exception { + return s.createCriteria( Student.class, "s" ) + .setProjection( + Projections.projectionList() + .add( Projections.sqlProjection( "555 as sCode", new String[]{ "sCode" }, new Type[] { Hibernate.LONG } ) ) + .add( Property.forName( "s.name" ) ) + ) + .addOrder( Order.asc( "s.studentNumber" ) ) + .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) ); + } + private Constructor getConstructor() throws NoSuchMethodException { + return Student.class.getConstructor( long.class, PersonName.class ); + } + }; + + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select new Student(555L, s.name) from Student s order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Student yogi = ( Student ) resultList.get( 0 ); + assertEquals( 555L, yogi.getStudentNumber() ); + assertEquals( yogiExpected.getName(), yogi.getName() ); + Student sherman = ( Student ) resultList.get( 1 ); + assertEquals( 555L, sherman.getStudentNumber() ); + assertEquals( shermanExpected.getName(), sherman.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMultiSelectNewListList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "s.studentNumber" ) ) + .add( Property.forName( "s.name" ) ) + ) + .addOrder( Order.asc( "s.studentNumber" ) ) + .setResultTransformer( Transformers.TO_LIST ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select new list(s.studentNumber, s.name) from Student s order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + List yogiList = ( List ) resultList.get( 0 ); + assertEquals( yogiExpected.getStudentNumber(), yogiList.get( 0 ) ); + assertEquals( yogiExpected.getName(), yogiList.get( 1 ) ); + List shermanList = ( List ) resultList.get( 1 ); + assertEquals( shermanExpected.getStudentNumber(), shermanList.get( 0 ) ); + assertEquals( shermanExpected.getName(), shermanList.get( 1 ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMultiSelectNewMapList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "s.studentNumber" ).as( "sNumber" ) ) + .add( Property.forName( "s.name" ).as( "sName" ) ) + ) + .addOrder( Order.asc( "s.studentNumber" ) ) + .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select new map(s.studentNumber as sNumber, s.name as sName) from Student s order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Map yogiMap = ( Map ) resultList.get( 0 ); + assertEquals( yogiExpected.getStudentNumber(), yogiMap.get( "sNumber" ) ); + assertEquals( yogiExpected.getName(), yogiMap.get( "sName" ) ); + Map shermanMap = ( Map ) resultList.get( 1 ); + assertEquals( shermanExpected.getStudentNumber(), shermanMap.get( "sNumber" ) ); + assertEquals( shermanExpected.getName(), shermanMap.get( "sName" ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testSelectNewEntityConstructorList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "s.studentNumber" ) ) + .add( Property.forName( "s.name" ) ) + ) + .addOrder( Order.asc( "s.studentNumber" ) ) + .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) ); + } + private Constructor getConstructor() { + Type studentNametype = + ( ( SessionFactoryImpl ) getSessions() ) + .getEntityPersister( Student.class.getName() ) + .getPropertyType( "name" ); + return ReflectHelper.getConstructor( Student.class, new Type[] { Hibernate.LONG, studentNametype } ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select new Student(s.studentNumber, s.name) from Student s order by s.studentNumber" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Student yogi = ( Student ) resultList.get( 0 ); + assertEquals( yogiExpected.getStudentNumber(), yogi.getStudentNumber() ); + assertEquals( yogiExpected.getName(), yogi.getName() ); + Student sherman = ( Student ) resultList.get( 1 ); + assertEquals( shermanExpected.getStudentNumber(), sherman.getStudentNumber() ); + assertEquals( shermanExpected.getName(), sherman.getName() ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMapKeyList() throws Exception { + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a" ) + .setProjection( Projections.property( "a.addressType" ) ); + } + }; + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select key(s.addresses) from Student s" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertTrue( resultList.contains( "home" ) ); + assertTrue( resultList.contains( "work" ) ); + } + }; + runTest( hqlExecutor, criteriaExecutor, checker, false ); + } + + public void testMapValueList() throws Exception { + /* + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a" ) + .setProjection( Projections.property( "s.addresses" )); + } + }; + */ + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select value(s.addresses) from Student s" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertTrue( resultList.contains( yogiExpected.getAddresses().get( "home" ) ) ); + assertTrue( resultList.contains( yogiExpected.getAddresses().get( "work" ) ) ); + } + }; + runTest( hqlExecutor, null, checker, false ); + } + + public void testMapEntryList() throws Exception { + /* + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a" ) + .setProjection( + Projections.projectionList() + .add( Projections.property( "a.addressType" ) ) + .add( Projections.property( "s.addresses" ).as( "a" ) ); + ) + } + }; + */ + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select entry(s.addresses) from Student s" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + Iterator it=resultList.iterator(); + assertTrue( resultList.get( 0 ) instanceof Map.Entry ); + Map.Entry entry = ( Map.Entry ) it.next(); + if ( "home".equals( entry.getKey() ) ) { + assertTrue( yogiExpected.getAddresses().get( "home" ).equals( entry.getValue() ) ); + entry = ( Map.Entry ) it.next(); + assertTrue( yogiExpected.getAddresses().get( "work" ).equals( entry.getValue() ) ); + } + else { + assertTrue( "work".equals( entry.getKey() ) ); + assertTrue( yogiExpected.getAddresses().get( "work" ).equals( entry.getValue() ) ); + entry = ( Map.Entry ) it.next(); + assertTrue( yogiExpected.getAddresses().get( "home" ).equals( entry.getValue() ) ); + } + } + }; + runTest( hqlExecutor, null, checker, false ); + } + + public void testMapElementsList() throws Exception { + /* + CriteriaExecutor criteriaExecutor = new CriteriaExecutor() { + protected Criteria getCriteria(Session s) { + return s.createCriteria( Student.class, "s" ) + .createAlias( "s.addresses", "a", Criteria.INNER_JOIN ) + .setProjection( Projections.property( "s.addresses" ) ); + } + }; + */ + HqlExecutor hqlExecutor = new HqlExecutor() { + public Query getQuery(Session s) { + return s.createQuery( "select elements(a) from Student s inner join s.addresses a" ); + } + }; + ResultChecker checker = new ResultChecker() { + public void check(Object results) { + List resultList = ( List ) results; + assertEquals( 2, resultList.size() ); + assertTrue( resultList.contains( yogiExpected.getAddresses().get( "home" ) ) ); + assertTrue( resultList.contains( yogiExpected.getAddresses().get( "work" ) ) ); + } + }; + runTest( hqlExecutor, null, checker, false ); + } + + protected void runTest(HqlExecutor hqlExecutor, CriteriaExecutor criteriaExecutor, ResultChecker checker, boolean isSingleResult) + throws Exception { + createData(); + if ( criteriaExecutor != null ) { + runTest( criteriaExecutor, checker, isSingleResult ); + } + if ( hqlExecutor != null ) { + runTest( hqlExecutor, checker, isSingleResult ); + } + deleteData(); + } + + private boolean isQueryCacheGetEnabled() { + return getQueryCacheMode() == CacheMode.NORMAL || + getQueryCacheMode() == CacheMode.GET; + } + + private boolean isQueryCachePutEnabled() { + return getQueryCacheMode() == CacheMode.NORMAL || + getQueryCacheMode() == CacheMode.PUT; + } + + protected void runTest(QueryExecutor queryExecutor, ResultChecker resultChecker, boolean isSingleResult) throws Exception{ + clearCache(); + clearStatistics(); + + Object results = queryExecutor.execute( isSingleResult ); + + assertHitCount( 0 ); + assertMissCount( isQueryCacheGetEnabled() ? 1 : 0 ); + assertPutCount( isQueryCachePutEnabled() ? 1 : 0 ); + clearStatistics(); + + resultChecker.check( results ); + + // check again to make sure nothing got initialized while checking results; + assertHitCount( 0 ); + assertMissCount( 0 ); + assertPutCount( 0 ); + clearStatistics(); + + results = queryExecutor.execute( isSingleResult ); + + assertHitCount( isQueryCacheGetEnabled() ? 1 : 0 ); + assertMissCount( 0 ); + assertPutCount( ! isQueryCacheGetEnabled() && isQueryCachePutEnabled() ? 1 : 0 ); + clearStatistics(); + + resultChecker.check( results ); + + // check again to make sure nothing got initialized while checking results; + assertHitCount( 0 ); + assertMissCount( 0 ); + assertPutCount( 0 ); + clearStatistics(); + } + + private void multiPropProjectionNoTransformerDynNonLazy(CacheMode sessionCacheMode, + boolean isCacheableQuery) { + Session s = openSession(); + s.setCacheMode( sessionCacheMode ); + Transaction t = s.beginTransaction(); + List resultList = s.createCriteria( Enrolment.class ) + .setCacheable( isCacheableQuery ) + .setFetchMode( "student", FetchMode.JOIN ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "student" ), "student" ) + .add( Property.forName( "semester" ), "semester" ) + .add( Property.forName( "year" ), "year" ) + .add( Property.forName( "course" ), "course" ) + ) + .addOrder( Order.asc( "studentNumber") ) + .list(); + t.commit(); + s.close(); + + assertEquals( 2, resultList.size() ); + Object[] yogiObjects = ( Object[] ) resultList.get( 0 ); + Object[] shermanObjects = ( Object[] ) resultList.get( 1 ); + assertEquals( 4, yogiObjects.length ); + assertTrue( yogiObjects[ 0 ] instanceof Student ); + assertTrue( Hibernate.isInitialized( yogiObjects[ 0 ] ) ); + assertEquals( yogiEnrolmentExpected.getSemester(), ( (Short) yogiObjects[ 1 ] ).shortValue() ); + assertEquals( yogiEnrolmentExpected.getYear(), ( (Short) yogiObjects[ 2 ] ).shortValue() ); + assertEquals( courseExpected, yogiObjects[ 3 ] ); + assertTrue( shermanObjects[ 0 ] instanceof Student ); + assertTrue( Hibernate.isInitialized( shermanObjects[ 0 ] ) ); + assertEquals( shermanEnrolmentExpected.getSemester(), ( (Short) shermanObjects[ 1 ] ).shortValue() ); + assertEquals( shermanEnrolmentExpected.getYear(), ( (Short) shermanObjects[ 2 ] ).shortValue() ); + assertTrue( ! ( shermanObjects[ 3 ] instanceof HibernateProxy ) ); + assertTrue( shermanObjects[ 3 ] instanceof Course ); + assertEquals( courseExpected, shermanObjects[ 3 ] ); + } + +/* + { + + assertEquals( 2, resultList.size() ); + Object[] yogiObjects = ( Object[] ) resultList.get( 0 ); + Object[] shermanObjects = ( Object[] ) resultList.get( 1 ); + assertEquals( 4, yogiObjects.length ); + assertEquals( yogiExpected, ( Student ) yogiObjects[ 0 ] ); + assertEquals( yogiEnrolmentExpected.getSemester(), ( (Short) yogiObjects[ 1 ] ).shortValue() ); + assertEquals( yogiEnrolmentExpected.getYear(), ( (Short) yogiObjects[ 2 ] ).shortValue() ); + assertEquals( courseExpected, yogiObjects[ 3 ] ); + assertEquals( shermanExpected, ( Student ) shermanObjects[ 0 ] ); + assertEquals( shermanEnrolmentExpected.getSemester(), ( (Short) shermanObjects[ 1 ] ).shortValue() ); + assertEquals( shermanEnrolmentExpected.getYear(), ( (Short) shermanObjects[ 2 ] ).shortValue() ); + assertEquals( courseExpected, shermanObjects[ 3 ] ); + + } + +*/ +/* + private void executeProperty() { + resultList = s.createCriteria( Student.class ) + .setCacheable( true ) + .setProjection( + Projections.projectionList() + .add( Projections.id().as( "studentNumber" ) ) + .add( Property.forName( "name" ), "name" ) + .add( Property.forName( "cityState" ), "cityState" ) + .add( Property.forName( "preferredCourse" ), "preferredCourse" ) + ) + .list(); + assertEquals( 2, resultList.size() ); + for ( Iterator it = resultList.iterator(); it.hasNext(); ) { + Object[] objects = ( Object[] ) it.next(); + assertEquals( 4, objects.length ); + assertTrue( objects[0] instanceof Long ); + assertTrue( objects[1] instanceof String ); + if ( "yogiExpected King".equals( objects[1] ) ) { + assertTrue( objects[2] instanceof Name ); + assertTrue( objects[3] instanceof Course ); + } + else { + assertNull( objects[2] ); + assertNull( objects[3] ); + } + } + + Object[] aResult = ( Object[] ) s.createCriteria( Student.class ) + .setCacheable( true ) + .add( Restrictions.idEq( new Long( 667 ) ) ) + .setProjection( + Projections.projectionList() + .add( Projections.id().as( "studentNumber" ) ) + .add( Property.forName( "name" ), "name" ) + .add( Property.forName( "cityState" ), "cityState" ) + .add( Property.forName( "preferredCourse" ), "preferredCourse" ) + ) + .uniqueResult(); + assertNotNull( aResult ); + assertEquals( 4, aResult.length ); + assertTrue( aResult[0] instanceof Long ); + assertTrue( aResult[1] instanceof String ); + assertTrue( aResult[2] instanceof Name ); + assertTrue( aResult[3] instanceof Course ); + + Long count = ( Long ) s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .setProjection( Property.forName( "studentNumber" ).count().setDistinct() ) + .uniqueResult(); + assertEquals( count, new Long( 2 ) ); + + Object object = s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "studentNumber" ).count() ) + .add( Property.forName( "studentNumber" ).max() ) + .add( Property.forName( "studentNumber" ).min() ) + .add( Property.forName( "studentNumber" ).avg() ) + ) + .uniqueResult(); + Object[] result = ( Object[] ) object; + + assertEquals( new Long( 2 ), result[0] ); + assertEquals( new Long( 667 ), result[1] ); + assertEquals( new Long( 101 ), result[2] ); + assertEquals( 384.0, ( ( Double ) result[3] ).doubleValue(), 0.01 ); + + + s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .add( Property.forName( "studentNumber" ).gt( new Long( 665 ) ) ) + .add( Property.forName( "studentNumber" ).lt( new Long( 668 ) ) ) + .add( Property.forName( "courseCode" ).like( "HIB", MatchMode.START ) ) + .add( Property.forName( "year" ).eq( new Short( ( short ) 1999 ) ) ) + .addOrder( Property.forName( "studentNumber" ).asc() ) + .uniqueResult(); + + List resultWithMaps = s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "studentNumber" ).as( "stNumber" ) ) + .add( Property.forName( "courseCode" ).as( "cCode" ) ) + ) + .add( Property.forName( "studentNumber" ).gt( new Long( 665 ) ) ) + .add( Property.forName( "studentNumber" ).lt( new Long( 668 ) ) ) + .addOrder( Property.forName( "studentNumber" ).asc() ) + .setResultTransformer( Criteria.ALIAS_TO_ENTITY_MAP ) + .list(); + + assertEquals( 1, resultWithMaps.size() ); + Map m1 = ( Map ) resultWithMaps.get( 0 ); + + assertEquals( new Long( 667 ), m1.get( "stNumber" ) ); + assertEquals( courseExpected.getCourseCode(), m1.get( "cCode" ) ); + + resultWithMaps = s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .setProjection( Property.forName( "studentNumber" ).as( "stNumber" ) ) + .addOrder( Order.desc( "stNumber" ) ) + .setResultTransformer( Criteria.ALIAS_TO_ENTITY_MAP ) + .list(); + + assertEquals( 2, resultWithMaps.size() ); + Map m0 = ( Map ) resultWithMaps.get( 0 ); + m1 = ( Map ) resultWithMaps.get( 1 ); + + assertEquals( new Long( 101 ), m1.get( "stNumber" ) ); + assertEquals( new Long( 667 ), m0.get( "stNumber" ) ); + + List resultWithAliasedBean = s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .createAlias( "student", "st" ) + .createAlias( "courseExpected", "co" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "st.name" ).as( "studentName" ) ) + .add( Property.forName( "co.description" ).as( "courseDescription" ) ) + ) + .addOrder( Order.desc( "studentName" ) ) + .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) ) + .list(); + + assertEquals( 2, resultWithAliasedBean.size() ); + + StudentDTO dto = ( StudentDTO ) resultWithAliasedBean.get( 0 ); + assertNotNull( dto.getDescription() ); + assertNotNull( dto.getName() ); + + CourseMeeting courseMeetingDto = ( CourseMeeting ) s.createCriteria( CourseMeeting.class ) + .setCacheable( true ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "id" ).as( "id" ) ) + .add( Property.forName( "courseExpected" ).as( "courseExpected" ) ) + ) + .addOrder( Order.desc( "id" ) ) + .setResultTransformer( Transformers.aliasToBean( CourseMeeting.class ) ) + .uniqueResult(); + + assertNotNull( courseMeetingDto.getId() ); + assertEquals( courseExpected.getCourseCode(), courseMeetingDto.getId().getCourseCode() ); + assertEquals( "Monday", courseMeetingDto.getId().getDay() ); + assertEquals( "1313 Mockingbird Lane", courseMeetingDto.getId().getLocation() ); + assertEquals( 1, courseMeetingDto.getId().getPeriod() ); + assertEquals( courseExpected.getDescription(), courseMeetingDto.getCourse().getDescription() ); + + s.createCriteria( Student.class ) + .setCacheable( true ) + .add( Restrictions.like( "name", "yogiExpected", MatchMode.START ) ) + .addOrder( Order.asc( "name" ) ) + .createCriteria( "enrolments", "e" ) + .addOrder( Order.desc( "year" ) ) + .addOrder( Order.desc( "semester" ) ) + .createCriteria( "courseExpected", "c" ) + .addOrder( Order.asc( "description" ) ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "this.name" ) ) + .add( Property.forName( "e.year" ) ) + .add( Property.forName( "e.semester" ) ) + .add( Property.forName( "c.courseCode" ) ) + .add( Property.forName( "c.description" ) ) + ) + .uniqueResult(); + + Projection p1 = Projections.projectionList() + .add( Property.forName( "studentNumber" ).count() ) + .add( Property.forName( "studentNumber" ).max() ) + .add( Projections.rowCount() ); + + Projection p2 = Projections.projectionList() + .add( Property.forName( "studentNumber" ).min() ) + .add( Property.forName( "studentNumber" ).avg() ) + .add( + Projections.sqlProjection( + "1 as constOne, count(*) as countStar", + new String[] { "constOne", "countStar" }, + new Type[] { Hibernate.INTEGER, Hibernate.INTEGER } + ) + ); + + Object[] array = ( Object[] ) s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .setProjection( Projections.projectionList().add( p1 ).add( p2 ) ) + .uniqueResult(); + + assertEquals( array.length, 7 ); + + List list = s.createCriteria( Enrolment.class ) + .setCacheable( true ) + .createAlias( "student", "st" ) + .createAlias( "courseExpected", "co" ) + .setProjection( + Projections.projectionList() + .add( Property.forName( "co.courseCode" ).group() ) + .add( Property.forName( "st.studentNumber" ).count().setDistinct() ) + .add( Property.forName( "year" ).group() ) + ) + .list(); + + assertEquals( list.size(), 2 ); + } +*/ + protected void clearCache() { + getSessions().getCache().evictQueryRegions(); + } + + protected void clearStatistics() { + getSessions().getStatistics().clear(); + } + + protected void assertEntityFetchCount(int expected) { + int actual = ( int ) getSessions().getStatistics().getEntityFetchCount(); + assertEquals( expected, actual ); + } + + protected void assertCount(int expected) { + int actual = ( int ) getSessions().getStatistics().getQueries().length; + assertEquals( expected, actual ); + } + + protected void assertHitCount(int expected) { + int actual = ( int ) getSessions().getStatistics().getQueryCacheHitCount(); + assertEquals( expected, actual ); + } + + protected void assertMissCount(int expected) { + int actual = ( int ) getSessions().getStatistics().getQueryCacheMissCount(); + assertEquals( expected, actual ); + } + + protected void assertPutCount(int expected) { + int actual = ( int ) getSessions().getStatistics().getQueryCachePutCount(); + assertEquals( expected, actual ); + } + + protected void assertInsertCount(int expected) { + int inserts = ( int ) getSessions().getStatistics().getEntityInsertCount(); + assertEquals( "unexpected insert count", expected, inserts ); + } + + protected void assertUpdateCount(int expected) { + int updates = ( int ) getSessions().getStatistics().getEntityUpdateCount(); + assertEquals( "unexpected update counts", expected, updates ); + } + + protected void assertDeleteCount(int expected) { + int deletes = ( int ) getSessions().getStatistics().getEntityDeleteCount(); + assertEquals( "unexpected delete counts", expected, deletes ); + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Address.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Address.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Address.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,134 @@ +// $Id: Address.java 7996 2005-08-22 14:49:57Z steveebersole $ +package org.hibernate.test.querycache; + +/** + * Implementation of Address. + * + * @author Steve Ebersole + */ +public class Address { + private long id; + private String addressType; + private String street; + private String city; + private String stateProvince; + private String postalCode; + private String country; + private Student student; + + public Address() {} + + public Address(Student student, String type, String street, String city, String stateProvince, String postalCode, String country) { + this.student = student; + this.addressType = type; + this.street = street; + this.city = city; + this.stateProvince = stateProvince; + this.postalCode = postalCode; + this.country = country; + } + + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + + public Student getStudent() { + return student; + } + + public void setStudent(Student student) { + this.student = student; + } + + public String getAddressType() { + return addressType; + } + + public void setAddressType(String addressType) { + this.addressType = addressType; + } + + public String getStreet() { + return street; + } + + public void setStreet(String street) { + this.street = street; + } + + public String getCity() { + return city; + } + + public void setCity(String city) { + this.city = city; + } + + public String getPostalCode() { + return postalCode; + } + + public void setPostalCode(String postalCode) { + this.postalCode = postalCode; + } + + public String getCountry() { + return country; + } + + public void setCountry(String country) { + this.country = country; + } + + public String getStateProvince() { + return stateProvince; + } + + public void setStateProvince(String stateProvince) { + this.stateProvince = stateProvince; + } + + @Override + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || getClass() != o.getClass() ) { + return false; + } + + Address address = ( Address ) o; + + if ( city != null ? !city.equals( address.city ) : address.city != null ) { + return false; + } + if ( country != null ? !country.equals( address.country ) : address.country != null ) { + return false; + } + if ( postalCode != null ? !postalCode.equals( address.postalCode ) : address.postalCode != null ) { + return false; + } + if ( stateProvince != null ? !stateProvince.equals( address.stateProvince ) : address.stateProvince != null ) { + return false; + } + if ( street != null ? !street.equals( address.street ) : address.street != null ) { + return false; + } + + return true; + } + + @Override + public int hashCode() { + int result = street != null ? street.hashCode() : 0; + result = 31 * result + ( city != null ? city.hashCode() : 0 ); + result = 31 * result + ( stateProvince != null ? stateProvince.hashCode() : 0 ); + result = 31 * result + ( postalCode != null ? postalCode.hashCode() : 0 ); + result = 31 * result + ( country != null ? country.hashCode() : 0 ); + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Course.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Course.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Course.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,60 @@ +//$Id: Course.java 5686 2005-02-12 07:27:32Z steveebersole $ +package org.hibernate.test.querycache; + +import java.io.Serializable; +import java.util.HashSet; +import java.util.Set; + +/** + * @author Gavin King + */ +public class Course implements Serializable { + private String courseCode; + private String description; + private Set courseMeetings = new HashSet(); + + public String getCourseCode() { + return courseCode; + } + public void setCourseCode(String courseCode) { + this.courseCode = courseCode; + } + public String getDescription() { + return description; + } + public void setDescription(String description) { + this.description = description; + } + public Set getCourseMeetings() { + return courseMeetings; + } + public void setCourseMeetings(Set courseMeetings) { + this.courseMeetings = courseMeetings; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || ! ( o instanceof Course ) ) { + return false; + } + + Course course = ( Course ) o; + + if ( courseCode != null ? !courseCode.equals( course.getCourseCode() ) : course.getCourseCode() != null ) { + return false; + } + if ( description != null ? !description.equals( course.getDescription() ) : course.getDescription() != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = courseCode != null ? courseCode.hashCode() : 0; + result = 31 * result + ( description != null ? description.hashCode() : 0 ); + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeeting.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeeting.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeeting.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,55 @@ +package org.hibernate.test.querycache; + +/** + * @author Gail Badner + */ +public class CourseMeeting { + private CourseMeetingId id; + private Course course; + + public CourseMeeting() {} + + public CourseMeeting(Course course, String day, int period, String location) { + this.id = new CourseMeetingId( course, day, period, location ); + this.course = course; + } + + public CourseMeetingId getId() { + return id; + } + public void setId(CourseMeetingId id) { + this.id = id; + } + public Course getCourse() { + return course; + } + public void setCourse(Course course) { + this.course = course; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || getClass() != o.getClass() ) { + return false; + } + + CourseMeeting that = ( CourseMeeting ) o; + + if ( course != null ? !course.equals( that.course ) : that.course != null ) { + return false; + } + if ( id != null ? !id.equals( that.id ) : that.id != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = id != null ? id.hashCode() : 0; + result = 31 * result + ( course != null ? course.hashCode() : 0 ); + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeetingId.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeetingId.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CourseMeetingId.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,81 @@ +package org.hibernate.test.querycache; + +import java.io.Serializable; + +/** + * @author Gail Badner + */ +public class CourseMeetingId implements Serializable { + private String courseCode; + private String day; + private int period; + private String location; + + public CourseMeetingId() {} + + public CourseMeetingId(Course course, String day, int period, String location) { + this.courseCode = course.getCourseCode(); + this.day = day; + this.period = period; + this.location = location; + } + + public String getCourseCode() { + return courseCode; + } + public void setCourseCode(String courseCode) { + this.courseCode = courseCode; + } + public String getDay() { + return day; + } + public void setDay(String day) { + this.day = day; + } + public int getPeriod() { + return period; + } + public void setPeriod(int period) { + this.period = period; + } + public String getLocation() { + return location; + } + public void setLocation(String location) { + this.location = location; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || getClass() != o.getClass() ) { + return false; + } + + CourseMeetingId that = ( CourseMeetingId ) o; + + if ( period != that.period ) { + return false; + } + if ( courseCode != null ? !courseCode.equals( that.courseCode ) : that.courseCode != null ) { + return false; + } + if ( day != null ? !day.equals( that.day ) : that.day != null ) { + return false; + } + if ( location != null ? !location.equals( that.location ) : that.location != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = courseCode != null ? courseCode.hashCode() : 0; + result = 31 * result + ( day != null ? day.hashCode() : 0 ); + result = 31 * result + period; + result = 31 * result + ( location != null ? location.hashCode() : 0 ); + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheIgnoreResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheIgnoreResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheIgnoreResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,57 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import junit.framework.Test; + +import org.hibernate.CacheMode; +import org.hibernate.testing.junit.functional.FunctionalTestClassTestSuite; + +/** + * @author Gail Badner + */ +public class CriteriaQueryCacheIgnoreResultTransformerTest extends AbstractQueryCacheResultTransformerTest { + + public CriteriaQueryCacheIgnoreResultTransformerTest(String str) { + super( str ); + } + + public static Test suite() { + return new FunctionalTestClassTestSuite( CriteriaQueryCacheIgnoreResultTransformerTest.class ); + } + + protected CacheMode getQueryCacheMode() { + return CacheMode.IGNORE; + } + + protected void runTest(HqlExecutor hqlExecutor, CriteriaExecutor criteriaExecutor, ResultChecker checker, boolean isSingleResult) + throws Exception { + createData(); + if ( criteriaExecutor != null ) { + runTest( criteriaExecutor, checker, isSingleResult ); + } + deleteData(); + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheNormalResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheNormalResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCacheNormalResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,48 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import junit.framework.Test; + +import org.hibernate.CacheMode; +import org.hibernate.testing.junit.functional.FunctionalTestClassTestSuite; + +/** + * @author Gail Badner + */ +public class CriteriaQueryCacheNormalResultTransformerTest extends CriteriaQueryCachePutResultTransformerTest { + + public CriteriaQueryCacheNormalResultTransformerTest(String str) { + super( str ); + } + + public static Test suite() { + return new FunctionalTestClassTestSuite( CriteriaQueryCacheNormalResultTransformerTest.class ); + } + + protected CacheMode getQueryCacheMode() { + return CacheMode.NORMAL; + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCachePutResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCachePutResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/CriteriaQueryCachePutResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,181 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import junit.framework.Test; + +import org.hibernate.CacheMode; +import org.hibernate.testing.junit.functional.FunctionalTestClassTestSuite; + +/** + * @author Gail Badner + */ +public class CriteriaQueryCachePutResultTransformerTest extends CriteriaQueryCacheIgnoreResultTransformerTest { + + public CriteriaQueryCachePutResultTransformerTest(String str) { + super( str ); + } + + public static Test suite() { + return new FunctionalTestClassTestSuite( CriteriaQueryCachePutResultTransformerTest.class ); + } + + protected CacheMode getQueryCacheMode() { + return CacheMode.PUT; + } + + protected boolean areDynamicNonLazyAssociationsChecked() { + return false; + } + + public void testAliasToEntityMapNoProjectionList() { + reportSkip( "Transformers.ALIAS_TO_ENTITY_MAP with Criteria fails when try put in cache", + "Cache results using Transformers.ALIAS_TO_ENTITY_MAP with Criteria" ); + } + + public void testAliasToEntityMapNoProjectionListFailureExpected() throws Exception { + super.testAliasToEntityMapNoProjectionList(); + } + + public void testAliasToEntityMapNoProjectionMultiAndNullList() { + reportSkip( "Transformers.ALIAS_TO_ENTITY_MAP with Criteria fails when try put in cache", + "Cache results using Transformers.ALIAS_TO_ENTITY_MAP with Criteria" ); + } + public void testAliasToEntityMapNoProjectionMultiAndNullListFailureExpected() throws Exception { + super.testAliasToEntityMapNoProjectionMultiAndNullList(); + } + + public void testAliasToEntityMapOneProjectionList() { + reportSkip( "Transformers.ALIAS_TO_ENTITY_MAP with Criteria fails when try put in cache", + "Cache results using Transformers.ALIAS_TO_ENTITY_MAP with Criteria" ); + } + public void testAliasToEntityMapOneProjectionListFailureExpected() throws Exception { + super.testAliasToEntityMapOneProjectionList(); + } + + public void testAliasToEntityMapMultiProjectionList() { + reportSkip( "Transformers.ALIAS_TO_ENTITY_MAP with Criteria fails when try put in cache", + "Cache results using Transformers.ALIAS_TO_ENTITY_MAP with Criteria" ); + } + public void testAliasToEntityMapMultiProjectionListFailureExpected() throws Exception { + super.testAliasToEntityMapMultiProjectionList(); + } + + public void testAliasToEntityMapMultiProjectionWithNullAliasList() { + reportSkip( "Transformers.ALIAS_TO_ENTITY_MAP with Criteria fails when try put in cache", + "Cache results using Transformers.ALIAS_TO_ENTITY_MAP with Criteria" ); + } + public void testAliasToEntityMapMultiProjectionWithNullAliasListFailureExpected() throws Exception { + super.testAliasToEntityMapMultiProjectionWithNullAliasList(); + } + + public void testAliasToEntityMapMultiAggregatedPropProjectionSingleResult() { + reportSkip( "Transformers.ALIAS_TO_ENTITY_MAP with Criteria fails when try put in cache", + "Cache results using Transformers.ALIAS_TO_ENTITY_MAP with Criteria" ); + } + public void testAliasToEntityMapMultiAggregatedPropProjectionSingleResultFailureExpected() throws Exception { + super.testAliasToEntityMapMultiAggregatedPropProjectionSingleResult(); + } + + public void testAliasToBeanDtoOneArgList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testAliasToBeanDtoOneArgListFailureExpected() throws Exception { + super.testAliasToBeanDtoOneArgList(); + } + + public void testAliasToBeanDtoMultiArgList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testAliasToBeanDtoMultiArgListFailureExpected() throws Exception { + super.testAliasToBeanDtoMultiArgList(); + } + + public void testAliasToBeanDtoLiteralArgList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testAliasToBeanDtoLiteralArgListFailureExpected() throws Exception { + super.testAliasToBeanDtoLiteralArgList(); + } + + public void testAliasToBeanDtoWithNullAliasList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testAliasToBeanDtoWithNullAliasListFailureExpected() throws Exception { + super.testAliasToBeanDtoWithNullAliasList(); + } + + public void testOneSelectNewList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testOneSelectNewListFailureExpected() throws Exception { + super.testOneSelectNewList(); + } + + public void testMultiSelectNewList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testMultiSelectNewListFailureExpected() throws Exception { + super.testMultiSelectNewList(); + } + + public void testMultiSelectNewWithLiteralList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testMultiSelectNewWithLiteralListFailureExpected() throws Exception { + super.testMultiSelectNewWithLiteralList(); + } + + public void testMultiSelectNewListList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testMultiSelectNewListListFailureExpected() throws Exception { + super.testMultiSelectNewListList(); + } + + public void testMultiSelectNewMapList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testMultiSelectNewMapListFailureExpected() throws Exception { + super.testMultiSelectNewMapList(); + } + + public void testSelectNewEntityConstructorList() { + reportSkip( "Transformers.aliasToBean with Criteria fails when try put in cache", + "Cache results using Transformers.aliasToBean with Criteria" ); + } + public void testSelectNewEntityConstructorListFailureExpected() throws Exception { + super.testMultiSelectNewMapList(); + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.hbm.xml =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.hbm.xml (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.hbm.xml 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,90 @@ +<?xml version="1.0"?> +<!DOCTYPE hibernate-mapping PUBLIC + "-//Hibernate/Hibernate Mapping DTD 3.0//EN" + "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> + +<hibernate-mapping package="org.hibernate.test.querycache"> + + <class name="Course"> + <id name="courseCode"> + <generator class="assigned"/> + </id> + <property name="description"/> + <set name="courseMeetings" inverse="true" cascade="all-delete-orphan" lazy="false"> + <key column="courseCode"/> + <one-to-many class="CourseMeeting"/> + </set> + </class> + + <class name="CourseMeeting"> + <composite-id name="id" class="CourseMeetingId"> + <key-property name="courseCode"/> + <key-property name="day"/> + <key-property name="period"/> + <key-property name="location"/> + </composite-id> + <many-to-one name="course" insert="false" update="false" lazy="false"> + <column name="courseCode"/> + </many-to-one> + </class> + + <class name="Student"> + <id name="studentNumber"> + <column name="studentId"/> + <generator class="assigned"/> + </id> + <component name="name"> + <property name="first" column="name_first" not-null="true"/> + <property name="middle" column="name_middle" not-null="false"/> + <property name="last" column="name_last" not-null="true"/> + </component> + <set name="enrolments" inverse="true" cascade="delete"> + <key column="studentId"/> + <one-to-many class="Enrolment"/> + </set> + <map name="addresses" table="addresses" cascade="all,delete" lazy="true"> + <key column="studentNumber"/> + <map-key column="addressType" type="string"/> + <one-to-many class="Address"/> + </map> + <many-to-one name="preferredCourse" column="preferredCourseCode" lazy="proxy"/> + <list name="secretCodes" lazy="false"> + <key> + <column name="studentNumber"/> + </key> + <index column="i"/> + <element column="secretCode" type="int"/> + </list> + </class> + + <class name="Address"> + <id name="id"> + <generator class="increment"/> + </id> + <property name="addressType"/> + <property name="street"/> + <property name="city"/> + <property name="stateProvince"/> + <property name="postalCode"/> + <property name="country"/> + <many-to-one name="student" class="Student" column="studentNumber" not-null="false"/> + </class> + + <class name="Enrolment"> + <composite-id> + <key-property name="studentNumber"> + <column name="studentId"/> + </key-property> + <key-property name="courseCode"/> + </composite-id> + <many-to-one name="student" insert="false" update="false" lazy="proxy"> + <column name="studentId"/> + </many-to-one> + <many-to-one name="course" insert="false" update="false" lazy="false"> + <column name="courseCode"/> + </many-to-one> + <property name="semester" type="short" not-null="true"/> + <property name="year" column="`year`" type="short" not-null="true"/> + </class> + +</hibernate-mapping> Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Enrolment.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,87 @@ +//$Id: Enrolment.java 6970 2005-05-31 20:24:41Z oneovthafew $ +package org.hibernate.test.querycache; + +import java.io.Serializable; + +/** + * @author Gavin King + */ +public class Enrolment implements Serializable { + private Student student; + private Course course; + private long studentNumber; + private String courseCode; + private short year; + private short semester; + + public String getCourseCode() { + return courseCode; + } + public void setCourseCode(String courseId) { + this.courseCode = courseId; + } + public long getStudentNumber() { + return studentNumber; + } + public void setStudentNumber(long studentId) { + this.studentNumber = studentId; + } + public Course getCourse() { + return course; + } + public void setCourse(Course course) { + this.course = course; + } + public Student getStudent() { + return student; + } + public void setStudent(Student student) { + this.student = student; + } + public short getSemester() { + return semester; + } + public void setSemester(short semester) { + this.semester = semester; + } + public short getYear() { + return year; + } + public void setYear(short year) { + this.year = year; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || getClass() != o.getClass() ) { + return false; + } + + Enrolment enrolment = ( Enrolment ) o; + + if ( semester != enrolment.semester ) { + return false; + } + if ( studentNumber != enrolment.studentNumber ) { + return false; + } + if ( year != enrolment.year ) { + return false; + } + if ( courseCode != null ? !courseCode.equals( enrolment.courseCode ) : enrolment.courseCode != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = ( int ) ( studentNumber ^ ( studentNumber >>> 32 ) ); + result = 31 * result + ( courseCode != null ? courseCode.hashCode() : 0 ); + result = 31 * result + ( int ) year; + result = 31 * result + ( int ) semester; + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheIgnoreResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheIgnoreResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheIgnoreResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,73 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import junit.framework.Test; + +import org.hibernate.CacheMode; +import org.hibernate.testing.junit.functional.FunctionalTestClassTestSuite; + +/** + * @author Gail Badner + */ +public class HqlQueryCacheIgnoreResultTransformerTest extends AbstractQueryCacheResultTransformerTest { + + public HqlQueryCacheIgnoreResultTransformerTest(String str) { + super( str ); + } + + public static Test suite() { + return new FunctionalTestClassTestSuite( HqlQueryCacheIgnoreResultTransformerTest.class ); + } + + protected CacheMode getQueryCacheMode() { + return CacheMode.IGNORE; + } + + protected void runTest(HqlExecutor hqlExecutor, CriteriaExecutor criteriaExecutor, ResultChecker checker, boolean isSingleResult) + throws Exception { + createData(); + if ( hqlExecutor != null ) { + runTest( hqlExecutor, checker, isSingleResult ); + } + deleteData(); + } + + public void testAliasToEntityMapNoProjectionList() throws Exception { + reportSkip( "known to fail using HQL", "HQL query using Transformers.ALIAS_TO_ENTITY_MAP with no projection" ); + } + + public void testAliasToEntityMapNoProjectionListFailureExpected() throws Exception { + super.testAliasToEntityMapNoProjectionList(); + } + + public void testAliasToEntityMapNoProjectionMultiAndNullList() throws Exception { + reportSkip( "known to fail using HQL", "HQL query using Transformers.ALIAS_TO_ENTITY_MAP with no projection" ); + } + + public void testAliasToEntityMapNoProjectionMultiAndNullListFailureExpected() throws Exception { + super.testAliasToEntityMapNoProjectionMultiAndNullList(); + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheNormalResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheNormalResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCacheNormalResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,73 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import junit.framework.Test; + +import org.hibernate.CacheMode; +import org.hibernate.testing.junit.functional.FunctionalTestClassTestSuite; + +/** + * @author Gail Badner + */ +public class HqlQueryCacheNormalResultTransformerTest extends HqlQueryCachePutResultTransformerTest { + + public HqlQueryCacheNormalResultTransformerTest(String str) { + super( str ); + } + + public static Test suite() { + return new FunctionalTestClassTestSuite( HqlQueryCacheNormalResultTransformerTest.class ); + } + + protected CacheMode getQueryCacheMode() { + return CacheMode.NORMAL; + } + + public void testAliasToBeanDtoMultiArgList() { + reportSkip( "Results from queries using Transformers.aliasToBean cannot be found in the cache due to bug in hashCode", + "Query using Transformers.aliasToBean with cache" + ); + } + public void testAliasToBeanDtoMultiArgListFailureExpected() throws Exception { + super.testAliasToBeanDtoMultiArgList(); + } + + public void testAliasToBeanDtoLiteralArgList() { + reportSkip( "Results from queries using Transformers.aliasToBean cannot be found in the cache due to bug in hashCode", + "Query using Transformers.aliasToBean with cache" ); + } + public void testAliasToBeanDtoLiteralArgListFailureExpected() throws Exception { + super.testAliasToBeanDtoLiteralArgList(); + } + + public void testAliasToBeanDtoWithNullAliasList() { + reportSkip( "Results from queries using Transformers.aliasToBean cannot be found in the cache due to bug in hashCode", + "Query using Transformers.aliasToBean with cache" ); + } + public void testAliasToBeanDtoWithNullAliasListFailureExpected() throws Exception { + super.testAliasToBeanDtoWithNullAliasList(); + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCachePutResultTransformerTest.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCachePutResultTransformerTest.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/HqlQueryCachePutResultTransformerTest.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,78 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +import junit.framework.Test; + +import org.hibernate.CacheMode; +import org.hibernate.testing.junit.functional.FunctionalTestClassTestSuite; + +/** + * @author Gail Badner + */ +public class HqlQueryCachePutResultTransformerTest extends HqlQueryCacheIgnoreResultTransformerTest { + + public HqlQueryCachePutResultTransformerTest(String str) { + super( str ); + } + + public static Test suite() { + return new FunctionalTestClassTestSuite( HqlQueryCachePutResultTransformerTest.class ); + } + + + protected CacheMode getQueryCacheMode() { + return CacheMode.PUT; + } + + protected boolean areDynamicNonLazyAssociationsChecked() { + return false; + } + + public void testAliasToEntityMapOneProjectionList() { + reportSkip( "HQL queries using a ResultTransformer are known to fail when caching a row with a single value", + "HQL queries using a ResultTransformer has row with a single value"); + } + public void testAliasToEntityMapOneProjectionListFailureExpected() throws Exception { + super.testAliasToEntityMapOneProjectionList(); + } + + public void testAliasToBeanDtoOneArgList() { + reportSkip( "HQL queries using a ResultTransformer are known to fail when caching a row with a single value", + "HQL queries using a ResultTransformer has row with a single value"); + } + + public void testAliasToBeanDtoOneArgListFailureExpected() throws Exception { + super.testAliasToBeanDtoOneArgList(); + } + + public void testOneSelectNewList() { + reportSkip( "HQL queries using a ResultTransformer are known to fail when caching a row with a single value", + "HQL queries using a ResultTransformer has row with a single value"); + } + public void testOneSelectNewListFailureExpected() throws Exception { + super.testOneSelectNewList(); + } +} Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/PersonName.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/PersonName.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/PersonName.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,96 @@ +/* + * Hibernate, Relational Persistence for Idiomatic Java + * + * Copyright (c) 2010, Red Hat Middleware LLC or third-party contributors as + * indicated by the @author tags or express copyright attribution + * statements applied by the authors. All third-party contributions are + * distributed under license by Red Hat Middleware LLC. + * + * This copyrighted material is made available to anyone wishing to use, modify, + * copy, or redistribute it subject to the terms and conditions of the GNU + * Lesser General Public License, as published by the Free Software Foundation. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY + * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License + * for more details. + * + * You should have received a copy of the GNU Lesser General Public License + * along with this distribution; if not, write to: + * Free Software Foundation, Inc. + * 51 Franklin Street, Fifth Floor + * Boston, MA 02110-1301 USA + * + */ +package org.hibernate.test.querycache; + +/** + * @author Gail Badner + */ + +public class PersonName { + private String first; + private String middle; + private String last; + + public PersonName() {} + + public PersonName(String first, String middle, String state) { + this.first = first; + this.middle = middle; + this.last = state; + } + + public String getFirst() { + return first; + } + + public void setFirst(String first) { + this.first = first; + } + + public String getMiddle() { + return middle; + } + + public void setMiddle(String middle) { + this.middle = middle; + } + + public String getLast() { + return last; + } + + public void setLast(String last) { + this.last = last; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || getClass() != o.getClass() ) { + return false; + } + + PersonName name = ( PersonName ) o; + + if ( first != null ? !first.equals( name.first ) : name.first != null ) { + return false; + } + if ( middle != null ? !middle.equals( name.middle ) : name.middle != null ) { + return false; + } + if ( last != null ? !last.equals( name.last ) : name.last != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = first != null ? first.hashCode() : 0; + result = 31 * result + ( last != null ? last.hashCode() : 0 ); + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Student.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Student.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/Student.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,102 @@ +//$Id: Student.java 9116 2006-01-23 21:21:01Z steveebersole $ +package org.hibernate.test.querycache; + +import java.util.ArrayList; +import java.util.HashMap; +import java.util.HashSet; +import java.util.List; +import java.util.Map; +import java.util.Set; + +/** + * @author Gavin King + */ +public class Student { + private long studentNumber; + private PersonName name; + private Course preferredCourse; + private Set enrolments = new HashSet(); + private Map addresses = new HashMap(); + private List secretCodes = new ArrayList(); + + public Student() {} + + public Student(long studentNumber, PersonName name) { + this.studentNumber = studentNumber; + this.name = name; + } + + public PersonName getName() { + return name; + } + + public void setName(PersonName name) { + this.name = name; + } + + public long getStudentNumber() { + return studentNumber; + } + + public void setStudentNumber(long studentNumber) { + this.studentNumber = studentNumber; + } + + public Map getAddresses() { + return addresses; + } + + public void setAddresses(Map addresses) { + this.addresses = addresses; + } + + public Course getPreferredCourse() { + return preferredCourse; + } + + public void setPreferredCourse(Course preferredCourse) { + this.preferredCourse = preferredCourse; + } + + public Set getEnrolments() { + return enrolments; + } + + public void setEnrolments(Set employments) { + this.enrolments = employments; + } + + public List getSecretCodes() { + return secretCodes; + } + + public void setSecretCodes(List secretCodes) { + this.secretCodes = secretCodes; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || ! ( o instanceof Student ) ) { + return false; + } + + Student student = ( Student ) o; + + if ( studentNumber != student.getStudentNumber() ) { + return false; + } + if ( name != null ? !name.equals( student.getName() ) : student.getName() != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = ( int ) ( studentNumber ^ ( studentNumber >>> 32 ) ); + result = 31 * result + ( name != null ? name.hashCode() : 0 ); + return result; + } +} \ No newline at end of file Added: core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/StudentDTO.java =================================================================== --- core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/StudentDTO.java (rev 0) +++ core/trunk/testsuite/src/test/java/org/hibernate/test/querycache/StudentDTO.java 2010-07-28 18:55:13 UTC (rev 20074) @@ -0,0 +1,60 @@ +/* + * Created on 28-Jan-2005 + * + */ +package org.hibernate.test.querycache; + +/** + * @author max + * + */ +public class StudentDTO { + + private PersonName studentName; + private String courseDescription; + + public StudentDTO() { } + + public StudentDTO(PersonName name) { + this.studentName = name; + } + + public StudentDTO(PersonName name, String description) { + this.studentName = name; + this.courseDescription = description; + } + + public PersonName getName() { + return studentName; + } + + public String getDescription() { + return courseDescription; + } + + public boolean equals(Object o) { + if ( this == o ) { + return true; + } + if ( o == null || getClass() != o.getClass() ) { + return false; + } + + StudentDTO that = ( StudentDTO ) o; + + if ( courseDescription != null ? !courseDescription.equals( that.courseDescription ) : that.courseDescription != null ) { + return false; + } + if ( studentName != null ? !studentName.equals( that.studentName ) : that.studentName != null ) { + return false; + } + + return true; + } + + public int hashCode() { + int result = studentName != null ? studentName.hashCode() : 0; + result = 31 * result + ( courseDescription != null ? courseDescription.hashCode() : 0 ); + return result; + } +} \ No newline at end of file