Changing Table name dynamiclly in JPA/Hibernate

Question

I have seen some posts talking about NamingStrategy but it is not exacting what I am looking for (or I don't know to to approach it).

I need, depending on some conditions, to change the name of the @Table in the @Entity class passing an ID, something like this:

@Entity
@Table(name = "SA1{companyID}")
public class Cliente implements Serializable, Cloneable {

That "companyID" will something like: 010, 020, 030

Is there any whay to achieve that?

what do you mean "dynamically change" ? You want to change it somewhere and create a new EMF? — Neil Stockton, May 12 '16 at 14:53
I have these tables **SA1010, SA1030, SA1040** with same structure, depending on what company the user is the selects (this is read only db) are made on different tables, and I would like to use the same entity class. — Francisco Souza, May 12 '16 at 17:57
yes, and is that one EMF per company? or are you wanting to dynamically select the table mid-EMF ?! — Neil Stockton, May 12 '16 at 18:06

score 2 · Answer 1 · answered May 12 '16 at 20:45

2

It will be better, if you use @MappedSuperclass

@MappedSuperclass
class Cliente {

  @Column
  private String xxx;

}

@Entity
class SA1010 extends Cliente { 


}

answered May 12 '16 at 20:45

v.ladynev

Thanks, sounds interesting, I will try that – Francisco Souza May 13 '16 at 13:08
Yes, this answer solved perfectly my issue here. Thanks a lot my friend. – Francisco Souza May 16 '16 at 12:39

score 0 · Answer 2 · edited May 23 '17 at 12:16

0

You can do it by implementing NamingStrategy

Please see posts below which will help you:

edited May 23 '17 at 12:16

Community

answered May 12 '16 at 15:00

shankarsh15

2 Answers2