Slow performance spring.io flow from ActiveMQ to OracleAQ with XA

[cknzl2014]

I have a Spring integration flow which bridges from ActiveMQ to OracleAQ.

See example project under GitHub - cknzl2014/springio-ora-xa.

When I run it without XA, it is blazingly fast.

With XA, it processes only 1 to 2 messages per second.

When profiling the application, I see that for every message a new physical connection is established, and with this, the metadata query is issued.

But I don't understand why it does this, and how I can prevent this from happening.

Does anyone of you guys have experience with OracleAQ and XA?

Could this be a problem with the XA transaction manager?

Thanks for your help,

Chris

[tomjenkinson]

Hi Chris,

I don't have OracleAQ here but we do have an example using XA: quickstart/spring/narayana-spring-boot at 21c5e9bed393ac4134e9aaf323c30a7d5600df42 · jbosstm/quickstart · GitHub

It sounds like you need some form of connection pooling enabled. I can't really speak for it's quality but a search found this article which seems to demonstrate the process: Using Connection Pooling with JMSTemplate in Spring Framework  – All Help & Support

Do you have a stack trace with the metadata query so I can see if there is something in Narayana that could be changed?

Many thanks,

Tom