Uploaded image for project: 'Hibernate ORM'
  1. Hibernate ORM
  2. HHH-11614

Wrong result for @Lob column with postgresql DB since 5.2.9

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.2.9, 5.2.10
    • Fix Version/s: 5.2.11
    • Component/s: None
    • Labels:
      None
    • Environment:
      postgresql driver 9.4.1212, postgresql 9.6.2, spring boot 1.5.3.RELEASE, spring data jpa 1.11.3
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Worked in:
    • Last commented by a user?:
      true
    • Sprint:

      Description

      internal reference number instead of referenced LOB content is returned for @Lob annotated text column mapped to String entity field for postgresql DB.
      Error occurs by using current release (5.2.9) together with Spring Data Queries (JPA Criteria API)

          @Lob
    @Column(name = "settings")
    private String settings;

        Attachments

          Issue links

          caused by

          Bug - A problem which impairs or prevents the functions of the product. HHH-11477 HQL query against field marked with @Lob fails on PostgreSQL

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. HHH-12201 DataException for @Lob column with postgresql DB since 5.2.11

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: