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

Cannot store lob without setting autocommit to false for postgres

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Done
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.1
    • Fix Version/s: 4.0
    • Component/s: Core
    • Labels:
      None

      Description

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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

                    Tasks

                    Progress: 
                     0/0