Change Table Name of an Entity on runtime? [duplicate]

by

Is it possible to change the table name of an entity as follows on runtime since they have the same table structure after all?

This is not really possible, at least not with standard JPA (which doesn’t mean I did it with non standard JPA) as mentioned in questions such as:

To summarize, JPA doesn’t offer a way to “alter” a given entity of an already initialized persistence unit (and the related pre-compiled CRUD queries, the pre-compiled named queries, etc).

Still, since you’re using Hibernate, maybe have a look at http://www.hibernate.org/171.html to get an idea of what would be possible using Hibernate Core API.

Another option I can think of would be to use a database synonym / alias: FOO would be an alias for FOO_JAN2010 until… you change the alias to point on FOO_FEB2010. I’ve never tested this, I don’t know if it will suit your needs. But it’s another idea.

More Related Contents:

  1. JPA CascadeType.ALL does not delete orphans
  2. Hibernate – @ElementCollection – Strange delete/insert behavior
  3. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  4. Hibernate triggering constraint violations using orphanRemoval
  5. JPA JoinColumn vs mappedBy
  6. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  7. Difference between FetchType LAZY and EAGER in Java Persistence API?
  8. How to map a composite key with JPA and Hibernate?
  9. Hibernate Annotations – Which is better, field or property access?
  10. How to map an entity field whose name is a reserved word in JPA
  11. Do I need elements in persistence.xml?
  12. What’s the difference between JPA and Hibernate? [closed]
  13. How to map calculated properties with JPA and Hibernate
  14. What is the “owning side” in an ORM mapping?
  15. What is the solution for the N+1 issue in JPA and Hibernate?
  16. What is the difference between persist() and merge() in JPA and Hibernate?
  17. Bypass GeneratedValue in Hibernate (merge data not in db?)
  18. Storing a Map using JPA
  19. How to solve the LazyInitializationException when using JPA and Hibernate
  20. I found JPA, or alike, don’t encourage DAO pattern
  21. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  22. Hibernate generates negative id values when using a sequence
  23. Doing an “IN” query with Hibernate
  24. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  25. Specifying an Index (Non-Unique Key) Using JPA
  26. The onFlushDirty Hibernate Interceptor method is never called
  27. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  28. Hibernate throws strange error: Class is not mapped
  29. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  30. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB

Leave a Comment