Message Title

Henry Tung commented on

I can verify this occurring against Hibernate 5. Using Hibernate 5.1.0.Final as part of Dropwizard 1.0.0 (5.2.1 had some compatibility issues, so I had to override).

 
                                                                sql> ALTER TABLE account ALTER COLUMN reset_code BINARY(16);
(Update count: 0, 29 ms)
sql> SHOW COLUMNS FROM account;
FIELD           | TYPE          | NULL | KEY | DEFAULT
ID              | BIGINT(19)    | NO   | PRI | NULL
ADMIN           | BOOLEAN(1)    | NO   |     | NULL
CREATED         | TIMESTAMP(23) | NO   |     | NULL
EMAIL           | VARCHAR(255)  | NO   | UNI | NULL
HASHED_PASSWORD | VARCHAR(255)  | NO   |     | NULL
LAST_LOGIN      | TIMESTAMP(23) | YES  |     | NULL
VERIFY_CODE     | VARBINARY(16) | YES  |     | NULL
VERIFY_EXPIRE   | TIMESTAMP(23) | YES  |     | NULL
RESET_CODE      | VARBINARY(16) | YES  | UNI | NULL
RESET_EXPIRE    | TIMESTAMP(23) | YES  |     | NULL
 
                                                            

Relevant property blocks from Account entity:

 
                                                                @Entity
@Table(name = "account", indexes = {
        // ...
        @Index(name = "verify_code_idx", columnList = "verify_code, verify_expire"),
        @Index(name = "reset_code_idx", columnList = "reset_code, reset_expire")
})
public class Account implements Principal {

    // ...

    @Embedded
    @AttributeOverrides({
            @AttributeOverride(name = "code", column = @Column(name = "verify_code", unique = true)),
            @AttributeOverride(name = "expire", column = @Column(name = "verify_expire"))
    })
    @Nullable
    private ExpiringCode verify;

    @Embedded
    @AttributeOverrides({
            @AttributeOverride(name = "code", column = @Column(name = "reset_code", unique = true)),
            @AttributeOverride(name = "expire", column = @Column(name = "reset_expire"))
    })
    @Nullable
    private ExpiringCode reset;

    // ...

}
 
                                                            

and embedded entity ExpiringCode:

 
                                                                @Embeddable
public final class ExpiringCode {
    @Column(name = "code", unique = true, nullable = false)
    private UUID code;

    @Column(name = "expire", nullable = false)
    private Instant expire;

    // ...

}

Starting with hibernate.hbm2ddl.auto: validate, the following error is thrown:

 
                                                                Exception in thread "main" org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [reset_code] in table [account]; found [varbinary (Types#VARBINARY)], but expecting [binary (Types#BINARY)]
	at org.hibernate.tool.schema.internal.SchemaValidatorImpl.validateColumnType(SchemaValidatorImpl.java:170)
	at org.hibernate.tool.schema.internal.SchemaValidatorImpl.validateTable(SchemaValidatorImpl.java:155)
	at org.hibernate.tool.schema.internal.SchemaValidatorImpl.performValidation(SchemaValidatorImpl.java:100)
	at org.hibernate.tool.schema.internal.SchemaValidatorImpl.doValidation(SchemaValidatorImpl.java:67)
 
                                                            

Add Comment

This message was sent by Atlassian JIRA