Example usage for org.hibernate StatelessSession close

Introduction

In this page you can find the example usage for org.hibernate StatelessSession close.

Prototype

void close();

Source Link

Document

Close the stateless session and release the JDBC connection.

Usage

From source file:org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker.java

License:Open Source License

protected void closeSQLSession(StatelessSession session) {
    try {/*from  w ww  .ja  va2 s. c  o  m*/
        if (session != null) {
            session.close();
        }
    } catch (Exception e) {
        //log.debug("Unable to close SQL stateless session. " + e);
    }
}

From source file:org.server.core.UserCenter.java

public boolean checkedNameAndPassWord(String name, String password) {
    StatelessSession statelessSession = DataSource.openStatelessSession();
    Userbasicinfo uniqueResult = (Userbasicinfo) statelessSession
            .createQuery("from Userbasicinfo where userName=:name and userPass=md5(:pwd)")
            .setString("name", name).setString("pwd", password).setMaxResults(1).uniqueResult();
    statelessSession.close();
    return uniqueResult != null;
}

From source file:org.squashtest.tm.service.internal.api.repository.HibernateSqlQueryRunner.java

License:Open Source License

private <T> T executeQuery(String selectQuery, QueryExecution<Query> execution) {
    SessionFactory sessionFactory = entityManagerFactory.unwrap(SessionFactory.class);
    StatelessSession s = sessionFactory.openStatelessSession();
    Transaction tx = s.beginTransaction();

    T res = null;/*  w  w  w  .ja  v a 2  s.c o m*/

    try {
        SQLQuery q = s.createSQLQuery(selectQuery);
        res = execution.<T>executeQuery(q);
        tx.commit();
    } catch (HibernateException e) {
        tx.rollback();
        throw e;
    } finally {
        s.close();

    }

    return res;
}

From source file:org.squashtest.tm.service.internal.campaign.coercers.extenders.CampaignLibraryExtender.java

License:Open Source License

@Override
public Collection<? extends Serializable> doCoerce(Collection<? extends Serializable> ids) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {//from w  w w  . j  a v a2  s .c  o  m
        Query q = s.createQuery(
                "select distinct l.id from CampaignLibrary l join l.rootContent c where c.id in (:clnIds)");
        q.setParameterList("clnIds", ids);
        return q.list();

    } finally {
        tx.commit();
        s.close();
    }
}

From source file:org.squashtest.tm.service.internal.campaign.coercers.extenders.CampaignLibraryNodePathEdgeExtender.java

License:Open Source License

@Override
public Collection<? extends Serializable> doCoerce(Collection<? extends Serializable> coercedIds) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {/*from   ww  w .ja  v  a 2  s. c om*/
        Query q = s.createQuery(
                "select distinct edge.ancestorId from CampaignPathEdge edge where edge.descendantId in (:clnIds) and depth=1");
        q.setParameterList("clnIds", coercedIds);
        coercedIds.addAll(q.list());
        return coercedIds;

    } finally {
        tx.commit();
        s.close();
    }
}

From source file:org.squashtest.tm.service.internal.campaign.coercers.extenders.TestSuiteToIterationExtender.java

License:Open Source License

@Override
public Collection<? extends Serializable> doCoerce(Collection<? extends Serializable> ids) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {/*from w  w  w.  j a v a2 s  . c o  m*/
        Query q = s.createQuery(
                "select distinct i.id from Iteration i join i.testSuites ts where ts.id in (:tsids)");
        q.setParameterList("tsids", ids);
        return q.list();

    } finally {
        tx.commit();
        s.close();
    }
}

From source file:org.squashtest.tm.service.internal.campaign.coercers.IterationToCampaignIdsCoercer.java

License:Open Source License

@Override
public Collection<? extends Serializable> coerce(Object ids) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {/*  ww w  .jav  a2 s.  co  m*/
        Query q = s.createQuery(
                "select distinct c.id from Iteration i join i.campaign c where i.id in (:iterIds)");
        q.setParameterList("iterIds", (Collection<? extends Serializable>) ids);
        return q.list();

    } finally {
        tx.commit();
        s.close();
    }
}

From source file:org.squashtest.tm.service.internal.campaign.coercers.TestSuiteToIterationCoercerForUniqueId.java

License:Open Source License

@Override
public Serializable coerce(Object id) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {//from w w  w  .j a v  a2s.co  m
        Query q = s.createSQLQuery(
                "SELECT DISTINCT iteration_id FROM iteration_test_suite WHERE test_suite_id = :suiteId");
        q.setParameter("suiteId", id);
        return (Serializable) q.uniqueResult();

    } finally {
        tx.commit();
        s.close();
    }
}

From source file:org.squashtest.tm.service.internal.requirement.coercers.extenders.RequirementLibraryExtender.java

License:Open Source License

@Override
public Collection<? extends Serializable> doCoerce(Collection<? extends Serializable> ids) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {/*  w ww .  j  a v a  2  s. c  o  m*/
        Query q = s.createQuery(
                "select distinct l.id from RequirementLibrary l join l.rootContent c where c.id in (:rlnIds) ");
        q.setParameterList("rlnIds", ids);
        return q.list();

    } finally {
        tx.commit();
        s.close();
    }
}

From source file:org.squashtest.tm.service.internal.requirement.coercers.extenders.RequirementLibraryNodePathEdgeExtender.java

License:Open Source License

@Override
public Collection<? extends Serializable> doCoerce(Collection<? extends Serializable> coercedIds) {
    StatelessSession s = hibernateStatelessSessionHelper.openStatelessSession();
    Transaction tx = s.beginTransaction();

    try {//  ww  w  .j av  a2s . com
        Query q = s.createQuery(
                "select distinct edge.ancestorId from RequirementPathEdge edge where edge.descendantId in (:rlnIds) and depth=1");
        q.setParameterList("rlnIds", coercedIds);
        coercedIds.addAll(q.list());
        return coercedIds;

    } finally {
        tx.commit();
        s.close();
    }
}