Error loading situations when using Fuse 6.2.1 with PostgreSQL

Issue

We have installed and configured RTGov (server) from Fuse 6.2.1 with PostgreSQL database.

When we access the Situations tab in the http://localhost:8080/rtgov-ui/ application, the situations are not loaded. Depending on the selected value in the 'Status' field, this results either in a NullPointerException shown in the UI (with no ERROR in the log file), or the following ERROR in the log:

INFO [Version] HCANN000001: Hibernate Commons Annotations {4.0.2.Final-redhat-1}
INFO [Version] HHH000412: Hibernate Core {4.2.22.Final-redhat-1}
INFO [Environment] HHH000206: hibernate.properties not found
INFO [Environment] HHH000021: Bytecode provider name : javassist
INFO [Configuration] HHH000044: Configuring from URL: vfs:/content/overlord-rtgov.war/WEB-INF/lib/situation-store-jpa-2.0.2.redhat-5.jar/situationstore.hibernate.cfg.xml
INFO [Configuration] HHH000041: Configured SessionFactory: null
INFO [Dialect] HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
INFO [LobCreatorBuilder] HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
INFO [TransactionFactoryInitiator] HHH000399: Using default transaction strategy (direct JDBC transactions)
INFO [ASTQueryTranslatorFactory] HHH000397: Using ASTQueryTranslatorFactory
WARN [SessionFactoryImpl] HHH000008: JTASessionContext being used with JDBCTransactionFactory; auto-flush will not operate correctly with getCurrentSession()
ERROR [stderr] org.hibernate.HibernateException: Unable to access lob stream
ERROR [stderr]  at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:285)
ERROR [stderr]  at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:89)
ERROR [stderr]  at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:39)
ERROR [stderr]  at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60)
ERROR [stderr]  at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
ERROR [stderr]  at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)
ERROR [stderr]  at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261)
ERROR [stderr]  at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:251)
ERROR [stderr]  at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:336)
ERROR [stderr]  at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2924)
ERROR [stderr]  at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695)
ERROR [stderr]  at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)
ERROR [stderr]  at org.hibernate.loader.Loader.getRow(Loader.java:1509)
ERROR [stderr]  at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:719)
ERROR [stderr]  at org.hibernate.loader.Loader.processResultSet(Loader.java:949)
ERROR [stderr]  at org.hibernate.loader.Loader.doQuery(Loader.java:917)
ERROR [stderr]  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
ERROR [stderr]  at org.hibernate.loader.Loader.doList(Loader.java:2550)
ERROR [stderr]  at org.hibernate.loader.Loader.doList(Loader.java:2536)
ERROR [stderr]  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
ERROR [stderr]  at org.hibernate.loader.Loader.list(Loader.java:2361)
ERROR [stderr]  at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
ERROR [stderr]  at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
ERROR [stderr]  at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
ERROR [stderr]  at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)
ERROR [stderr]  at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
ERROR [stderr]  at org.overlord.rtgov.analytics.situation.store.jpa.JPASituationStore$4.perform(JPASituationStore.java:136)
ERROR [stderr]  at org.overlord.rtgov.analytics.situation.store.jpa.JPASituationStore$4.perform(JPASituationStore.java:133)
ERROR [stderr]  at org.overlord.rtgov.common.jpa.JpaStore.withJpa(JpaStore.java:181)
ERROR [stderr]  at org.overlord.rtgov.analytics.situation.store.jpa.JPASituationStore.getSituations(JPASituationStore.java:133)
ERROR [stderr]  at org.overlord.rtgov.ui.provider.situations.RTGovSituationsProvider.querySituations(RTGovSituationsProvider.java:828)
ERROR [stderr]  at org.overlord.rtgov.ui.provider.situations.RTGovSituationsProvider.search(RTGovSituationsProvider.java:292)
ERROR [stderr]  at org.overlord.rtgov.ui.server.services.impl.SituationsProviderServiceImpl.search(SituationsProviderServiceImpl.java:63)
...
ERROR [stderr] Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
ERROR [stderr]  at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:265)
ERROR [stderr]  at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:251)
ERROR [stderr]  at org.postgresql.jdbc.AbstractBlobClob.getLo(AbstractBlobClob.java:275)
ERROR [stderr]  at org.postgresql.jdbc.AbstractBlobClob.getBinaryStream(AbstractBlobClob.java:119)
ERROR [stderr]  at org.postgresql.jdbc.PgClob.getCharacterStream(PgClob.java:55)
ERROR [stderr]  at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:278)
ERROR [stderr]  ... 97 more
ERROR [stderr] org.hibernate.HibernateException: Unable to access lob stream
...
ERROR [stderr] Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
ERROR [stderr]  at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:265)
ERROR [stderr]  at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:251)
ERROR [stderr]  at org.postgresql.jdbc.AbstractBlobClob.getLo(AbstractBlobClob.java:275)
ERROR [stderr]  at org.postgresql.jdbc.AbstractBlobClob.getBinaryStream(AbstractBlobClob.java:119)
ERROR [stderr]  at org.postgresql.jdbc.PgClob.getCharacterStream(PgClob.java:55)
ERROR [stderr]  at org.hibernate.type.descriptor.java.DataHelper.extractString(DataHelper.java:278)
ERROR [stderr]  ... 97 more