JPA休眠驼峰式字段 [英] JPA Hibernate camelcase field

问题描述

我有spring 4+休眠4.3 + psql 9.5应用程序，并且在驼峰式字段转换方面遇到了一些问题.

I have spring 4+ hibernate 4.3 + psql 9.5 application and faced some problems with camelcase field transalations.

Hibernate: select trainservi0_.trainServiceId as trainSer1_16_, trainservi0_.category as category2_16_, trainservi0_.date as date3_16_, trainservi0_.description as descript4_16_, trainservi0_.name as name5_16_, trainservi0_.status as status6_16_, trainservi0_.trainNumber as trainNum7_16_, trainservi0_.version as version8_16_ from tms.public.train_service trainservi0_
2016-02-29 13:09:34 WARN  SqlExceptionHelper:144 - SQL Error: 0, SQLState: 42703
2016-02-29 13:09:34 ERROR SqlExceptionHelper:146 - ERROR: column trainservi0_.trainserviceid does not exist
 Perhaps you meant to reference the column "trainservi0_.trainServiceId".

这是我的配置:

public class DataBaseProdConfig {

    @Resource
    private Environment env;

    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
        LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
        em.setDataSource(dataSource());
        em.setPackagesToScan(env.getRequiredProperty("db.entity.package"));
        em.setJpaVendorAdapter(new HibernateJpaVendorAdapter());
        em.setJpaProperties(getHibernateProperties());

        return em;
    }

    @Bean
    public DataSource dataSource() {
        BasicDataSource ds = new BasicDataSource();
        ds.setUrl(env.getRequiredProperty("db.url"));
        ds.setDriverClassName(env.getRequiredProperty("db.driver"));
        ds.setUsername(env.getRequiredProperty("db.username"));
        ds.setPassword(env.getRequiredProperty("db.password"));

        ds.setInitialSize(Integer.valueOf(env.getRequiredProperty("db.initialSize")));
        ds.setMinIdle(Integer.valueOf(env.getRequiredProperty("db.minIdle")));
        ds.setMaxIdle(Integer.valueOf(env.getRequiredProperty("db.maxIdle")));
        ds.setTimeBetweenEvictionRunsMillis(Long.valueOf(env.getRequiredProperty("db.timeBetweenEvictionRunsMillis")));
        ds.setMinEvictableIdleTimeMillis(Long.valueOf(env.getRequiredProperty("db.minEvictableIdleTimeMillis")));
        ds.setTestOnBorrow(Boolean.valueOf(env.getRequiredProperty("db.testOnBorrow")));
        ds.setValidationQuery(env.getRequiredProperty("db.validationQuery"));
        return ds;
    }

    @Bean
    public PlatformTransactionManager transactionManager() {
        JpaTransactionManager manager = new JpaTransactionManager();
        manager.setEntityManagerFactory(entityManagerFactory().getObject());

        return manager;
    }

    public Properties getHibernateProperties() {
        try {
            Properties properties = new Properties();
            InputStream is = getClass().getClassLoader().getResourceAsStream("hibernate.properties");
            properties.load(is);

            return properties;
        } catch (IOException e) {
            throw new IllegalArgumentException("Can't find 'hibernate.properties' in classpath!", e);
        }
    }

这是我的实体:

@Entity
@Table(name = "train_service", schema = "public", catalog = "tms")
public class TrainServiceEntity {
    private Long trainServiceId;
    @Id
    @SequenceGenerator(name="train_service_trainServiceId_seq",
            sequenceName="train_service_trainServiceId_seq",
            allocationSize=1)
    @GeneratedValue(strategy = GenerationType.SEQUENCE,
            generator="train_service_trainServiceId_seq")
    @Column(name = "trainServiceId")
    public Long getTrainServiceId() {
        return trainServiceId;
    }

    public void setTrainServiceId(Long trainServiceId) {
        this.trainServiceId = trainServiceId;
    }
....
}

所以Hibernate将' trainServiceId '转换为' trainserviceid '，但是在日志中，我看到了正确的字段名称:

So Hibernate translates 'trainServiceId' to 'trainserviceid' , but in logs I see the right field name:

Hibernate: select trainservi0_.trainServiceId as trainSer1_16_, ...

我该怎么做，迫使Hibernate不要将字段名称转换为小写字母?

What I need to do , that force Hibernate dont translate field names to lowecase?

推荐答案

您可以尝试将混合大小写的列名称放在连字符中.

You can try to put the mixedcase columne names in hyphens.

@Column("\"trainServiceId\"")

请参见持久性表，搜索带有特殊字符和大小写混合的表"

see persistence tables ,search for 'Tables with special characters and mixed case'

这篇关于JPA休眠驼峰式字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！