Convert data types for JPA Views' name and description fields (task, data entry, process definition) from @Lob to simple String column

holunda-io / camunda-bpm-taskpool

Library for pooling user tasks and process related business objects.

https://www.holunda.io/camunda-bpm-taskpool/

Apache License 2.0

68 stars 26 forks source link

Closed zambrovski closed 1 year ago

zambrovski commented 1 year ago

camunda-bpm-taskpool version: 3.9.1
Camunda BPM version: 7.18
Description of your use case: There is no effective way to search in lobs. Consider switching to simple columns with texts stored directly in the table space.

name and descriptions are lobs

name and descriptions are strings

none

zambrovski commented 1 year ago

@lbilger I'll need some testing of this feature on your side, to make sure we don't break existing functionality entirely.

lbilger commented 1 year ago

I don't think we have any names or descriptions exceeding the maximum varchar column length but I can check to be sure.