/*
* JBoss, Home of Professional Open Source.
* Copyright 2012, Red Hat, Inc., and individual contributors
* as indicated by the @author tags. See the copyright.txt file in the
* distribution for a full listing of individual contributors.
*
* This is free software; you can redistribute it and/or modify it
* under the terms of the GNU Lesser General Public License as
* published by the Free Software Foundation; either version 2.1 of
* the License, or (at your option) any later version.
*
* This software 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 software; if not, write to the Free
* Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
* 02110-1301 USA, or see the FSF site: http://www.fsf.org.
*/
package org.jboss.as.test.integration.hibernate;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Properties;
import java.util.Set;
import javax.annotation.PreDestroy;
import javax.ejb.Stateful;
import javax.ejb.TransactionManagement;
import javax.ejb.TransactionManagementType;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.AvailableSettings;
import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.Environment;
import org.hibernate.criterion.Property;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.hibernate.engine.transaction.jta.platform.internal.JBossAppServerJtaPlatform;
import org.hibernate.internal.util.config.ConfigurationHelper;
import org.hibernate.jpa.internal.metamodel.MetamodelImpl;
import org.hibernate.stat.Statistics;
/**
* Test Criteria API with native Hibernate and also test that Hibernate statistics is able to fetch all kinds of queries
*
* @author Madhumita Sadhukhan
*/
@Stateful
@TransactionManagement(TransactionManagementType.BEAN)
public class SFSBHibernatewithCriteriaSession {
private static SessionFactory sessionFactory;
protected static final Class[] NO_CLASSES = new Class[0];
protected static final String NO_MAPPINGS = new String();
public void cleanup() {
sessionFactory.close();
}
public void setupConfig() {
// static {
try {
// prepare the configuration
Configuration configuration = new Configuration().setProperty(AvailableSettings.USE_NEW_ID_GENERATOR_MAPPINGS,
"true");
configuration.getProperties().put(AvailableSettings.JTA_PLATFORM, JBossAppServerJtaPlatform.class);
configuration.setProperty(Environment.HBM2DDL_AUTO, "create-drop");
configuration.setProperty(Environment.DATASOURCE, "java:jboss/datasources/ExampleDS");
configuration.setProperty("hibernate.listeners.envers.autoRegister", "false");
// fetch the properties
Properties properties = new Properties();
configuration = configuration.configure("hibernate.cfg.xml");
properties.putAll(configuration.getProperties());
Environment.verifyProperties(properties);
ConfigurationHelper.resolvePlaceHolders(properties);
// build the serviceregistry
StandardServiceRegistryBuilder registry = new StandardServiceRegistryBuilder().applySettings(properties);
sessionFactory = configuration.buildSessionFactory(registry.build());
// build metamodel
SessionFactoryImplementor sfi = (SessionFactoryImplementor) sessionFactory;
MetamodelImpl.buildMetamodel(configuration.getClassMappings(), sfi);
sessionFactory.getStatistics().setStatisticsEnabled(true);
} catch (Throwable ex) { // Make sure you log the exception, as it might be swallowed
System.err.println("Initial SessionFactory creation failed." + ex);
// ex.printStackTrace();
throw new ExceptionInInitializerError(ex);
}
}
// create planet
public Planet prepareData(String planetName, String galaxyName, String starName, Set<Satellite> satellites, Integer id) {
Session session = sessionFactory.openSession();
Planet planet = new Planet();
planet.setPlanetId(id);
planet.setPlanetName(planetName);
planet.setGalaxy(galaxyName);
planet.setStar(starName);
Transaction trans = session.beginTransaction();
try {
session.save(planet);
if (satellites != null && satellites.size() > 0) {
Iterator<Satellite> itrSat = satellites.iterator();
while (itrSat.hasNext()) {
Satellite sat = itrSat.next();
session.save(sat);
}
planet.setSatellites(new HashSet<Satellite>());
planet.getSatellites().addAll(satellites);
}
session.saveOrUpdate(planet);
// session.flush();
// session.close();
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("transactional failure while persisting planet entity", e);
}
trans.commit();
// session.close();
return planet;
}
// fetch HQL for Planet
public Query fetchwithHQL() {
Session session = sessionFactory.openSession();
String SQL_QUERY = "from Planet planet";
Query query = session.createQuery(SQL_QUERY);
for (Iterator it = query.iterate(); it.hasNext();) {
Planet planet = (Planet) it.next();
System.out.println("ID from HQL: " + planet.getPlanetId());
}
return query;
}
// fetch Criteria Query for Planet
public List fetchwithCriteria() {
Session session = sessionFactory.openSession();
List query = session.createCriteria(Planet.class).add(Property.forName("planetName").like("E%")).list();
return query;
}
// fetch statistics
public Statistics getStatistics() {
Statistics sessionStats = sessionFactory.getStatistics();
return sessionStats;
}
}