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!

Did you see this? https://hibernate.atlassian.net/browse/HHH-12393 There it's related to autocommit somehow. — Stefan Steinegger, Jan 15 '19 at 13:46

score 4 · Answer 1 · answered Nov 26 '19 at 09:48

4

Adding following application properties make it work for us:

spring.datasource.autoCommit=false

answered Nov 26 '19 at 09:48

Neo

5,070
10
46
65

In my case workeds adde in application.properties ''spring.datasource.hikari.auto-commit=false'' – YuriiS Jul 23 '22 at 09:40
2

Could you please describe shortly why this property solve the issue? Thanks! – dpelisek Sep 01 '22 at 11:48

HibernateException: Unable to access lob stream

1 Answers1