How to escape reserved words in Hibernate’s HQL

by

You could achieve it by a workaround using your custom “alias to map” transformer, so your code would change to something like this

Query q = mySession.createQuery(
    "SELECT u.id AS id, u.name AS text, u AS obj FROM User u")
    .setResultTransformer(
        AliasToMapTransformer.renameAlias("obj", "object").build()
    );

And then using this class:

public class AliasToMapTransformer extends BasicTransformerAdapter {

    private Map<String, String> renameAliasMap;


    public AliasToMapTransformer(Map<String, String> renameAliasMap) {
        this.renameAliasMap = (renameAliasMap == null) ? Collections.<String, String>emptyMap() : renameAliasMap;
    }


    @Override
    public Object transformTuple(Object[] tuple, String[] aliases) {
        Map<String, Object> result = new HashMap<String, Object>(tuple.length);
        for (int i = 0; i < tuple.length; i++) {
            String alias = aliases[i];
            if (alias != null) {
                String newAlias = renameAliasMap.get(alias);

                result.put((newAlias != null) ? newAlias : alias, tuple[i]);
            }
        }
        return result;
    }


    public static Builder renameAlias(String alias, String newAlias) {
        return new Builder().renameAlias(alias, newAlias);
    }


    public static class Builder {

        private Map<String, String> aliasConversionMap = new HashMap<String, String>();


        public Builder renameAlias(String alias, String newAlias) {
            aliasConversionMap.put(alias, newAlias);
            return this;
        }


        public AliasToMapTransformer build() {
            return new AliasToMapTransformer(aliasConversionMap);
        }
    }
}

More Related Contents:

  1. How do you do a limit query in JPQL or HQL?
  2. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  3. JPA and Hibernate – Criteria vs. JPQL or HQL
  4. Hibernate criteria: Joining table without a mapped association
  5. How can you call custom database functions with Hibernate?
  6. Hibernate Named Query Order By parameter
  7. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  8. IN-clause in HQL or Java Persistence Query Language
  9. HQL Hibernate INNER JOIN
  10. HQL left join of un-related entities
  11. HQL – row identifier for pagination
  12. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  13. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  14. How to write a like query in HQL
  15. HQL recursion, how do I do this?
  16. Inserting data in one table using HQL in Hibernate
  17. What are the possible values of the Hibernate hbm2ddl.auto configuration and what do they do
  18. Is it possible to use raw SQL within a Spring Repository
  19. What is the proper way to re-attach detached objects in Hibernate?
  20. No Dialect mapping for JDBC type: 1111
  21. Hibernate one-to-one: getId() without fetching entire object
  22. Jackson/Hibernate, meta get methods and serialization
  23. Spring Data JPA: Batch insert for nested entities
  24. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  25. Adding jdbc driver to classpath
  26. The onFlushDirty Hibernate Interceptor method is never called
  27. HQL joined query to eager fetch a large number of relationships
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment