Hello:
We are creating a REST layer on top of Broadleaf, using PostgreSQL as the database.. We have a Spring MVC Controller that calls our Service Layer, and then translates the results into DTOs (which are processed by Jackson to become JSON). Today, when attempting to read Products we hit a problem. Product currently use @Lob to map description. Despite the use of Lob the application is truncating at 256 characters. That is a issue, but not what has triggered this post. Today when doing a READ of products, I received this error:
org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
Has anyone seen this error and figured out what is causing it, or determined a work-around? At the moment we are using the OpenEntityManagerInViewFilter to allow our DTO translation to access any lazy-loaded collections. Could this be causing the problem?
If anyone has any ideas I would appreciate hearing them.
Thanks,
- John
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.