zy-kkk opened a new pull request, #22498: URL: https://github.com/apache/doris/pull/22498
## Proposed changes Issue Number: close #xxx In this PR, we've made improvements to the JDBC Catalog in the Frontend (FE) of Doris, specifically when connecting to the JDBC Catalog via the Druid connection pool. Changes include: 1. **Connection Keepalive Mechanism**: We've added a connection keepalive mechanism to the Druid connection pool to prevent connections from becoming inactive during long periods of inactivity. This is achieved by setting a validation query that is executed periodically on idle connections. The queries are database-specific (Oracle, SAP HANA, etc.) to ensure compatibility. 2. **Detailed Error Messaging**: We've improved error messaging by throwing more specific exceptions when a connection error occurs in the Druid connection pool. This change will provide more detailed error messages, aiding in understanding and debugging connection-related issues. These improvements will make the JDBC Catalog more robust and easier to maintain, particularly in scenarios where connections in the Druid connection pool are expected to be idle for extended periods of time. ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
