首页 > 解决方案 > @NotNull 注释在模式生成中不会转换为非空约束

问题描述

根据休眠验证器参考文档 - 第11.1.1 节。数据库模式级验证https://docs.jboss.org/hibernate/stable/validator/reference/en-US/html_single/#validator-checkconstraints-db),

开箱即用,Hibernate ORM 会将您为实体定义的约束转换为映射元数据。例如,如果您的实体的属性被注释为@NotNull,则其列将在 Hibernate ORM 生成的 DDL 模式中声明为非空。

但是当我用@NotNull 注释我的字段时,我没有自动获得架构级别的约束。

我尝试设置Environment.HBM2DDL_AUTOupdatecreate但都没有生成数据库约束。

即使默认情况下休眠已hibernate.validator.apply_to_ddl设置为true,我什至尝试手动设置 -

settings.put("hibernate.validator.apply_to_ddl", true);

但这些选项似乎都不适合我。

我的域类

package com.praveen.domain;

import javax.persistence.Entity;
import javax.validation.constraints.NotNull;

import lombok.Data;

@Entity
@Data
public class Stakeholder extends MyPersistent {

    @NotNull
    private String clientCode;

    @NotNull
    private String gender;
}

MyPersistent 类

package com.praveen.domain;

import java.io.Serializable;

import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.MappedSuperclass;

import lombok.Getter;
import lombok.Setter;

@MappedSuperclass
@Getter
@Setter
public class MyPersistent implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
}

我用来获取会话工厂的代码是

    private static SessionFactory getSessionFactory() {
        if (sessionFactory == null) {
            try {
                StandardServiceRegistryBuilder registryBuilder = new StandardServiceRegistryBuilder();

                Map<String, Object> settings = new HashMap<>();
                settings.put(Environment.DRIVER, Driver.class.getName());
                settings.put(Environment.URL, "jdbc:mysql://localhost:3306/hibernate_test?"
                        + "zeroDateTimeBehavior=CONVERT_TO_NULL&"
                        + "createDatabaseIfNotExist=true&"
                        + "useSSL=true&"
                        + "verifyServerCertificate=false&"
                        + "autoReconnect=true");
                settings.put(Environment.USER, "root");
                settings.put(Environment.PASS, "");
                settings.put(Environment.DIALECT, MySQL55Dialect.class);
                settings.put(Environment.HBM2DDL_AUTO, "update");
                settings.put(Environment.SHOW_SQL, false);

                // HikariCP settings
                settings.put("hibernate.hikari.connectionTimeout", "20000");
                settings.put("hibernate.hikari.minimumIdle", "5");
                settings.put("hibernate.hikari.maximumPoolSize", "20");
                settings.put("hibernate.hikari.idleTimeout", "300000");

                registryBuilder.applySettings(settings);
                registry = registryBuilder.build();
                MetadataSources sources = new MetadataSources(registry);
                sources.addAnnotatedClass(Stakeholder.class);

                Metadata metadata = sources.getMetadataBuilder().build();
                sessionFactory = metadata.getSessionFactoryBuilder().build();
            } catch (Exception e) {
                e.printStackTrace();
                shutdown();
            }
        }
        return sessionFactory;
    }

标签: javahibernatehibernate-validatorhibernate-5.xmysql-5.5

解决方案


您应该使用 @Column(nullable = false)

@NotNull 用于 Bean 验证,而不是模式约束,如果您使用的是旧版本的 hibernate,@NotNull 将不会被转换为列约束


推荐阅读