At present hiberante is mapping incorrectly text fields doing this:

It creates a CLOB and assign the oid create to the text columns.
This causes several problems described in this https://hibernate.atlassian.net/browse/HHH-14211

And this is the root cause we have this scripts
https://github.com/kiegroup/jbpm/blob/main/jbpm-db-scripts/src/main/resources/db/ddl-scripts/postgresql/postgresql-jbpm-lo-trigger-clob.sql

that is should not be needed as text field should store the data.

This contributor should fix the problem as hibernate is walking another path regarding how to fix the mapping (they will move the mapping to oid as they are creating a clob and seems the spec requires to turn @Lob fields into clob and not text)

    public class TextContributorType extends StandardBasicTypeTemplate<String> {

        private static final long serialVersionUID = 1619875355308645967L;

        public TextContributorType() {
            super(LongVarcharTypeDescriptor.INSTANCE, StringTypeDescriptor.INSTANCE, StandardBasicTypes.MATERIALIZED_CLOB.getName());
        }

    }