/*
* Hibernate, Relational Persistence for Idiomatic Java
*
* Copyright (c) 2011, Red Hat Inc. 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 Inc.
*
* 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.annotations.naturalid;
import org.junit.Assert;
import org.junit.Test;
import org.hibernate.Criteria;
import org.hibernate.FetchMode;
import org.hibernate.FlushMode;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.Environment;
import org.hibernate.criterion.Restrictions;
import org.hibernate.sql.JoinType;
import org.hibernate.testing.TestForIssue;
import org.hibernate.testing.junit4.BaseCoreFunctionalTestCase;
/**
* @author Guenther Demetz
*/
public class ImmutableNaturalKeyLookupTest extends BaseCoreFunctionalTestCase {
@TestForIssue(jiraKey = "HHH-4838")
@Test
public void testSimpleImmutableNaturalKeyLookup() {
Session s = openSession();
Transaction newTx = s.getTransaction();
newTx.begin();
A a1 = new A();
a1.setName( "name1" );
s.persist( a1 );
newTx.commit();
newTx = s.beginTransaction();
getCriteria( s ).uniqueResult(); // put query-result into cache
A a2 = new A();
a2.setName( "xxxxxx" );
s.persist( a2 );
newTx.commit(); // Invalidates space A in UpdateTimeStamps region
newTx = s.beginTransaction();
// please enable
// log4j.logger.org.hibernate.cache.StandardQueryCache=DEBUG
// log4j.logger.org.hibernate.cache.UpdateTimestampsCache=DEBUG
// to see that isUpToDate is called where not appropriated
Assert.assertTrue( s.getSessionFactory().getStatistics().isStatisticsEnabled() );
s.getSessionFactory().getStatistics().clear();
getCriteria( s ).uniqueResult(); // should produce a hit in StandardQuery cache region
Assert.assertEquals(
"query is not considered as isImmutableNaturalKeyLookup, despite fullfilling all conditions",
1, s.getSessionFactory().getStatistics().getQueryCacheHitCount()
);
s.createQuery( "delete from A" ).executeUpdate();
newTx.commit();
// Shutting down the application
s.close();
}
@TestForIssue(jiraKey = "HHH-4838")
@Test
public void testNaturalKeyLookupWithConstraint() {
Session s = openSession();
Transaction newTx = s.getTransaction();
newTx.begin();
A a1 = new A();
a1.setName( "name1" );
s.persist( a1 );
newTx.commit();
newTx = s.beginTransaction();
getCriteria( s ).add( Restrictions.isNull( "singleD" ) ).uniqueResult(); // put query-result into cache
A a2 = new A();
a2.setName( "xxxxxx" );
s.persist( a2 );
newTx.commit(); // Invalidates space A in UpdateTimeStamps region
newTx = s.beginTransaction();
// please enable
// log4j.logger.org.hibernate.cache.StandardQueryCache=DEBUG
// log4j.logger.org.hibernate.cache.UpdateTimestampsCache=DEBUG
// to see that isUpToDate is called where not appropriated
Assert.assertTrue( s.getSessionFactory().getStatistics().isStatisticsEnabled() );
s.getSessionFactory().getStatistics().clear();
// should not produce a hit in StandardQuery cache region because there is a constraint
getCriteria( s ).add( Restrictions.isNull( "singleD" ) ).uniqueResult();
Assert.assertEquals( 0, s.getSessionFactory().getStatistics().getQueryCacheHitCount() );
s.createQuery( "delete from A" ).executeUpdate();
newTx.commit();
// Shutting down the application
s.close();
}
@TestForIssue(jiraKey = "HHH-4838")
@Test
public void testCriteriaWithFetchModeJoinCollection() {
Session s = openSession();
Transaction newTx = s.getTransaction();
newTx.begin();
A a1 = new A();
a1.setName( "name1" );
D d1 = new D();
a1.getDs().add( d1 );
d1.setA( a1 );
s.persist( d1 );
s.persist( a1 );
newTx.commit();
newTx = s.beginTransaction();
getCriteria( s ).setFetchMode( "ds", FetchMode.JOIN ).uniqueResult(); // put query-result into cache
A a2 = new A();
a2.setName( "xxxxxx" );
s.persist( a2 );
newTx.commit(); // Invalidates space A in UpdateTimeStamps region
newTx = s.beginTransaction();
// please enable
// log4j.logger.org.hibernate.cache.StandardQueryCache=DEBUG
// log4j.logger.org.hibernate.cache.UpdateTimestampsCache=DEBUG
// to see that isUpToDate is called where not appropriated
Assert.assertTrue( s.getSessionFactory().getStatistics().isStatisticsEnabled() );
s.getSessionFactory().getStatistics().clear();
// should produce a hit in StandardQuery cache region
getCriteria( s ).setFetchMode( "ds", FetchMode.JOIN ).uniqueResult();
Assert.assertEquals(
"query is not considered as isImmutableNaturalKeyLookup, despite fullfilling all conditions",
1, s.getSessionFactory().getStatistics().getQueryCacheHitCount()
);
s.createQuery( "delete from D" ).executeUpdate();
s.createQuery( "delete from A" ).executeUpdate();
newTx.commit();
// Shutting down the application
s.close();
}
@TestForIssue(jiraKey = "HHH-4838")
@Test
public void testCriteriaWithFetchModeJoinOnetoOne() {
Session s = openSession();
Transaction newTx = s.getTransaction();
newTx.begin();
A a1 = new A();
a1.setName( "name1" );
D d1 = new D();
a1.setSingleD( d1 );
d1.setSingleA( a1 );
s.persist( d1 );
s.persist( a1 );
newTx.commit();
newTx = s.beginTransaction();
getCriteria( s ).setFetchMode( "singleD", FetchMode.JOIN ).uniqueResult(); // put query-result into cache
A a2 = new A();
a2.setName( "xxxxxx" );
s.persist( a2 );
newTx.commit(); // Invalidates space A in UpdateTimeStamps region
newTx = s.beginTransaction();
// please enable
// log4j.logger.org.hibernate.cache.StandardQueryCache=DEBUG
// log4j.logger.org.hibernate.cache.UpdateTimestampsCache=DEBUG
// to see that isUpToDate is called where not appropriated
Assert.assertTrue( s.getSessionFactory().getStatistics().isStatisticsEnabled() );
s.getSessionFactory().getStatistics().clear();
// should produce a hit in StandardQuery cache region
getCriteria( s ).setFetchMode( "singleD", FetchMode.JOIN ).uniqueResult();
Assert.assertEquals(
"query is not considered as isImmutableNaturalKeyLookup, despite fullfilling all conditions",
1, s.getSessionFactory().getStatistics().getQueryCacheHitCount()
);
s.createQuery( "delete from A" ).executeUpdate();
s.createQuery( "delete from D" ).executeUpdate();
newTx.commit();
// Shutting down the application
s.close();
}
@TestForIssue(jiraKey = "HHH-4838")
@Test
public void testCriteriaWithAliasOneToOneJoin() {
Session s = openSession();
Transaction newTx = s.getTransaction();
newTx.begin();
A a1 = new A();
a1.setName( "name1" );
D d1 = new D();
a1.setSingleD( d1 );
d1.setSingleA( a1 );
s.persist( d1 );
s.persist( a1 );
newTx.commit();
newTx = s.beginTransaction();
getCriteria( s ).createAlias( "singleD", "d", JoinType.LEFT_OUTER_JOIN )
.uniqueResult(); // put query-result into cache
A a2 = new A();
a2.setName( "xxxxxx" );
s.persist( a2 );
newTx.commit(); // Invalidates space A in UpdateTimeStamps region
newTx = s.beginTransaction();
// please enable
// log4j.logger.org.hibernate.cache.StandardQueryCache=DEBUG
// log4j.logger.org.hibernate.cache.UpdateTimestampsCache=DEBUG
// to see that isUpToDate is called where not appropriated
Assert.assertTrue( s.getSessionFactory().getStatistics().isStatisticsEnabled() );
s.getSessionFactory().getStatistics().clear();
// should not produce a hit in StandardQuery cache region because createAlias() creates a subcriteria
getCriteria( s ).createAlias( "singleD", "d", JoinType.LEFT_OUTER_JOIN ).uniqueResult();
Assert.assertEquals( 0, s.getSessionFactory().getStatistics().getQueryCacheHitCount() );
s.createQuery( "delete from A" ).executeUpdate();
s.createQuery( "delete from D" ).executeUpdate();
newTx.commit();
// Shutting down the application
s.close();
}
@TestForIssue(jiraKey = "HHH-4838")
@Test
public void testSubCriteriaOneToOneJoin() {
Session s = openSession();
Transaction newTx = s.getTransaction();
newTx.begin();
A a1 = new A();
a1.setName( "name1" );
D d1 = new D();
a1.setSingleD( d1 );
d1.setSingleA( a1 );
s.persist( d1 );
s.persist( a1 );
newTx.commit();
newTx = s.beginTransaction();
getCriteria( s ).createCriteria( "singleD", "d", JoinType.LEFT_OUTER_JOIN )
.uniqueResult(); // put query-result into cache
A a2 = new A();
a2.setName( "xxxxxx" );
s.persist( a2 );
newTx.commit(); // Invalidates space A in UpdateTimeStamps region
newTx = s.beginTransaction();
// please enable
// log4j.logger.org.hibernate.cache.StandardQueryCache=DEBUG
// log4j.logger.org.hibernate.cache.UpdateTimestampsCache=DEBUG
// to see that isUpToDate is called where not appropriated
Assert.assertTrue( s.getSessionFactory().getStatistics().isStatisticsEnabled() );
s.getSessionFactory().getStatistics().clear();
// should not produce a hit in StandardQuery cache region because createCriteria() creates a subcriteria
getCriteria( s ).createCriteria( "singleD", "d", JoinType.LEFT_OUTER_JOIN ).uniqueResult();
Assert.assertEquals( 0, s.getSessionFactory().getStatistics().getQueryCacheHitCount() );
s.createQuery( "delete from A" ).executeUpdate();
s.createQuery( "delete from D" ).executeUpdate();
newTx.commit();
// Shutting down the application
s.close();
}
private Criteria getCriteria(Session s) {
Criteria crit = s.createCriteria( A.class, "anAlias" );
crit.add( Restrictions.naturalId().set( "name", "name1" ) );
crit.setFlushMode( FlushMode.COMMIT );
crit.setCacheable( true );
return crit;
}
@Override
protected Class[] getAnnotatedClasses() {
return new Class[] {
A.class,
D.class
};
}
@Override
protected void configure(Configuration cfg) {
cfg.setProperty( Environment.GENERATE_STATISTICS, "true" );
cfg.setProperty( Environment.USE_QUERY_CACHE, "true" );
}
}