Currently jBPM/RHPAM supports databases provided by hibernate orm. Currently we are facing problems with just one of the dialects: postgreSQL.
At present this dialects supports oid which is a problem in certain enviornments like AWS, also some users are reluctant to use this as blob to store some of the data we use at jBPM.

While the use of @typedef could fix our problem AFAIK this would affect all dialects and I could not find a way to restrict or activate only under certains flags (var env) or circunstances (e.g. certain dialect)

It would be perfect to be able to set some sort of condition when some typedef applies. if that is not possible I would like to know if there is a workaround to provide a way programatically or not to set a type def.

This would allow us to migrate to a new schema based on bytea instead of oid eventually to all users.

After dicussion we are trying to avoid the subclassing of the dialect as it would tied the user to a jbpm solution and not really a OOTB solution provided by hibernate team.

Keep in mind that we use hibernate through JPA spec.