在JPA / hibernate中映射UUID的问题 [英] Problems mapping UUID in JPA/hibernate

问题描述

根据文档，hibernate 3.6应该支持java.util.UUID类型。但是，当我将它映射为：

  @Id受保护的UUID uuid; 
  

我收到以下异常：

 原因：org.springframework.beans.factory.BeanCreationException：在类路径资源[test-applicationContext.xml]中定义的名为'entityManagerFactory'的bean创建时出错：init方法的调用失败;嵌套异常是javax.persistence.PersistenceException：[PersistenceUnit：persistenceUnit]无法在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean上创建EntityManagerFactory 
（AbstractAutowireCapableBeanFactory.java:1420）〜[spring-beans-3.0 .5.RELEASE.jar：3.0.5.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:519）〜[spring-beans-3.0.5.RELEASE。 jar：3.0.5.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:456）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5 .RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:291）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5.RELEASE] 
在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRe gistry.java:222）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:288 ）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:190）〜[spring- beans-3.0.5.RELEASE.jar：3.0.5.RELEASE] 
 at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory（PersistenceAnnotationBeanPostProcessor.java:529）〜[spring-orm-3.0.5 .RELEASE.jar：3.0.5.RELEASE] 
 at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory（PersistenceAnnotationBeanPostProcessor.java:495）〜[spring-orm-3.0.5.RELEASE.jar： 3.0.5.RELEASE] 
 at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor $ PersistenceElement.resolveEntityManager（PersistenceAnnotationBeanPostProcessor.java:656）〜[spring-orm-3.0 .5.RELEASE.jar：3.0.5.RELEASE] 
在org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor $ PersistenceElement.getResourceToInject（PersistenceAnnotationBeanPostProcessor.java:629）〜[spring-orm-3.0.5。 RELEASE.jar：3.0.5.RELEASE] 
 at org.springframework.beans.factory.annotation.InjectionMetadata $ InjectedElement.inject（InjectionMetadata.java:147）〜[spring-beans-3.0.5.RELEASE.jar ：3.0.5.RELEASE] 
 at org.springframework.beans.factory.annotation.InjectionMetadata.inject（InjectionMetadata.java:84）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5。 RELEASE] 
在org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues（PersistenceAnnotationBeanPostProcessor.java:338）〜[spring-orm-3.0.5.RELEASE.jar：3.0.5.RELEASE] 
 ...省略了51个常见框架
引起：javax.persistence.PersistenceException：[PersistenceUnit：persistenceUnit]无法在org.hibernate.ejb.Ejb3Configurat中构建EntityManagerFactory 
 ion.buildEntityManagerFactory（Ejb3Configuration.java:911）〜[hibernate-entitymanager-3.6.0.Final.jar：3.6.0.Final] 
 at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory（HibernatePersistence.java:74 ）〜[hibernate-entitymanager-3.6.0.Final.jar：3.6.0.Final] 
 at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java:225）〜[spring-orm- 3.0.5.RELEASE.jar：3.0.5.RELEASE] 
在org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:308）〜[spring-orm-3.0.5.RELEASE.jar ：3.0.5.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory.java:1477）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5。 RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapabl eBeanFactory.java:1417）〜[spring-beans-3.0.5.RELEASE.jar：3.0.5.RELEASE] 
 ...省略64个常用框架
引起：org.hibernate.MappingException：无JDBC类型的Dialect映射：-2 
位于org.hibernate.dialect.TypeNames.get（TypeNames.java:78）〜[hibernate-core-3.6.0.Final.jar：3.6.0.Final] 
在org.hibernate.dialect.TypeNames.get（TypeNames.java:103）〜[hibernate-core-3.6.0.Final.jar：3.6.0.Final] 
在org.hibernate。 dialect.Dialect.getTypeName（Dialect.java:249）〜[hibernate-core-3.6.0.Final.jar：3.6.0.Final] 
 at org.hibernate.mapping.Column.getSqlType（Column.java ：208）〜[hibernate-core-3.6.0.Final.jar：3.6.0.Final] 
 at org.hibernate.mapping.Table.sqlTemporaryTableCreateString（Table.java:371）〜[hibernate-core- 3.6.0.Final.jar：3.6.0.Final] 
在org.hibernate.mapping.PersistentClass.prepareTemporaryTables（PersistentClass.java:765）〜[hibernate-core-3.6.0.Final.jar：3.6 .0.Final] 
在org.hibernate.impl.SessionFactoryImpl。< init>（Sessi onFactoryImpl.java:270）〜[hibernate-core-3.6.0.Final.jar：3.6.0.Final] 
 at org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:1842）〜[hibernate -core-3.6.0.Final.jar：3.6.0.Final] 
在org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory（Ejb3Configuration.java:902）〜[hibernate-entitymanager-3.6.0.Final。 jar：3.6.0.Final] 
 ... 69个常见框架省略
  

我知道堆栈跟踪问题并不是很流行，但这是一个非常特定于hibernate的问题，我一直无法在google上找到任何东西：）

谢谢

解决方案

UUID是3.6中添加的基本类型。但是，默认情况下，它会转换为JDBC二进制类型，这似乎会导致mysql出现问题。您可以通过明确指定uuid-char作为类型来覆盖此行为。

According to the documentation, hibernate 3.6 should have support for the java.util.UUID type. But when I map it like:

@Id protected UUID uuid;

I get the following exception:

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [test-applicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: persistenceUnit] Unable to build EntityManagerFactory
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:529) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:495) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:656) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:629) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:147) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:84) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:338) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    ... 51 common frames omitted
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: persistenceUnit] Unable to build EntityManagerFactory
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:911) ~[hibernate-entitymanager-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74) ~[hibernate-entitymanager-3.6.0.Final.jar:3.6.0.Final]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:225) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:308) ~[spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) ~[spring-beans-3.0.5.RELEASE.jar:3.0.5.RELEASE]
    ... 64 common frames omitted
Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: -2
    at org.hibernate.dialect.TypeNames.get(TypeNames.java:78) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.dialect.TypeNames.get(TypeNames.java:103) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:249) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.mapping.Column.getSqlType(Column.java:208) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.mapping.Table.sqlTemporaryTableCreateString(Table.java:371) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.mapping.PersistentClass.prepareTemporaryTables(PersistentClass.java:765) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:270) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842) ~[hibernate-core-3.6.0.Final.jar:3.6.0.Final]
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:902) ~[hibernate-entitymanager-3.6.0.Final.jar:3.6.0.Final]
    ... 69 common frames omitted

I know questions with stack traces are not very popular but this is a very hibernate-specific problem and I have been unable to find anything on google :)

Thanks

解决方案

UUID was a basic type added in 3.6. However, by default it translates to a JDBC Binary type which appears to cause issues for mysql. You can override this behavior by explicitly specifying uuid-char as the type.

这篇关于在JPA / hibernate中映射UUID的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！