Hibernate Search - Mass indexing HHH000327: Error performing load command : org.hibernate.exception.GenericJDBCException: Could not read entity state from ResultSet
Background: So we have a field in Hibernate entity whose type is String (DB side VARCHAR 256)
And we wanted it to support length 10k.
We have ddl auto set to update and in prod environment we have Data in tables so we only have option to update the type of that field manually.
so same thing we tested in dev environment and found hibernate create type as LONG (Oracle 12c)
so we manually update it via following sql command .
alter table PAYMENT
ADD (NOTES_NEW LONG);
update SALE.PAYMENT SET NOTES_NEW = to_char(NOTES) where 1=1;
alter table PAYMENT drop column NOTES cascade constraints;
alter table PAYMENT rename column NOTES_NEW to NOTES;
now we have issue as described earlier .
please provide me what’s going wrong here why hibernate not able to be in sync of manual changes.
PS : in hibernate we already did like this
@Column(length = 10000)