Is there any way to store one JPA/Hibernate entity into many database tables?
For example there is a way to store inherited entities (more than one type of entity) in a single database table, my question is just reverse of this.
2
-
You might be able to handle this at the database level by using triggers.Tim Biegeleisen– Tim Biegeleisen2016-04-10 03:05:11 +00:00Commented Apr 10, 2016 at 3:05
-
1perhaps look up JPA "Secondary Tables" ?Neil Stockton– Neil Stockton2016-04-10 05:29:24 +00:00Commented Apr 10, 2016 at 5:29
Add a comment
|
1 Answer
Yes, you can store one entity in multiple database tables. Just annotate your entity class with @SecondaryTable / @SecondaryTables and use the 'table' property of your field mapping annotation to map the field to a column from a specific table:
@Entity
@Table(name ="TABLE1")
@SecondaryTables({
@SecondaryTable(name = "TABLE2", pkJoinColumns = @PrimaryKeyJoinColumn(name = "ID")),
@SecondaryTable(name = "TABLE3", pkJoinColumns = @PrimaryKeyJoinColumn(name = "ID"))
})
public class MyEntity {
@Id
@Column(name = "ID") /* when no table property is given, the primary table is used which is TABLE1 */
private Long id;
@Column(name = "FIELD1", table = "TABLE2")
private String field1;
@Column(name = "FIELD2", table = "TABLE3")
private String field2
}
