VSN-2685/ fix: slotIndex in file response, Hibernate PostgreSQL ClobJdbcType fix, deletedFileIds on update
Summary
-
FileMetadataResponseDtonow exposesslotIndexso clients can restore multi-slot image fields to their correct positions
when reloading a saved inspection - Native queries added to
InspectionFieldAnswerRepositoryto work around Hibernate 6.1 mapping@Lob String→ClobJdbcTypeon PostgreSQL, which causedPSQLException: Bad value for type longwhen reading plain TEXT columns - Column aliases corrected in the two native UPDATE queries (
section_id/subsection_idinstead of the old Hibernate-generated aliases) -
updateInspectionnow acceptsList<Long> deletedFileIdsso files can be explicitly removed during an inspection update -
application.ymlsetspreferred_long_string_jdbc_type: LONGVARCHARas a global Hibernate workaround for the same ClobJdbcType issue