When importing a workflow using PostgreSQL, we have to set autocommit to false or we get the exception below. The issue is likely we need to use a UnitOfWork around the import.
Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:262)
at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:248)
at org.postgresql.jdbc.AbstractBlobClob.getLo(AbstractBlobClob.java:272)
at org.postgresql.jdbc.AbstractBlobClob.getBinaryStream(AbstractBlobClob.java:116)
at org.postgresql.jdbc.PgClob.getCharacterStream(PgClob.java:52)
at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:280)
... 74 more