Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-24570

Change in application/hibernate interaction after upgrading EAP 7.1 to EAP 7.4

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • None
    • 7.4.6.GA
    • JPA/Hibernate
    • None
    • False
    • None
    • False

    Description

      In EAP 7.1, the customer was initially facing the DB2 driver exception:

      DB2 SQL Error: SQLCODE=-840, SQLSTATE=54004, SQLERRMC=null, DRIVER=4.19.66

      From DB2: Explanation: Number of selected items exceeds 8000

      To resolve this, the customer changed their ToOne associations to @LazyToOne(LazyToOneOption.PROXY)

      This resolved the issue in EAP 7.1

      After migrating to EAP 7.4, the issue is occurring again, and the customer thinks that lazy loading is not working.

      We collected sql trace logs from both environments to compare the queries. Both queries are quite large, but the query from EAP 7.4 does appear to be larger.

       

      I have attached both logs and a docx that the customer provided, which contains the relevant entities, etc.

      Attachments

        1. 7.1_server.log
          20.10 MB
        2. 7.4.6_server.log
          14.89 MB
        3. Lazy_Loadding_Issue.docx
          23 kB

        Activity

          People

            Unassigned Unassigned
            rhn-support-tcowhey TJ Cowhey
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: