[feat][EC][jdbc] add db2 database support with validation query mapping

[v-kkhuang]

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

The Linkis JDBC engine currently lacks proper support for DB2 database. The default validation query SELECT 1 does not work for DB2, which requires SELECT 1 FROM SYSIBM.SYSDUMMY1. Additionally, the schema query logic in SqlConnection needs to be updated to use proper DB2 system catalog queries.

Steps to reproduce

1. Create a JDBC connection to DB2 database
2. The connection validation fails with syntax error
3. Schema listing may not work correctly with current implementation

Expected behavior

DB2 connections should work properly with correct validation queries and schema retrieval should return accurate schema list from SYSCAT.SCHEMATA.

Your environment

• Linkis version used: 2.0.0
• Environment name and version:
  • hadoop-3.3.4
  • db2-11.x
  • jdk 1.8.0_xxx

Anything else

This PR adds:

• Validation query mapping configuration for different database types
• Default mapping includes Oracle and DB2 validation queries
• Updated DB2 SqlConnection to use proper SYSCAT.SCHEMATA query
• Configurable validation query mapping via wds.linkis.jdbc.validation.query.mapping

Are you willing to submit a PR?

• Yes I am willing to submit a PR!