Is possible map a single entity with multiple tables using JPA?

jpa, mapping

Solution

Use `@SecondaryTable` (http://en.wikibooks.org/wiki/Java_Persistence/Tables#Multiple_tables)

@Entity
@Table(name="TABLE1")
@SecondaryTables({
  @SecondaryTable(name="TABLE2",
    pkJoinColumns = @PrimaryKeyJoinColumn(name="ID", referencedColumnName="ID")
  ),
  @SecondaryTable(name="TABLE3",
    pkJoinColumns = @PrimaryKeyJoinColumn(name="ID", referencedColumnName="ID")
  )}
)

Problem

I got a legacy database domain I can't change but it was possible conceive a domain entity to address my problema. Legacy Tables: TABLE1(ID,VALUE) TABLE2(ID,DATE) TABLE3(ID,DESCRIPTION) Domain: NewConceptDomain { int value; Date date; String description; } How can I map new NewConceptDomain using JPA?

Original source