Unable to access lob stream with Postgres for @lob field

Description

I've just upgraded to 5.2.15, I come from 5.1.0.

I have only one entity with only one field annotated with @lob.

I'm not anymore able to get those entities due to this:

javax.persistence.PersistenceException: org.hibernate.HibernateException: Unable to access lob stream
...
Caused by: org.hibernate.HibernateException: Unable to access lob stream
...
Caused by: org.postgresql.util.PSQLException: Non è possibile impostare i «Large Object» in modalità «auto-commit».

I've read this but for what I understand using 5.2.15 with @lob should change nothing compared with releases prior to 5.2.9, am I wrong?

Environment

None

Activity

Show:
Raffaele Gambelli
March 15, 2018, 1:02 PM

I went back to a 5.1.*, this time 5.1.12 and it worked fine.

I can't understand why the "Large Objects may not be used in auto-commit mode" can center with the transition from hibernate 5.1 to 5.2, what do you think?

Raffaele Gambelli
March 15, 2018, 1:35 PM

I'm sorry, it's a false issue, I had introduced hikaricp too in my application and I didn't know that for hikaricp autocommit was true by default.

That Postgres error is due to autocommit true, you can delete this issue, thanks and sorry again.

Steve Ebersole
March 15, 2018, 1:59 PM

Thanks for following up

Assignee

Unassigned

Reporter

Raffaele Gambelli

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major
Configure