Uploaded image for project: 'DataWolf'
  1. DataWolf
  2. WOLF-213

Cannot store lob without setting autocommit to false for postgres

XMLWordPrintableJSON

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 4.0
    • 3.1
    • Core
    • None

      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

              cnavarro Christopher Navarro
              cnavarro Christopher Navarro
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 6 hours
                  6h
                  Remaining:
                  Remaining Estimate - 6 hours
                  6h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified