[DSIP-84][Feature] Add Caché datasource support (#16833)

[edclol]

Purpose of the pull request

Add Caché datasource support to DolphinScheduler

close #16833

Brief change log

Added Caché constants in DataSourceConstants.java: JDBC driver class: com.Caché.jdbc.Driver; Validation query: "select 1"; JDBC URL prefix: jdbc:Cache://

Added Caché in DbType.java: CACHE(26, "cache") Added Caché in use-form.ts:

Added Caché in use-datasource.ts:

3、Configuration:

Added Caché datasource module to the build

Added documentation links in docsdev.js for both English and Chinese

4、Added new files:

Caché datasource implementation classes

Test classes for Caché datasource

UI related changes for Caché support

Verify this pull request

This change added tests and can be verified as follows:

Unit Tests Test Caché datasource connection parameters validation Test Caché connection creation and pooling Test JDBC driver loading and configuration Test datasource processor functionality Test channel factory implementation Test utility methods for Caché datasource

Connection Testing Test successful connection establishment with valid credentials Test connection failure with invalid credentials Test connection timeout scenarios Test connection pool behavior Test connection string parameter variations

Query Testing Test basic SELECT queries Test complex queries with joins Test query execution with different data types Test query timeout scenarios Test query error handling

UI Testing Verify Caché datasource form rendering Test form validation for required fields Test connection testing functionality from UI Verify proper display of connection status Test datasource creation workflow Test datasource editing functionality Test datasource deletion

Pull Request Notice

Pull Request Notice

If your pull request contain incompatible change, you should also add it to docs/docs/en/guide/upgrede/incompatible.md

[boring-cyborg[bot]]

Thanks for opening this pull request! Please check out our contributing guidelines. (https://github.com/apache/dolphinscheduler/blob/dev/docs/docs/en/contribute/join/pull-request.md)

[sonarqubecloud[bot]]

Quality Gate failed

Failed conditions
D Reliability Rating on New Code (required ≥ A)

See analysis details on SonarQube Cloud

Catch issues before they fail your Quality Gate with our IDE extension SonarQube for IDE

[github-actions[bot]]

This pull request has been automatically marked as stale because it has not had recent activity for 120 days. It will be closed in 7 days if no further activity occurs.

[github-actions[bot]]

This pull request has been closed because it has not had recent activity. You could reopen it if you try to continue your work, and anyone who are interested in it are encouraged to continue work on this pull request.