Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
7.26.0.Final
-
None
-
NEW
-
NEW
Description
When
kie-server-spring-boot-starter is integrated with SQL server 2016, the start up fails.Please note sql server 2016 is XA compliant.
""2020-06-30 11:06:45,280 INFO : %PARSER_ERROR[l] HHH000206: hibernate.properties not found""2020-06-30 11:06:45,280 INFO : %PARSER_ERROR[l] HHH000206: hibernate.properties not found""2020-06-30 11:06:46,027 WARN : %PARSER_ERROR[l] ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR"javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_recover', database 'master', schema 'dbo'. at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:756) at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:837) at me.snowdrop.boot.narayana.core.jdbc.DataSourceXAResourceRecoveryHelper.recover(DataSourceXAResourceRecoveryHelper.java:109) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:609) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:201) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:146) at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:765) at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:377)"20
The same code works fine with SQL server 2019 which is XA compilant.