Example usage for org.hibernate Session getNamedQuery

Introduction

In this page you can find the example usage for org.hibernate Session getNamedQuery.

Prototype

org.hibernate.Query getNamedQuery(String queryName);

Source Link

Document

Create a Query instance for the named query.

Usage

From source file:com.model.database.onebusaway.gtfs.hibernate.ext.HibernateOperationsImplExt.java

License:Open Source License

public <T> void updateByNamedQueryAndNamedParams(final String namedQuery, final String[] paramNames,
        final Object[] values) {
    execute(new HibernateOperation() {

        //Session session = _sessionFactory.openSession();
        //Transaction tx = session.beginTransaction();
        @Override//from w  ww  .  ja  v  a 2  s . com
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Query queryObject = session.getNamedQuery(namedQuery);
            if (values != null) {
                for (int i = 0; i < values.length; i++)
                    applyNamedParameterToQuery(queryObject, paramNames[i], values[i]);
            }
            //Transaction tx = session.beginTransaction();
            Object result = queryObject.executeUpdate();
            //tx.commit();
            //session.close();
            return result;
        }
    });
}

From source file:com.nec.crud.CrudRepositoryImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override//ww  w.j av a 2 s.c om
public Query getNamedQuery(final Session session, String query) {
    return session.getNamedQuery(query);
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

public RiskRun getRiskRunById(final Long id) {
    return getHibernateTemplate().execute(new HibernateCallback<RiskRun>() {
        @Override//  w  w  w  .ja  v a2 s  .  c o  m
        public RiskRun doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.getNamedQuery("RiskRun.one.byId");
            query.setLong("id", id);
            return (RiskRun) query.uniqueResult();
        }
    });
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected ComputeHost getOrCreateComputeHost(final String hostName) {
    ComputeHost computeHost = getHibernateTemplate().execute(new HibernateCallback<ComputeHost>() {
        @Override/* w  ww .  j a  v  a  2  s.  co  m*/
        public ComputeHost doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.getNamedQuery("ComputeHost.one.byHostName");
            query.setString("hostName", hostName);
            return (ComputeHost) query.uniqueResult();
        }
    });
    if (computeHost == null) {
        computeHost = new ComputeHost();
        computeHost.setHostName(hostName);
        getHibernateTemplate().save(computeHost);
        getHibernateTemplate().flush();
    }
    return computeHost;
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected ComputeNode getOrCreateComputeNode(final String nodeId) {
    ArgumentChecker.notNull(nodeId, "nodeId");
    String hostName = nodeId;// ww w  .j  av  a  2  s  .c  o m
    int slashIndex = nodeId.indexOf('/'); // e.g., mymachine-t5500/0/1, see LocalCalculationNode.java. Should refactor nodeId to a class with two strings, host and node id
    if (slashIndex != -1) {
        hostName = nodeId.substring(0, slashIndex);
    }
    final ComputeHost host = getOrCreateComputeHost(hostName);

    ComputeNode node = getHibernateTemplate().execute(new HibernateCallback<ComputeNode>() {
        @Override
        public ComputeNode doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.getNamedQuery("ComputeNode.one.byNodeName");
            query.setString("nodeName", nodeId);
            return (ComputeNode) query.uniqueResult();
        }
    });
    if (node == null) {
        node = new ComputeNode();
        node.setComputeHost(host);
        node.setNodeName(nodeId);
        getHibernateTemplate().save(node);
        getHibernateTemplate().flush();
    }
    return node;
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected LiveDataField getLiveDataField(final String fieldName) {
    LiveDataField field = getHibernateTemplate().execute(new HibernateCallback<LiveDataField>() {
        @Override/* w  w  w .j  a  va  2s .  co  m*/
        public LiveDataField doInHibernate(Session session) throws HibernateException, SQLException {
            Query query = session.getNamedQuery("LiveDataField.one.byName");
            query.setString("name", fieldName);
            return (LiveDataField) query.uniqueResult();
        }
    });
    if (field == null) {
        field = new LiveDataField();
        field.setName(fieldName);
        getHibernateTemplate().save(field);
        getHibernateTemplate().flush();
    }
    return field;
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected HbComputationTargetSpecification getComputationTargetIntransaction(
        final ComputationTargetSpecification spec) {
    return getHibernateTemplate().execute(new HibernateCallback<HbComputationTargetSpecification>() {
        @Override//from   w  ww  . ja  va  2  s  .co m
        public HbComputationTargetSpecification doInHibernate(Session session)
                throws HibernateException, SQLException {
            Query query = session.getNamedQuery("ComputationTargetSpecification.one.byTypeAndUid");

            query.setString("uidScheme", spec.getUniqueId().getScheme());
            query.setString("uidValue", spec.getUniqueId().getValue());
            query.setString("uidVersion", spec.getUniqueId().getVersion());

            query.setParameter("type", spec.getType());

            return (HbComputationTargetSpecification) query.uniqueResult();
        }
    });
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected CalculationConfiguration getCalculationConfiguration(final String name) {
    CalculationConfiguration calcConfig = getHibernateTemplate()
            .execute(new HibernateCallback<CalculationConfiguration>() {
                @Override//from www  .  j ava2  s  .  c o m
                public CalculationConfiguration doInHibernate(Session session)
                        throws HibernateException, SQLException {
                    Query query = session.getNamedQuery("CalculationConfiguration.one.byName");
                    query.setString("name", name);
                    return (CalculationConfiguration) query.uniqueResult();
                }
            });
    if (calcConfig == null) {
        calcConfig = new CalculationConfiguration();
        calcConfig.setName(name);
        getHibernateTemplate().save(calcConfig);
        getHibernateTemplate().flush();
    }
    return calcConfig;
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected RiskValueRequirement getRiskValueRequirement(final ValueProperties requirement) {
    final String synthesizedForm = RiskValueRequirement.synthesize(requirement);
    RiskValueRequirement riskValueRequirement = getHibernateTemplate()
            .execute(new HibernateCallback<RiskValueRequirement>() {
                @Override/* w  w w .j  av  a 2  s  .c  o  m*/
                public RiskValueRequirement doInHibernate(Session session)
                        throws HibernateException, SQLException {
                    Query query = session.getNamedQuery("RiskValueRequirement.one.bySynthesizedForm");
                    query.setString("requirement", synthesizedForm);
                    return (RiskValueRequirement) query.uniqueResult();
                }
            });
    if (riskValueRequirement == null) {
        riskValueRequirement = new RiskValueRequirement(requirement);
        getHibernateTemplate().save(riskValueRequirement);
        getHibernateTemplate().flush();
    }
    return riskValueRequirement;
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

protected RiskValueSpecification getRiskValueSpecification(final ValueProperties specification) {
    final String synthesizedForm = RiskValueSpecification.synthesize(specification);
    RiskValueSpecification riskValueSpecification = getHibernateTemplate()
            .execute(new HibernateCallback<RiskValueSpecification>() {
                @Override/*w ww  .jav a  2s  . c  o m*/
                public RiskValueSpecification doInHibernate(Session session)
                        throws HibernateException, SQLException {
                    Query query = session.getNamedQuery("RiskValueSpecification.one.bySynthesizedForm");
                    query.setString("specification", synthesizedForm);
                    return (RiskValueSpecification) query.uniqueResult();
                }
            });
    if (riskValueSpecification == null) {
        riskValueSpecification = new RiskValueSpecification(specification);
        getHibernateTemplate().save(riskValueSpecification);
        getHibernateTemplate().flush();
    }
    return riskValueSpecification;
}