johnou opened a new pull request, #421: URL: https://github.com/apache/commons-dbcp/pull/421
Motivation: Following up from our discussion https://github.com/apache/commons-dbcp/pull/411 AWS Aurora can produce SQL state codes that indicate non-fatal errors [1]. The current connection pool implementation doesn't handle these gracefully, leading to unnecessary evictions and performance issues. By introducing a mechanism to ignore specific non-fatal SQL state codes, we can improve connection stability and overall application performance. [1] https://github.com/awslabs/aws-mysql-jdbc?tab=readme-ov-file#connection-pooling Modification: Added a new configurable field disconnectionIgnoreSqlCodes to allow specifying SQL state codes that should be ignored during disconnection checks. Modified the connection pool logic to check against this new ignore list, preventing non-fatal errors from being treated as fatal disconnections. Updated the relevant methods and added Javadoc to explain the new functionality. Result: Improved handling of SQL state codes in AWS Aurora environments, reducing unnecessary connection evictions and improving performance. The connection pool is now more resilient to certain non-fatal SQL state codes, leading to fewer disruptions in environments where these codes are common. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
