[bug][EC][jdbc] JDBC connection pool validation query fails for Oracle and DB2 databases

[aiceflower]

Search before asking

• I had searched in the issues and found no similar issues.

Linkis Component

• linkis-commons
• linkis-computation-governance
• linkis-dist
• linkis-engineconn-plugin
• linkis-extensions
• linkis-orchestrator
• linkis-public-enhancements
• linkis-spring-cloud-services
• linkis-web

Description

JDBC engine connection pool uses "SELECT 1" as the default validation query, which works for MySQL and PostgreSQL but fails for Oracle and DB2 databases:

• Oracle requires: "SELECT 1 FROM DUAL"
• DB2 requires: "SELECT 1 FROM SYSIBM.SYSDUMMY1"

Currently, the code only hardcodes Oracle support but lacks DB2 support and a configurable mechanism for other databases.

Steps to reproduce

1. Configure a JDBC data source with Oracle or DB2 connection
2. Enable connection pool validation (testWhileIdle=true)
3. The validation query fails with SQL syntax error

Expected behavior

JDBC engine should support configurable validation queries for different database types:

• Auto-detect database type from JDBC URL
• Use appropriate validation query for each database
• Allow users to customize validation query mapping via configuration

Your environment

• Linkis version used: 1.9.0+
• Database types affected: Oracle, DB2

Anything else

This PR adds:

1. New configuration wds.linkis.jdbc.validation.query.mapping for custom validation queries
2. Default support for Oracle and DB2 databases
3. Auto-detection based on JDBC URL patterns

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

[github-actions]

😊 Welcome to the Apache Linkis community!!

We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context.
We will be here shortly.

If you are interested in contributing to our website project, please let us know!
You can check out our contributing guide on
👉 How to Participate in Project Contribution.

Community

WeChat Assistant	WeChat Public Account

Mailing Lists

Name	Description	Subscribe	Unsubscribe	Archive
dev@linkis.apache.org	community activity information	subscribe	unsubscribe	archive