.append(" VALUES('").append(parentId).append("','").append(childId).append("')"); s.createSQLQuery(query.toString()).executeUpdate();
/** * On native update. * * @param query * the query * @param parameterMap * the parameter map * @return the int */ public int onNativeUpdate(String query, Map<Parameter, Object> parameterMap) { s = getStatelessSession(); Query q = s.createSQLQuery(query); setParameters(parameterMap, q); // Transaction tx = s.getTransaction() == null ? s.beginTransaction(): // s.getTransaction(); // tx.begin(); int i = q.executeUpdate(); // tx.commit(); return i; }
try session.createSQLQuery("Drop table " + metadata.getTableName()).executeUpdate();
SQLQuery q = s.createSQLQuery(nativeQuery).addEntity(m.getEntityClazz());
@Override public SQLQuery createSQLQuery(String queryString) { return session.createSQLQuery(queryString); }
SQLQuery q = s.createSQLQuery(nativeQuery); q.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);
@Override public SQLQuery createSQLQuery(String queryString) { return session.createSQLQuery(queryString); }
@Override public SQLQuery createSQLQuery(String queryString) throws HibernateException { return this.raw.createSQLQuery(queryString); }
StatelessSession session = sessionFactory.openStatelessSession(); Query query = session.createSQLQuery(queryStr).setCacheable(false).setFetchSize(Integer.MIN_VALUE).setReadOnly(true); query.setParameter(query_param_key, query_paramter_value); ScrollableResults resultSet = query.scroll(ScrollMode.FORWARD_ONLY);
public void deleteByColumn(String schemaName, String tableName, String columnName, Object columnValue) { StringBuffer query = new StringBuffer(); query.append("DELETE FROM ").append(getFromClause(schemaName, tableName)).append(" WHERE ").append(columnName) .append("=").append("'").append(columnValue).append("'"); s = getStatelessSession(); Transaction tx = s.beginTransaction(); s.createSQLQuery(query.toString()).executeUpdate(); tx.commit(); }
.append(" VALUES('").append(parentId).append("','").append(childId).append("')"); s.createSQLQuery(query.toString()).executeUpdate();
.append(" VALUES('").append(parentId).append("','").append(childId).append("')"); s.createSQLQuery(query.toString()).executeUpdate();
/** * On native update. * * @param query * the query * @param parameterMap * the parameter map * @return the int */ public int onNativeUpdate(String query, Map<Parameter, Object> parameterMap) { s = getStatelessSession(); Query q = s.createSQLQuery(query); setParameters(parameterMap, q); // Transaction tx = s.getTransaction() == null ? s.beginTransaction(): // s.getTransaction(); // tx.begin(); int i = q.executeUpdate(); // tx.commit(); return i; }
try session.createSQLQuery("Drop table " + metadata.getTableName()).executeUpdate();
SQLQuery q = s.createSQLQuery(nativeQuery).addEntity(m.getEntityClazz()); if (relations != null)
SQLQuery q = s.createSQLQuery(nativeQuery).addEntity(m.getEntityClazz());
/** * Updates foreign keys into master table * * @param metadata * @param id * @param relationHolders */ private void updateForeignKeys(EntityMetadata metadata, Object id, List<RelationHolder> relationHolders) { for (RelationHolder rh : relationHolders) { String linkName = rh.getRelationName(); Object linkValue = rh.getRelationValue(); if (linkName != null && linkValue != null) { String clause = getFromClause(metadata.getSchema(), metadata.getTableName()); String updateSql = "Update " + clause + " SET " + linkName + "= '" + linkValue + "' WHERE " + ((AbstractAttribute) metadata.getIdAttribute()).getJPAColumnName() + " = '" + id + "'"; log.warn("Executing query {}", updateSql); s.createSQLQuery(updateSql).executeUpdate(); } } }
SQLQuery q = s.createSQLQuery(nativeQuery); q.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);