java - 使用的表型 Spring Boot 的最大行大小

Question

你好，我正在使用 Spring Boot，我需要在 mysql 服务器上创建我的实体，但我解决了错误:

** 原因为:java.sql.SQLSyntaxErrorException:行大小太大。所使用的表类型的最大行大小(不包括 BLOB)为 65535。这包括存储开销，请查看手册。您必须将某些列更改为 TEXT 或 BLOB**

我应该做什么来创建我的数据库!

类别是:

@Entity
public class rfpobject {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;
private int ide;
private String unit;
private String rfpid;
private String requestid;
private String incoming;
private String projecttitle;
private String serviceline;
private String businessunit;
private String requsitionbusinessunit;
private String country;
private String targetpropose;
private int rfx;
private String workflowtracking;
private String protocol;
private String jourfixkunde;
private String rejectedstatus;
private String closedreason;
private String practice;
private String startdate;
private String enddate;
private String vertragsart;
private String rfpcomment;
private double persondays;
private String accountexecutive;
private String accountsalesmanager;
private String expertsales;
private String deliveryunit;
private String deliveryresponsible;
private String requisitioner;
private String procurement;
private String referencenumber;
private int atoscontractno;
private String candidates;
private String itec;
private String tcv;
private String updated;
private String updatedby;
private String portfolio;
private String path;
private String rmprotocol;
private int rm;
private String wfm_id;
private String needconfopart;
private String confirmationofparticipation;
private String propose;
private String lastcall;
private String lastcalldate;
private String skills;
private String leistungserbringung;
private String rollefunktion;
private String inhaltscope;
private String laufzeitperspektive;
private String laufzeitangefragt;
private String phase;
private String fristverlaengerung;
private String closedstatus;
private String deferred_till;
private int sipa_yn;
private String po_no;
private int nessie_no;
private String number_of_persons;
private String att_job_site;
private String att_language;
private String att_main_topics;
private String ref_rfpid;
private String ref_history;
private String ref_rejections;
private String rv_rej_status_details;
private String rv_alliance_manager;
private String rv_final_status;
private String rv_cust_list_date;
private String rv_final_note;
private String rv_atos_root_causes;
private String currency;
private String externalid;
private String resultstatus;
private String reasoncode;
private String sysid;
private String ncrm_comment;
private String idemand_comment;
private String offshore_comment;
private String rv_rc_updby;
private String rv_rc_date;
private String rv_finalcomment;
private String rv_finaldate;
private double tcv_euro;
private int rem_active;
private int rem_send;
private int remcop_active;
private int remcop_send;
private String idemand;
private String idemand_url;
private int labour_leasing_yn;
private String cas_no;
private String prolongation;
private String rv_skills_miss_1;
private String rv_skills_miss_2;
private String rv_skills_miss_3;
private String ref_renewal_date;

所以当我执行时，我收到错误 Row Size Too Large应用程序属性:

spring.datasource.url=jdbc:mysql://localhost:3306/atos1?useSSL=false
spring.datasource.username=root
spring.datasource.password=
spring.jpa.hibernate.ddl-auto=create
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

Answer 1

每个字符串都会生成一个 VARCHAR(255) 列。

而且你有很多。这会导致错误。

您有两个选择:

1) 定义列大小

@Column(length = 20)
private String unit;

或

@Column(columnDefinition= "VARCHAR(20)")
private String unit;

2) 不要让 Hibernate 自己创建表并编写 DDL。