[JBoss] IBM XA DataSource throwing resultset is closed error

Recently we have started migration from Spring , Hibernate 5.x to 6.x. We were getting below error on XA data source but non XA data source was working fine. (Jboss 8 application server)

[jcc][t4][10120][10898][4.x.x] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null


After applying below additional configuration to XA data source its working fine.

Add custom property name="downgradeHoldCursorsUnderXa", value="true" and type="java.lang.Boolean"
Add custom property name="resultSetHoldability", value="1", and type="java.lang.Integer"


IBM Article

I want to know what is the impact of these two properties ?

Thanks,

Continue reading...