Automatic reserved word escaping for Hibernate tables and columns

by

AFAIK, Hibernate doesn’t maintain a list of reserved keyword (per database) so I think you should look at database identifier escaping.

If you are using Hibernate 3.5+, try hibernate.globally_quoted_identifiers=true to quote all database identifiers (this is something they added for JPA 2.0, see the secion 2.13 Naming of Database Objects of the spec for the JPA way to activate this if you are using JPA).

Prior to version 3.5, Hibernate doesn’t offer any configuration option for global escaping. Implementing a custom NamingStrategy to escape everything transparently would be the recommended way.

See also

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. Difference between FetchType LAZY and EAGER in Java Persistence API?
  3. How to map a composite key with JPA and Hibernate?
  4. How to map an entity field whose name is a reserved word in JPA
  5. Do I need elements in persistence.xml?
  6. What’s the difference between JPA and Hibernate? [closed]
  7. Hibernate Error: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session
  8. What is the “owning side” in an ORM mapping?
  9. What is the solution for the N+1 issue in JPA and Hibernate?
  10. JPA CascadeType.ALL does not delete orphans
  11. What is the difference between persist() and merge() in JPA and Hibernate?
  12. JPQL Create new Object In Select Statement – avoid or embrace?
  13. How to map a PostgreSQL array with Hibernate
  14. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  15. Do Hibernate table classes need to be Serializable?
  16. JPA/Hibernate Native Queries do not recognize Parameters
  17. How to solve the LazyInitializationException when using JPA and Hibernate
  18. Difference Between One-to-Many, Many-to-One and Many-to-Many?
  19. Hibernate: flush() and commit()
  20. Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.(I)V
  21. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  22. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  23. How to perform a non-polymorphic HQL query in Hibernate?
  24. Doing an “IN” query with Hibernate
  25. The onFlushDirty Hibernate Interceptor method is never called
  26. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  27. Batch inserts with JPA/EJB3
  28. Using hibernate criteria, is there a way to escape special characters?
  29. How to use JTA support in Tomcat 6 for Hibernate?
  30. Make hibernate backquote all table / column names

Leave a Comment