* Hibernate, Relational Persistence for Idiomatic Java
 * JBoss, Home of Professional Open Source
 * Copyright 2014 Red Hat Inc. and/or its affiliates and other contributors
 * as indicated by the @authors tag. All rights reserved.
 * See the copyright.txt in the distribution for a
 * full listing of individual contributors.
 * 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, v. 2.1.
 * This program is distributed in the hope that it will be useful, but WITHOUT A
 * 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,
 * v.2.1 along with this distribution; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA  02110-1301, USA.
package org.hibernate.brmeyer.demo.fetchstyle;

import java.util.List;

import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.brmeyer.demo.AbstractLazyDemo;
import org.hibernate.brmeyer.demo.entity.lazy.User;
import org.hibernate.criterion.Restrictions;

 * @author Brett Meyer
public class Subselect extends AbstractLazyDemo {

	public List<User> getUsers() {
		final Session session = openSession();

		final List<User> users = session
				.createCriteria( User.class )
				.add( Restrictions.gt( "id", 0 ) )
		// init (#skills uses @Fetch(SUBSELECT))
		users.get( 0 ).getSkills().size();
		// NOTE: All skills, for all returned Users, will be initialized automatically!!!

		return users;

	public static void main(String[] args) {
		final Subselect demo = new Subselect();
		final List<User> users = demo.getUsers();
		// ensure it was fetched
		for ( final User user : users ) {
			System.out.println( "fetched: " + Hibernate.isInitialized( user.getSkills() ) );