Martin Polanka (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDE5OWEwZWM3...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-16192?atlOrigin=eyJpIjoiMDE5OW...
) HHH-16192 (
https://hibernate.atlassian.net/browse/HHH-16192?atlOrigin=eyJpIjoiMDE5OW...
) Hibernate Envers triggers wrong column type during validation (
https://hibernate.atlassian.net/browse/HHH-16192?atlOrigin=eyJpIjoiMDE5OW...
)
Issue Type: Bug Affects Versions: 6.1.6 Assignee: Chris Cranford (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) Components: hibernate-envers Created: 17/Feb/2023 01:30 AM Environment: JVM: temurin-17
OS: Win10
DB: h2 Priority: Major Reporter: Martin Polanka (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
I have a Spring Boot project which I updated to SB3, before everything worked, but after
update I am getting schema-validation error in audit tables. Minimal sample project can be
found here
https://github.com/Neloop/sb3-hibernate-envers-demo (
https://github.com/Neloop/sb3-hibernate-envers-demo )
The project uses liquibase as migration tool and with it the database structure is
created, in this case there is only one table 'demo' and two audit tables. If I
try to run the project I get:
org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column
type encountered in column [description] in table [demo_aud]; found [character
(Types#CLOB)], but expecting [varchar(255) (Types#VARCHAR)]
Which is unexpected because on the *DemoEntity* there is column *description* which has
*@Lob* annotation and therefore its type should definitely not be VARCHAR(255), but it
seems that envers metadata thinks that it is. It seems like a regression, because as I
said this was working before I updated to SB3 with Hibernate 6.1
(
https://hibernate.atlassian.net/browse/HHH-16192#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-16192#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100216- sha1:3fa9804 )