为什么 JPA/hibernate 不能映射到 MySQL blob 类型？

我收到以下错误

Caused by: org.hibernate.HibernateException: Wrong column type in TestTable for column PAYLOAD. Found: blob, expected: tinyblob
    at org.hibernate.mapping.Table.validateColumns(Table.java:284)
    at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1174)
    at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
    at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:387)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:883)
    ... 60 more

hibernate 抱怨的列被声明为

private byte[]  messagePayload;

@Column(name="PAYLOAD")
public byte[] getMessagePayload() {
        return messagePayload;
}

public void setMessagePayload(byte[] messagePayload) {
 this.messagePayload = messagePayload;
}

MySQL表中的表被声明为BLOB类型。为什么 Hibernate 不想映射到它，为什么它坚持要我使用 TINYBLOB？

Thanks

您可以尝试使用显式设置类型 blob列定义属性。像这样：

@Column(name="PAYLOAD",columnDefinition="blob")

或者使用@Lob注释：

@Column(name="PAYLOAD")    
@Lob(type = LobType.BLOB)