SQL语句“CREATE TABLE TRIP……”中存在语法错误

Question

错误消息：

[错误]运行得测试：1,失败：0,错误：1,跳过得：0,运行得时间：3.003s<<<失败！-在org.studentnr.backend.service.userserviceTest[错误]org.studentnr.backend.service.userserviceTest.testCreateUser所用时间：0.004s<<<错误！java.lang.IllegalStateException：未能加载ApplicationContext,原因是：org.SpringFramework.Beans.Factory.BeanCreationException：创建类路径资源[org/SpringFramework/boot/autocigure/flyway/flywayAutoConfiguration$flywayConfiguration.class]中定义的名为“Flyway初始化器”的bean时出错：调用init方法失败；嵌套异常为org.flywaydb.core.internal.command.dbmigrate$flywaymigrateexception：迁移v1.0__createdb.sql失败

SQL状态：42000错误代码：42000消息：SQL语句“CREATE TABLE TRIP（ID BIGINT默认生成为标识，标题VARCHAR(255)不为NULL，说明VARCHAR(255)，成本整数不为NULL，位置VARCHAR(124)不为NULL，出发日期不为NULL，返回日期不为NULL，主键(ID)”中存在语法错误

我的flyway sql脚本：

create sequence hibernate_sequence start with 1 increment by 1;

create table user_roles (user_email varchar(255) not null, roles varchar(255));

create table users (email varchar(255) not null, firstname varchar(50) not null, middle_name 
varchar(50), surename varchar(50) not null, password varchar(255) not null, address 
varchar(128) not null, postal_code varchar(124) not null, enabled boolean not null, primary 
key (email));

create table purchase (id bigint generated by default as identity, booked_date date not 
null, user_email varchar(255) not null, trip_id bigint not null, primary key (id));

create table trip (id bigint generated by default as identity, title varchar(255) not null, 
description varchar(255), cost integer not null, location varchar(128) not null, departure 
date not null, returning date not null, primary key (id))


alter table user_roles add constraint FKs9rxtuttxq2ln7mtp37s4clce foreign key (user_email)         
references users;

alter table purchase add constraint FKlqrv1aj0pon999jbi5esfpe4k foreign key (user_email) 
references users;

以下是我的旅行实体：

package org.studentnr.backend.entities;

import javax.persistence.*;
import javax.validation.constraints.*;
import java.time.LocalDate;

@Entity
public class Trip {

 @Id @GeneratedValue
 private Long id;

 @NotBlank
 @Size(max=255)
 private String title;

 //@NotBlank //TODO: Can be blank???
 @Size(max=255)
 private String description;

 //@Min(0) TODO: remember to add 'check (cost>0)' to flyway to avoid using negative values
 @NotNull
 private Integer cost;

 @NotBlank
 @Size(max = 124)
 private String location;

 @NotNull
 @Future   
 private LocalDate departure;

 @NotNull
 @Future  
 private LocalDate returning;



public Trip(){
}

public Long getId() {
    return id;
}

public void setId(Long id) {
    this.id = id;
}

public String getTitle() {
    return title;
}

public void setTitle(String title) {
    this.title = title;
}

public String getDescription() {
    return description;
}

public void setDescription(String description) {
    this.description = description;
}

public int getCost() {
    return cost;
}

public void setCost(int cost) {
    this.cost = cost;
}

public String getLocation() {
    return location;
}

public void setLocation(String location) {
    this.location = location;
}

public LocalDate getDepartureDate() {
    return departure;
}

public void setDepartureDate(LocalDate departureDate) {
    this.departure = departureDate;
}

public LocalDate getReturnDate() {
    return returning;
}

public void setReturnDate(LocalDate returnDate) {
    this.returning = returnDate;
}



}

Answer 1

脚本中有两个错误：

1. 在CREATE TRIP语句的末尾缺少；。
2. returning是保留关键字。您将不得不引用它“返回”日期-但如果您找到一个不同的名称，从长远来看会更容易。

如果纠正了这两件事，脚本就可以工作了