如何使用JPA / Hibernate注释将MySQL char（n）列映射到实例变量？ [英] How to map a MySQL char(n) column to an instance variable using a JPA/Hibernate annotation?

问题描述

我在类型为char（7）的MySQL表中的列语言上遇到JPA / Hibernate映射问题。在我的实体中，为该字段生成的代码是：

  private String language; 
  

这会在运行时导致以下异常：

  ... 43 more 
导致：javax.persistence.PersistenceException：[PersistenceUnit：prosvetaPersistenceUnit]无法在org.hibernate.ejb.Ejb3Configuration上构建EntityManagerFactory 
 .buildEntityManagerFactory（Ejb3Configuration.java:911）
 at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory（HibernatePersistence.java:74）
 at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java ：225）
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:308）
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory.java:1477 ）$ or 
 at org.springframework.beans.factory.support.AbstractAutow ireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1417）
 ... 58 more 
导致：org.hibernate.HibernateException：列语言的joo16_dev.jos_categories中的列类型错误。在org.hibernate.cfg.Configuration.validateSchema（Configuration.java： 1313）
 at org.hibernate.tool.hbm2ddl.SchemaValidator.validate（SchemaValidator.java:139）
 at org.hibernate.impl.SessionFactoryImpl。< init>（SessionFactoryImpl.java:378）
 at org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:1842）
 at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory（Ejb3Configuration.java:902）
 ... 63 more 
  

提前致谢！

JP

解决方案

试试这个：

  @Column（name =language，columnDefinition =char（7））
  

这是有效的。

I encounter a JPA/Hibernate mapping problem on a column "language" in a MySQL table whose type is char(7). In my entity, the code generated for the field is:

    private String language;

this causes the following exception at runtime:

        ... 43 more
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: prosvetaPersistenceUnit] Unable to build EntityManagerFactory
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:911)
    at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:225)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:308)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
    ... 58 more
Caused by: org.hibernate.HibernateException: Wrong column type in joo16_dev.jos_categories for column language. Found: char, expected: varchar(255)
    at org.hibernate.mapping.Table.validateColumns(Table.java:283)
    at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1313)
    at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:378)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842)
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:902)
    ... 63 more

Thanks in advance !

JP

解决方案

Try this:

@Column(name="language",columnDefinition="char(7)")

see if that works.

这篇关于如何使用JPA / Hibernate注释将MySQL char（n）列映射到实例变量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！