Axon: 1.1.2
Hibernate Entity Manager: 3.6.7.Final
PostgreSQL JDBC: 9.0-801.jdbc4
I am receiving the following error after restarting a system which has
placed a few entries into a saga: org.postgresql.util.PSQLException:
Large Objects may not be used in auto-commit mode.
It is failing on line 132 of JpaSagaRepository when it retrieves
values for the AssociationValueEntry entity in the "initialize"
method.
The EJB3 specification states that auto commit must be enabled. The
source for Ejb3Configuration in Hibernate even checks to ensure that
the auto commit is enabled. The solution is that the call to the
database must be wrapped in a transaction. However, since the code in
JpaSagaRepository is called as a @PostConstruct simply placing a
"@Transactional" may not work if it hasn't been configured yet.
I'm at a loss to a solution. I have not encountered this issue with
Oracle or MySQL but PostgreSQL needs a transaction when retrieving
Lobs.
Any guidance to this problem would be greatly appreciated.
Thanks,
Seamus