首页 文章

使用JPA映射复合主键和外键

提问于
浏览
1

我有两个表:A和B.两个都有一个复合主键 . 表B的PK也是表A的主键的外键 .

当我尝试获取映射表B的类的实例时,我得到以下异常:

org.hibernate.TypeMismatchException

该应用程序是一个Spring Boot应用程序 . 源代码可在Github获取

表B的代码来源是:

@Entity @Table(name="usuarios")
public class UsuarioEntity implements Serializable {

    private static final long serialVersionUID = 1L;

    @EmbeddedId @AttributeOverrides( {
        @AttributeOverride(name="perTipoUsu", column=@Column(name="per_tipo_usu", nullable=false) ), 
        @AttributeOverride(name="perCodUsu", column=@Column(name="per_cod_usu", nullable=false) ) } )
    private UsuarioPKEntity pk = null;

   @OneToOne @PrimaryKeyJoinColumn
   private PersonaRelEnity personaRel = null;

   private String nombre;

   ....
}

表A的代码来源是:

@Entity @Table(name="persona_rel")
public class PersonaRelEnity implements Serializable {

    private static final long serialVersionUID = 1L;

    @EmbeddedId
    private PersonaRelPKEntity id;

    private String persona;

   ....
}

这两个类都包含在:com.cairone.ejemplo01.entities中

完整的日志输出是:

2016-09-21 12:28:24.505 ERROR 8568 --- [main] o.s.boot.SpringApplication:应用程序启动失败java.lang.IllegalStateException:无法执行CommandLineRunner
在org.springframework.boot.SpringApplication.callRunner(SpringApplication.ja
va:809)[org.springframework.boot.SpringApplication.callRunners [Spring-boot-1.350 . 在org.springframework的org.springframework.boot.SpringApplication.afterRefresh(SpringApplication . java:777)[spring-boot-1.3.5.RELEASE.jar:1.3.5.RELEASE]上的RELEASE.jar:1.3.5.RELEASE] .boot.SpringApplication.run(SpringApplication.java:308)[spring-boot-1.3.5.RELEASE.jar:1.3.5.RELEASE]在org.springframework.boot.SpringApplication.run(SpringApplication.java:1191)[ spring-boot-1.3.5.RELEASE.jar:1.3.5.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1180)[spring-boot-1.3.5.RELEASE.jar:1.3 . 5.RELEASE] at com.cairone.ejemplo01.App.main(App.java:74)[classes /:na]引起:org.springframework.dao.InvalidDataAccessApiUsageException:org.hibernate.TypeMismatchException:提供错误类型的id com.cairone.ejemplo01.entities.PersonaRelEnity上课 . 预期:上课com.cairone.ejemplo01.entities.PersonaRelPKEntity,上课com.cairone.ejemplo01.entities.UsuarioPKEntity;嵌套异常是java.lang.IllegalArgumentException:org.hibernate.TypeMismatchException:为类com.cairone.ejemplo01.entities.PersonaRelEnity提供了错误类型的id . 预期:上课com.cairone.ejemplo01.entities.PersonaRelPKEntity,在org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExce ptionIfPossible(EntityManagerFactoryUtils.java:384)〜[spring-orm-]获得com.cairone.ejemplo01.entities.UsuarioPKEntity课程4.2.6.RELEASE.jar:4.2.6.RELEASE]在org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionI fPossible(HibernateJpaDialect.java:227)〜[spring-orm- 4.2.6.RELEASE.jar: 4.2.6.RELEASE] org.springframework上的org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExce ptionIfPossible(AbstractEntityManagerFactoryBean.java:436)〜[spring- orm-4.2.6.RELEASE.jar:4.2.6.RELEASE] .ao.support.ChainedPersistenceExceptionTranslator.tran slateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)〜[spring-tx-4.2.6.RELEASE.jar:4.2.6.RELEASE] org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataA org.spr中的ccessUtils.java:213)~ [spring-tx-4.2.6.RELEASE.jar:4.2.6.RELEASE] orframe.springframework.aop.framework.ReflectiveMethodInvocation.proceed(refle)中的ingframework.dao.support.PersistenceExceptionTranslationInterceptor .invoke(PersistenceExceptionTranslationInterceptor.java:147)〜[spring-tx-4.2.6.RELEASE.jar:4.2.6.RELEASE] citMethodInvocation.java:179)〜[spring-aop- 4.2.6.RELEASE.jar:4.2.6.RELEASE] at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProc essor $ CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetad ataPostProcessor.java :131)〜[spring-data-jpa-1.9.4.RELEASE.jar:na] org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refle ctiveMethodInvocation.java:179)〜[spring-aop- 4.2.6 .RELEASE.jar:4.2.6.RELEASE]在org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(Exp oseInvocationInterceptor.java:92)〜[spring-aop- 4.2.6.RELEASE.jar:4.2.6.RELEASE在org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refle ctiveMethodInvocation.java:179)〜[spring-aop- 4.2.6.REL EASE.jar:4.2.6.RELEASE]在org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopP roxy.java:208)〜[spring-aop-4.2.6.RELEASE.jar:4.2.6.RELEASE] at com.sun.proxy . $ Proxy69.findAll(Unknown Source)〜[na:na] at com.cairone.ejemplo01.datasources.UsuarioDataSource.buscar(UsuarioDataSour ce.java:15)〜[classes /:na] at com .cairone.ejemplo01.App.run(App.java:33)[classes /:na] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.ja va:806)[spring-boot-1.3.5.RELEASE . jar:1.3.5.RELEASE] ...省略了6个常见帧引起:java.lang.IllegalArgumentException:org.hibernate.TypeMismatchException:为类com.cairone.ejemplo01.entities.PersonaRelEnity提供了错误类型的id . 预期:上课com.cairone.ejemplo01.entities.PersonaRelPKEntity,上课com.cairone.ejemplo01.entities.UsuarioPKEntity at在org.hibernate.jpa.criteria.compile.CriteriaQueryTypeQueryAdapter上的org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:455)〜[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] .getResultList(CriteriaQueryTypeQueryAdapter.java:67)〜[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]在org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java: 323)〜[spring-data-jpa-1.9.4.RELEASE.jar:na] org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:68)〜[spring-data-jpa -1.9.4.RELEASE.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)〜[na:1.8.0_74] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)〜[na: 1.8.0_74]在sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)〜[na:1.8.0_74] java.lang.reflect.Method.invoke(Method.java:498)〜[na:1.8 . 0_74]在org.springframework.data.repository.core.support . RepositoryFactorySupport $ QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:483)〜[spring-data-commons-1.11.4.RELEASE.jar:na] at org.springframework.data.repository.core.support.RepositoryFactorySupport $ QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport) .java:468)〜[spring-data-commons-1.11.4.RELEASE.jar:na] org.springframework.data.repository.core.support.RepositoryFactorySupport $ QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:440)〜[ spring-data-commons-1.11.4.RELEASE.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)〜[spring-aop-4.2.6.RELEASE.jar:4.2 .6.RELEASE] org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)〜[spring-data-commons-1.11.4.RELEASE.jar:na] org.springframework.aop.framework .ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)〜[spring-aop-4 or.2.springframework.transaction.interceptor.TransactionInterceptor $ .proceedWithInvocation(TransactionInterceptor.java:99)〜[spring-tx-4.2.6.RELEASE.jar: .RELEASE] org.springframework.transaction.interceptor.TraringactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)〜[spring-tx-4.2.6.RELEASE.jar:4.2.6.RELEASE] org.springframework.transaction.interceptor org.springframework.aop.framework.ReflectiveMethodInvocation.proceed中的.TransactionInterceptor.invoke(TransactionInterceptor.java:96)〜[spring-tx-4.2.6.RELEASE.jar:4.2.6.RELEASE](ReflectiveMethodInvocation.java:179) 〜[spring-aop-4.2.6.RELEASE.jar:4.2.6.RELEASE] org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)〜[spring-tx-4.2.6.RELEASE .jar:4.2.6.RELEASE] ...省略了16个常见帧引起:org.hibernate.TypeMismatchException:为类com.cairone提供了错误类型的id . ejemplo01.entities.PersonaRelEnity . 预期:类com.cairone.ejemplo01.entities.PersonaRelPKEntity,在org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:134)得到了com.cairone.ejemplo01.entities.UsuarioPKEntity类〜[hibernate-core-4.3 .11.Final.jar:4.3.11.Final] at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106)~ [hibernate-core-4.3.11.Final.jar:4.3.11.Final]在org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final] org.hibernate.type.EntityType.resolveIdentifier(EntityType . java:716)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final] org.hibernate.type.EntityType.resolve(EntityType.java:502)~ [hibernate-core-4.3.11 .Final.jar:4.3.11.Final] at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:170)~ [hibernate-core-4.3.11.Final.jar:4.3.11.Final]在org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:144)〜[hibernate-core-4.3.11.Final.jar:4.3 org.hibernate.loader.Loader上org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1115)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final]的.11.Final] orprocess.hibernate.loader.Loader.doQuery(Loader.java:921)〜[hibernate- core-4.3.11.Final.jar:4.3.11.Final]在org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)〜[hibernate-core-4.3.11.Final.jar:4.3.11在org.hibernate.loader.Loader.doList的org.hibernate.loader.Loader.doList(Loader.java:2554)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final] (Loader.java:2540)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final] org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)~ [hibernate-core- 4.3.11.Final.jar:4.3.11.Final]在org.hibernate.loader.Loader.list(Loader.java:2365)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final ] 在org.hibernate.lader.Query.Query.jin上的[org.hibernate.list.Query.Java: . .list(QueryTranslatorImpl.java:387)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final] org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) 〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final]在org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)〜[hibernate-core-4.3.11.Final.jar :4.3.11.Final]在org.hibernate.jpa的org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)〜[hibernate-core-4.3.11.Final.jar:4.3.11.Final] .internal.QueryImpl.list(QueryImpl.java:573)〜[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]在org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java: 449)〜[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final] ...省略了34个常见帧2016-09-21 12:28:24.508 INFO 8568 --- [main] utoConfigurationReportLoggingInitializer:Error启动ApplicationC ontext . 显示自动配置报告启用调试日志记录(以--debug开头)2016-09-21 12:28:24.509 INFO 8568 --- [main] s.c.a.AnnotationConfigApplicationContext:关闭
org.springframework.context.annotation.AnnotationConfigApplicationContext @ 24b1d79b:启动日期[Wed Sep 21 12:28:21 ART 2016];上下文层次结构的根源2016-09-21 12:28:24.511 INFO 8568 --- [main] osjeaAnnotationMBeanExporter:在关闭时取消注册JMX暴露的bean 2016-09-21 12:28:24.513 INFO 8568 --- [main] j.LocalContainerEntityManagerFactoryBean:关闭持久性单元'default'的JPA EntityManagerFactory

这是相关部分:

org.hibernate.TypeMismatchException: Provided id of the wrong type for class com.cairone.ejemplo01.entities.PersonaRelEnity. Expected: class com.cairone.ejemplo01.entities.PersonaRelPKEntity, got class com.cairone.ejemplo01.entities.UsuarioPKEntity

1 回答

  • 1

    这是“派生身份”,其中一个实体的主键是从另一个相关实体的主键派生的 .

    我没有遇到任何与这种关系完全相同的东西,但试试这个:

    @Entity
    @Table(name="persona_rel")
    public class PersonaRelEnity implements Serializable {
    
        @EmbeddedId
        private PersonaRelPKEntity pk;
    
        ...
    }
    
    @Embeddable
    public class PersonaRelPKEntity implements Serializable {
    
        private static final long serialVersionUID = 1L;
    
        @Column(name="per_tipo")
        private Integer perTipo;
    
        @Column(name="per_cod")
        private Integer perCod;
    
        ...
    }
    
    @Entity
    @Table(name="usuarios")
    public class UsuarioEntity implements Serializable {
    
        @EmbeddedId
        private UsuarioEntityPK id;
    
        @OneToOne
        @MapsId("personaRelPKEntity")
        @JoinColumns({
            @JoinColumn(name="per_tipo_usu", referencedColumnName="per_tipo"),
            @JoinColumn(name="per_cod_usu", referencedColumnName="per_cod")
        })
        private PersonaRelEnity personaRelEntity = null;
    
        ...
    }
    
    @Embeddable
    public class UsuarioEntityPK implements Serializable {
    
        // matches the PK type of PersonaRelEnity
        private PersonaRelPKEntity personaRelPKEntity;
    
        ...
    }
    

    衍生身份在JPA 2.1规范2.4.1节中讨论 .

    旁注:类名 PersonaRelEnity 中有一个拼写错误(即 Entity 缺少第一个 t ) . :-)

相关问题