HibernateException: Unable to access lob stream

Question

I have a problem. I have a Spring Boot project using Hibernate and I can not query an OID in the database.

@Lob
@Column(name = "documento_oid")
private byte[] documentoOid;

Query:

if (tupled) {
        return em.createQuery(getTupleQuery())
                .setMaxResults(1)
                .getResultList().stream().findFirst().map(t -> (T) getWrappedInstance(t)).orElse(null);
    } else {
        return em.createQuery(getQueryT())
                .getSingleResult();
    }

Error: javax.persistence.PersistenceException: org.hibernate.HibernateException: Unable to access lob stream

Help me!

Answer 1

Adding following application properties make it work for us:

spring.datasource.autoCommit=false