在Hibernate中将列名称用双引号引起来 [英] Wrap column names in double quotes in Hibernate

问题描述

我正在将Spring JPA 2.0.9与Hibernate 5.3.5和此方言结合使用使用来自此分布.

I'm using Spring JPA 2.0.9 with Hibernate 5.3.5 and this dialect to access a FileMaker (v16) database via JDBC using the official JDBC driver taken from this distribution.

问题在于，最终的SQL最终将带有以相应表名作为前缀的列名:

The thing is that the resulting SQL ends up being with column names prefixed by the respective table names like:

select 
marketingc0_.a__IDPK_MarketingCategory as a__IDPK_1_0_0_, marketingc0_.Active as Active2_0_0_
from MarketingCategories as marketingc0_
where marketingc0_.a__IDPK_MarketingCategory=1

哪个FileMaker不会因为语法错误而抱怨:

which FileMaker doesn't accect complaining about the wrong syntax:

[08007] [27034] [FileMaker] [FileMaker JDBC] FQL0001/(1:153): 查询语法错误.

[08007][27034] [FileMaker][FileMaker JDBC] FQL0001/(1:153): There is an error in the syntax of the query.

但是，如果列名用双引号引起来，它会毫无疑问地吞噬SQL:

However it gulps down the SQL without complains if the column names are wrapped in double quotes like this:

select
    marketingc0_."a__IDPK_MarketingCategory" as a__IDPK_1_0_0_, marketingc0_."Active" as Active2_0_0_
    from MarketingCategories as marketingc0_
    where marketingc0_.a__IDPK_MarketingCategory=1

我想出的解决方案是将这些引号包括在实体注释中:

The solution I've come up with is including these quotes into the entity annotations:

public class MarketingCategory {
    @Id
    @Column(name = "\"a__IDPK_MarketingCategory\"")
    private Integer id;

    @Column(name = "\"a_ID_User\"")
    private Integer userId;

    @Column(name = "\"Active\"")
    private Boolean active;

...
}

这看起来不太好.

是否可以配置Hibernate，使其将所有列名称自动用双引号引起来?

Is it possible configure Hibernate so that it would wrap all the column names in double quotes automatically?

推荐答案

您可以在定义中将名为hibernate.globally_quoted_identifiers的属性设置为true，它将引用所有标识符.除了该选项外，还有一个选项不引用列，但没有选项仅引用列.

You can set a property named hibernate.globally_quoted_identifiers to true in your definitions and it will quote all identifiers. There is an option in addition to that to not quote the columns, but there is no option to only quote the columns.

这篇关于在Hibernate中将列名称用双引号引起来的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！