atomikos / transactions-essentials

Development repository for next major release of
https://www.atomikos.com/Main/TransactionsEssentials
Other
461 stars 139 forks source link

atomikos 5.0.8 XA maxPoolSize tomcat DB2 database #149

Closed numero90 closed 2 years ago

numero90 commented 3 years ago

hello,

we are using IBM DB2 database , atomikos 5.0.8 ans sprint boot 4.2 on tomcat with the following configuration : <Resource name="xxxx" auth="Container" type="com.atomikos.jdbc.AtomikosDataSourceBean" factory="org.bonitasoft.tomcat.atomikos.EnhancedTomcatAtomikosBeanFactory " uniqueResourceName="xxxx" xaDataSourceClassName="com.ibm.db2.jcc.DB2XADataSource" xaProperties.databaseName="test" xaProperties.serverName="localhost" xaProperties.currentSchema="test" xaProperties.driverType="4" xaProperties.portNumber="3306" xaProperties.user="USER" xaProperties.password="PASSWORD" maxPoolSize="400" minPoolSize="50" />

After several minuits, we have an error : connection pool exhausted - try increasing 'maxpoolSize'

Could you help me ?

Best regards

GuyPardon commented 2 years ago

Maybe connections are not released, or maybe there is a network blocking? Those things can cause this so maybe you can check for those?

Thanks

PS If you're interested then we can have a look too - as part of a free trial of our commercial offering. You can apply here:

https://www.atomikos.com/Main/ExtremeTransactionsFreeTrial