Significant performance degradation in JDBC/JCA layer in JBoss EAP 7.3.10 or JBoss EAP 7.4.2+

Environment

• Red Hat JBoss Enterprise Application Platform (EAP)
  • 7.4 CP2
  • 7.3 CP10

Issue

After updating to EAP 7.4.2+ or EAP 7.3.10, the performance with Cloud-based database has deteriorated significantly

Resolution

Update to EAP 7.4.7+ (= apply CP7 or later) once it's released, then set the system property

-Dironjacamar.jdbc.setautocommitoncleanup=false

to the EAP's start-up command.

Root Cause

• This content is not included.JBEAP-23909
• The root cause of this problem has been traced to the change This content is not included.JBJCA-1431 introduced in EAP 7.4 Update 2. In order to mitigate this issue in EAP 7.4 Update 7 a new property ironjacamar.jdbc.setautocommitoncleanup has been added. Setting this property to false will bypass the above change and eliminate the poor performance resulting from This content is not included.JBJCA-1431.
• To our best knowledge this above issue happens only when EAP uses cloud-based database server with high latency.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.