Problem using @SecondaryTable in Hibernate

Question

Abridged version of my schema:

utility_company
id int not null -- PK
name varchar(255) not null

utility_settings
utility_id -- FK to utility
use_magic tinyint(1) not null default 0

There is a one-to-one mapping between these two tables. Setting aside the fitness of this design, I want to Map the data in both of these tables to one object. In Hibernate/JPA, this is allegedly done as follows:

@Entity
@Table(name = "utility_company")
@SecondaryTables({
    @SecondaryTable(
        name = "utility_settings", 
        pkJoinColumns = {
            @PrimaryKeyJoinColumn(
                name="utility_id", referencedColumnName="id")
        })
})
public class UtilityCompany extends AbstractEntity {

And so forth.

Every @Column includes the appropriate table name.

When I deploy, I get this error:

Cannot find the expected secondary table: 
no utility_company available for poscore.model.UtilityCompany

The utility_company table is definitely there (a previous version only maps UtilityCompany to the utility_company table; I'm adding the utility_settings).

Found numerous forum posts with this exact problems and no answers. I've also tried various allegedly legal forms of specifying the @SecondaryTable all of which have the same effect.

Anyone successfully use @SecondaryTable, and, if so, seen this?

I know this question is very old, but... I have the same problem. Have you solved it? — davioooh
– davioooh, Commented May 3, 2012 at 8:58

Nicolas Mommaerts · Accepted Answer · 2011-03-11 14:36:56Z

3

"Every @Column includes the appropriate table name."

Try removing the explicit table name for the first table name columns, only specifying it for the secondary table columns. Did the trick for me.

answered Mar 11, 2011 at 14:36

Nicolas Mommaerts

3,3035 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DataNucleus · Accepted Answer · 2009-04-04 13:45:12Z

1

Your mappings are correct IMHO, and runs fine with DataNucleus AccessPlatform as the JPA implementation. Maybe Hibernates log tells you more ?

--Andy DataNucleus

answered Apr 4, 2009 at 13:45

DataNucleus

15.6k3 gold badges34 silver badges37 bronze badges

Collectives™ on Stack Overflow

Problem using @SecondaryTable in Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related