Examples with QueryException org.hibernate.QueryException used on opensource projects

Example 16 with QueryException

use of org.hibernate.QueryException in project hibernate-orm by hibernate.

the class SessionImpl method getFilterQueryPlan.

private FilterQueryPlan getFilterQueryPlan(Object collection, String filter, QueryParameters parameters, boolean shallow) throws HibernateException {
    if (collection == null) {
        throw new NullPointerException("null collection passed to filter");
    }
    CollectionEntry entry = persistenceContext.getCollectionEntryOrNull(collection);
    final CollectionPersister roleBeforeFlush = (entry == null) ? null : entry.getLoadedPersister();
    FilterQueryPlan plan = null;
    if (roleBeforeFlush == null) {
        // if it was previously unreferenced, we need to flush in order to
        // get its state into the database in order to execute query
        flush();
        entry = persistenceContext.getCollectionEntryOrNull(collection);
        CollectionPersister roleAfterFlush = (entry == null) ? null : entry.getLoadedPersister();
        if (roleAfterFlush == null) {
            throw new QueryException("The collection was unreferenced");
        }
        plan = getFactory().getQueryPlanCache().getFilterQueryPlan(filter, roleAfterFlush.getRole(), shallow, getLoadQueryInfluencers().getEnabledFilters());
    } else {
        // otherwise, we only need to flush if there are in-memory changes
        // to the queried tables
        plan = getFactory().getQueryPlanCache().getFilterQueryPlan(filter, roleBeforeFlush.getRole(), shallow, getLoadQueryInfluencers().getEnabledFilters());
        if (autoFlushIfRequired(plan.getQuerySpaces())) {
            // might need to run a different filter entirely afterQuery the flush
            // because the collection role may have changed
            entry = persistenceContext.getCollectionEntryOrNull(collection);
            CollectionPersister roleAfterFlush = (entry == null) ? null : entry.getLoadedPersister();
            if (roleBeforeFlush != roleAfterFlush) {
                if (roleAfterFlush == null) {
                    throw new QueryException("The collection was dereferenced");
                }
                plan = getFactory().getQueryPlanCache().getFilterQueryPlan(filter, roleAfterFlush.getRole(), shallow, getLoadQueryInfluencers().getEnabledFilters());
            }
        }
    }
    if (parameters != null) {
        parameters.getPositionalParameterValues()[0] = entry.getLoadedKey();
        parameters.getPositionalParameterTypes()[0] = entry.getLoadedPersister().getKeyType();
    }
    return plan;
}

Example 17 with QueryException

use of org.hibernate.QueryException in project hibernate-orm by hibernate.

the class CriteriaQueryTranslator method getTypedValue.

/**
	 * Get the a typed value for the given property value.
	 */
@Override
public TypedValue getTypedValue(Criteria subcriteria, String propertyName, Object value) throws HibernateException {
    // Detect discriminator values...
    if (value instanceof Class) {
        final Class entityClass = (Class) value;
        final Queryable q = SessionFactoryHelper.findQueryableUsingImports(sessionFactory, entityClass.getName());
        if (q != null) {
            final Type type = q.getDiscriminatorType();
            String stringValue = q.getDiscriminatorSQLValue();
            if (stringValue != null && stringValue.length() > 2 && stringValue.startsWith("'") && stringValue.endsWith("'")) {
                // remove the single quotes
                stringValue = stringValue.substring(1, stringValue.length() - 1);
            }
            // Convert the string value into the proper type.
            if (type instanceof StringRepresentableType) {
                final StringRepresentableType nullableType = (StringRepresentableType) type;
                value = nullableType.fromStringValue(stringValue);
            } else {
                throw new QueryException("Unsupported discriminator type " + type);
            }
            return new TypedValue(type, value);
        }
    }
    // Otherwise, this is an ordinary value.
    return new TypedValue(getTypeUsingProjection(subcriteria, propertyName), value);
}

Example 18 with QueryException

use of org.hibernate.QueryException in project hibernate-orm by hibernate.

the class SQLQueryParser method resolveCollectionProperties.

private String resolveCollectionProperties(String aliasName, String propertyName) {
    Map fieldResults = context.getPropertyResultsMapByAlias(aliasName);
    SQLLoadableCollection collectionPersister = context.getCollectionPersisterByAlias(aliasName);
    String collectionSuffix = context.getCollectionSuffixByAlias(aliasName);
    if ("*".equals(propertyName)) {
        if (!fieldResults.isEmpty()) {
            throw new QueryException("Using return-propertys together with * syntax is not supported.");
        }
        String selectFragment = collectionPersister.selectFragment(aliasName, collectionSuffix);
        aliasesFound++;
        return selectFragment + ", " + resolveProperties(aliasName, propertyName);
    } else if ("element.*".equals(propertyName)) {
        return resolveProperties(aliasName, "*");
    } else {
        String[] columnAliases;
        // Let return-propertys override whatever the persister has for aliases.
        columnAliases = (String[]) fieldResults.get(propertyName);
        if (columnAliases == null) {
            columnAliases = collectionPersister.getCollectionPropertyColumnAliases(propertyName, collectionSuffix);
        }
        if (columnAliases == null || columnAliases.length == 0) {
            throw new QueryException("No column name found for property [" + propertyName + "] for alias [" + aliasName + "]", originalQueryString);
        }
        if (columnAliases.length != 1) {
            // TODO: better error message since we actually support composites if names are explicitly listed.
            throw new QueryException("SQL queries only support properties mapped to a single column - property [" + propertyName + "] is mapped to " + columnAliases.length + " columns.", originalQueryString);
        }
        aliasesFound++;
        return columnAliases[0];
    }
}

Example 19 with QueryException

use of org.hibernate.QueryException in project hibernate-orm by hibernate.

the class QueryLoader method iterate.

public Iterator iterate(QueryParameters queryParameters, EventSource session) throws HibernateException {
    checkQuery(queryParameters);
    final boolean stats = session.getFactory().getStatistics().isStatisticsEnabled();
    long startTime = 0;
    if (stats) {
        startTime = System.nanoTime();
    }
    try {
        if (queryParameters.isCallable()) {
            throw new QueryException("iterate() not supported for callable statements");
        }
        final SqlStatementWrapper wrapper = executeQueryStatement(queryParameters, false, Collections.emptyList(), session);
        final ResultSet rs = wrapper.getResultSet();
        final PreparedStatement st = (PreparedStatement) wrapper.getStatement();
        final Iterator result = new IteratorImpl(rs, st, session, queryParameters.isReadOnly(session), queryReturnTypes, queryTranslator.getColumnNames(), buildHolderInstantiator(queryParameters.getResultTransformer()));
        if (stats) {
            final long endTime = System.nanoTime();
            final long milliseconds = TimeUnit.MILLISECONDS.convert(endTime - startTime, TimeUnit.NANOSECONDS);
            session.getFactory().getStatistics().queryExecuted(//						"HQL: " + queryTranslator.getQueryString(),
            getQueryIdentifier(), 0, milliseconds);
        }
        return result;
    } catch (SQLException sqle) {
        throw session.getJdbcServices().getSqlExceptionHelper().convert(sqle, "could not execute query using iterate", getSQLString());
    }
}

Example 20 with QueryException

use of org.hibernate.QueryException in project hibernate-orm by hibernate.

the class ProcedureCallImpl method prepareForNamedParameters.

private void prepareForNamedParameters() {
    if (parameterStrategy == ParameterStrategy.POSITIONAL) {
        throw new QueryException("Cannot mix named and positional parameters");
    }
    if (parameterStrategy == ParameterStrategy.UNKNOWN) {
        // protect to only do this check once
        final ExtractedDatabaseMetaData databaseMetaData = getSession().getJdbcCoordinator().getJdbcSessionOwner().getJdbcSessionContext().getServiceRegistry().getService(JdbcEnvironment.class).getExtractedDatabaseMetaData();
        if (!databaseMetaData.supportsNamedParameters()) {
            LOG.unsupportedNamedParameters();
        }
        parameterStrategy = ParameterStrategy.NAMED;
    }
}