I'm getting the following exception from Hibernate:
net.sf.hibernate.MappingException: Foreign key (CANDIDATE [APPOINTEDROLE])) must have same number of columns as the referenced primary key (CMLOOKUPS [TABLENAME,LOOKUP])
And apparently this is due to us having an association where CANDIDATE.APPOINTEDROLE is a foreign key column to a table named CMLOOKUPS which has a two-column composite primary key, the other column (CMLOOKUPS.TABLENAME) acting also as a discriminator column (the CMLOOKUPS table hosts a class hierarchy).
--------------------------------------------------------------------------------
Hibernate version:
2.1.7c
Mapping documents:
Code:
<hibernate-mapping package="com.company.domain">
<class name="Lookup" table="CMLOOKUPS" schema="REQUIREMENTCT">
<composite-id name="lookupId" class="com.company.domain.id.LookupId">
<key-property name="type" column="TABLENAME" type="string"/>
<key-property name="id" column="LOOKUP" type="string"/>
</composite-id>
<discriminator column="TABLENAME" type="string" insert="false" />
<subclass name="AppointedRole" discriminator-value="AppointedRole" />
<subclass name="..." discriminator-value="..." />
<subclass name="..." discriminator-value="..." />
<subclass name="..." discriminator-value="..." />
</class>
<class name="Candidate" table="CANDIDATE" schema="REQUIREMENTCT">
<!-- omitted some properties -->
<component name="healthAndSafetyInfo" class="HealthAndSafetyInfo">
<parent name="candidate"/>
<!-- omitted some properties -->
<!-- adding this to the mapping file causes the exception be thrown -->
<many-to-one name="appointedRole" class="AppointedRole" column="APPOINTEDROLE"/>
</component>
</class>
</hibernate-mapping>
Code:
/**
* Here's the setup method from which the exception is propagated to screen...
*/
public abstract class HibernateTestCase extends junit.framework.TestCase {
protected Session session = null;
protected Transaction tx = null;
protected void setUp() throws Exception
{
SessionFactory sessionFactory = HibernateSessionFactory.getSessionFactory();
session = sessionFactory.getSession();
tx = session.beginTransaction();
}
}
/**
* And this is the class that creates and configures the SessionFactory.
*/
public class HibernateSessionFactory {
public static SessionFactory getSessionFactory() {
if (sessionFactory == null) {
try {
cfg.configure(CONFIG_FILE_LOCATION);
sessionFactory = cfg.buildSessionFactory();
} catch (Exception e) {
// THIS IS WHERE I GOT THE STACK TRACE FROM
e.printStackTrace();
}
}
return sessionFactory;
}
}
/**
* The super class for all objects persisted into the CMLOOKUPS table.
*/
public class Lookup {
public void setLookupId(LookupId id) { this.lookupId = id; }
public LookupId getLookupId() { return this.lookupId; }
// omitted other getters/setters
}
/**
* The primary key class for the CMLOOKUPS table, i.e. to all children of the Lookup class.
*/
public class LookupId {
public String getId() { return this.id; }
public void setId(String id) { this.id = id; }
public String getType() { return this.type; }
public void setType(String type) { this.type = type; }
}
/**
* The subclass of Lookup that causes problems.
*/
public class AppointedRole extends Lookup {
// empty
}
/**
* Another class that has an association to the AppointedRole class.
*/
public class Candidate {
public AppointedRole getAppointedRole() { return this.appointedRole; }
public void setAppointedRole(AppointedRole role) { this.appointedRole = role; }
// omitted other getters/setters
}
Full stack trace of any exception that occurs:Code:
net.sf.hibernate.MappingException: Foreign key (CANDIDATE [APPOINTEDROLE])) must have same number of columns
as the referenced primary key (CMLOOKUPS [TABLENAME,LOOKUP])
at net.sf.hibernate.mapping.ForeignKey.setReferencedTable(ForeignKey.java:67)
at net.sf.hibernate.cfg.Configuration.secondPassCompileForeignKeys(Configuration.java:696)
at net.sf.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:671)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789)
at com.company.storage.HibernateSessionFactory.getSessionFactory(HibernateSessionFactory.java:64)
at com.company.storage.HibernateTestCase.setUp(HibernateTestCase.java:36)
at com.company.storage.LookupMappingTest.setUp(LookupMappingTest.java:37)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
Name and version of the database you are using:
Oracle 9.0.2.x, although test code never reaches the database nor goes through a vendor-specific dialect class etc.
The generated SQL (show_sql=true):
None generated, exception thrown during configuration/creating the SessionFactory
Debug level Hibernate log excerpt:
Not available
Login
FAQ
Search
