mysql – Compound key (Embeddable) generating an error while running DDL – Spring data JPA

I want to create a composite key in an entity, but when the table is going to be generated in mysql, the following error occurs:

org.hibernate.tool.schema.spi.CommandAcceptanceException: DDL runtime error via a JDBC statement

In the details, it is stated that a length of the key was not specified because it is a Blob / Text field as below:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: The "request" BLOB / TEXT column used in the key specification without key length

The code generated in the DDL is incorrect because the fields must be numeric and not those specified in the error:

create a table evaluation (
request tinyblob not null,
tiny non-zero seller,
varchar score (255),
primary key
) engine = MyISAM

The class is the following and has mapped a long key as the primary key:

@Entity
public class Request implements Serializable {

private static final long serialVersionUID = 1L;

id
private Long id;
private user;
private Date RequestDate;
private Date of shipment;
private date processing;
private date delivery;
private date of finalization;
private BigDecimal rateCompra;
status of private request status;
privatePaymentPaymentPaymentPayment;
private Endereco Delivery addressDelivery;
private user purchaser;
delivery by the private user;
private set items = new HashSet <> ();

... GetSet ... constrution ...

The provider entity class also inherits a long field as the id, specified in the PersonJuridica entity.

        public class Seller extends PersonJuridica {
private static final long serialVersionUID = 1L;

private phoneSAC channel;
private Boolean performs;
private segment segment;
private set Neighborhoods = New HashSet <> ();
private set itemsSeller = new HashSet <> ();
private Boolean vendaActive;
private BigDecimal rateSeller;

public seller () {
Great ();
}

public provider (long identifier, string pass, string name, email address, active boolean, TypePerson type, cnpj string, StringoSocial,
StringInteractiveString, String nameRepresentant, String phoneRepresentant,
EmailRepresenting String, StringSAC phone, Boolean performDelivery, Boolean saleActive, BigDecimal Merchant Rate) {
super (username, password, name, email, active, type, cnpj, rankSocial, enrollment, nameRepresentant,
emailRepr├ęsentant);
this.telephoneSAC = phoneSAC;
this.realizesDelivery = realizesDelivery;
this.vendaActive = sellAtiva;
this.TextSeller = RateSeller;
} ...

I want to build an evaluation entity as below, where the id is a composite key using @EmbeddedId annotation:

@Entity
public class Evaluation implements Serializable {

private static final long serialVersionUID = 1L;

@EmbeddedId
private EvaluatePK id = new EvaluatePK ();

@Enumerated (EnumType.STRING)
Private score EvaluationAum;
...

The class that represents the composite key is the APK evaluation below:

@ Embeddable
The public class EvaluationPK implements Serializable {

private static final long serialVersionUID = 1L;

@ManyToOne
private demand request;

@ManyToOne
private seller;
...

I do not identify the cause of the generation of the wrong DDL file in the composite key, which prevents you from creating the table.

Here is the configuration of the spring date to access the database tables and create them in Application.properties.

spring.jpa.hibernate.ddl-auto = update
spring.datasource.url = jdbc: mysql: // localhost: 3306 / voucompreidb? useSSL = false
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

spring.datasource.username = user
spring.datasource.password = 12345

spring.jpa.show-sql = true
spring.jpa.properties.hibernate.format_sql = true