Is it possible to dynamically define column names in Hibernate / JPA?

by

You need to create a custom NamingStrategy.

Assuming you use spring and hibernate with JPA, here is a configuration snippet with a custom NamingStrategy:

<bean id="entityManagerFactory"
    class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="persistenceUnitName" value="myunit" />
    <property name="dataSource" ref="dataSource" />
    <property name="persistenceXmlLocation"
              value="classpath:META-INF/persistence.xml" />
    <property name="jpaVendorAdapter">
        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
            <property name="showSql" value="false" />
            <property name="generateDdl" value="true" />
            <property name="database" value="MYSQL" />
        </bean>
    </property>
    <property name="jpaProperties">
        <props>
            <prop 
                key="hibernate.ejb.naming_strategy">
                com.yourcompany.CustomNamingStrategy
            </prop>
        </props>
    </property>
</bean>

If you don’t use spring, configuration will be different, but you can still use a custom NamingStrategy (see Implementing a NamingStrategy from the Hibernate Documentation).

Anyway, here is a sample NamingStrategy that builds table names of the form TYPE1_TYPE2 for join tables and adds a common prefix to all tables:

public class CustomNamingStrategy extends ImprovedNamingStrategy {

    private static final long serialVersionUID = 1L;
    private static final String PREFIX = "PFX_";

    @Override
    public String classToTableName(final String className) {
        return this.addPrefix(super.classToTableName(className));
    }

    @Override
    public String collectionTableName(final String ownerEntity,
            final String ownerEntityTable, final String associatedEntity,
            final String associatedEntityTable, final String propertyName) {
        return this.addPrefix(super.collectionTableName(ownerEntity,
                ownerEntityTable, associatedEntity, associatedEntityTable,
                propertyName));
    }

    @Override
    public String logicalCollectionTableName(final String tableName,
            final String ownerEntityTable, final String associatedEntityTable,
            final String propertyName) {
        return this.addPrefix(super.logicalCollectionTableName(tableName,
                ownerEntityTable, associatedEntityTable, propertyName));
    }

    private String addPrefix(final String composedTableName) {

        return PREFIX
                + composedTableName.toUpperCase().replace("_", "");

    }

}

More Related Contents:

  1. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  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. How to map calculated properties with JPA and Hibernate
  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. When and why JPA entities should implement the Serializable interface?
  13. JPQL Create new Object In Select Statement – avoid or embrace?
  14. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  15. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  16. JPA/Hibernate Native Queries do not recognize Parameters
  17. How to solve the LazyInitializationException when using JPA and Hibernate
  18. I found JPA, or alike, don’t encourage DAO pattern
  19. Getting Database connection in pure JPA setup
  20. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  21. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  22. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  23. Doing an “IN” query with Hibernate
  24. The onFlushDirty Hibernate Interceptor method is never called
  25. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  26. Batch inserts with JPA/EJB3
  27. Hibernate triggering constraint violations using orphanRemoval
  28. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  29. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment