How to map an entity field whose name is a reserved word in JPA

by

With Hibernate as JPA 1.0 provider, you can escape a reserved keyword by enclosing it within backticks:

@Column(name="`open`")

This is the syntax inherited from Hiberate Core:

5.4. SQL quoted identifiers

You can force Hibernate to quote an
identifier in the generated SQL by
enclosing the table or column name in
backticks in the mapping document.
Hibernate will use the correct
quotation style for the SQL Dialect.
This is usually double quotes, but the
SQL Server uses brackets and MySQL
uses backticks.

<class name="LineItem" table="`Line Item`">
    <id name="id" column="`Item Id`"/><generator class="assigned"/></id>
    <property name="itemNumber" column="`Item #`"/>
    ...
</class>

In JPA 2.0, the syntax is standardized and becomes:

@Column(name="\"open\"")

References

Related questions

More Related Contents:

  1. JPA JoinColumn vs mappedBy
  2. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  3. Hibernate Annotations – Which is better, field or property access?
  4. Do I need elements in persistence.xml?
  5. What’s the difference between JPA and Hibernate? [closed]
  6. How to map calculated properties with JPA and Hibernate
  7. What is the “owning side” in an ORM mapping?
  8. What is the solution for the N+1 issue in JPA and Hibernate?
  9. JPA CascadeType.ALL does not delete orphans
  10. Bypass GeneratedValue in Hibernate (merge data not in db?)
  11. When and why JPA entities should implement the Serializable interface?
  12. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  13. How to solve the LazyInitializationException when using JPA and Hibernate
  14. I found JPA, or alike, don’t encourage DAO pattern
  15. Getting Database connection in pure JPA setup
  16. Hibernate – @ElementCollection – Strange delete/insert behavior
  17. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  18. JPA SQL Server No Dialect mapping for JDBC type: -9
  19. how to configure hibernate config file for sql server
  20. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  21. Is it possible to dynamically define column names in Hibernate / JPA?
  22. Specifying an Index (Non-Unique Key) Using JPA
  23. The onFlushDirty Hibernate Interceptor method is never called
  24. Hibernate throws strange error: Class is not mapped
  25. Batch inserts with JPA/EJB3
  26. Hibernate triggering constraint violations using orphanRemoval
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. Change Table Name of an Entity on runtime? [duplicate]
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment