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

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

      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.

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

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

                Created:
                Updated:
                Resolved: