edclol opened a new issue, #16833: URL: https://github.com/apache/dolphinscheduler/issues/16833
### Search before asking - [X] I had searched in the [DSIP](https://github.com/apache/dolphinscheduler/issues/14102) and found no similar DSIP. ### Motivation After searching in the DSIP, no similar plan for adding Caché database support was found. We propose to add Caché as a new supported datasource in DolphinScheduler. This will enable users to interact with Caché databases seamlessly in their workflow orchestration and enrich the available datasource types. ### Design Detail 1、Documentation additions: Added English and Chinese documentation for Caché datasource Added Caché connection parameter descriptions Added UI screenshots for both languages 2、Code changes: Added Caché JDBC driver dependency (version 2.0.0) 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: CACHE: { value: 'CACHE', label: 'CACHE', defaultPort: 1972 } Added Caché in use-datasource.ts: { id: 26, code: 'CACHE', disabled: false } 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 The commit adds full Caché integration as a new datasource type in DolphinScheduler with complete documentation, implementation, and testing support. ### Compatibility, Deprecation, and Migration Plan _No response_ ### Test Plan 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 Integration Tests 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 ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
