State
[Progress record]:
Proposed time: 2022/05/08
Discussion time:
Acceptance time:
Completion time: 2022/06/08
[issues]: https://github.com/apache/incubator-linkis/projects/12
[email]：leojie1314@gmail.com
[release]:
[Proposerproposer]: leojie
Motivation & Background
...
Basic concept
Expect to achieve goals
...
- Support Linkis to specify the data source connection name when submitting scripts
...
- Support Linkis JDBC engine to obtain data source connection information according to the incoming data source connection name when executing sql script, and then construct the corresponding database connection pool.
Implementation plan
...
- When the script submits a request to the /api/rest_j/v1/entrance/submit interface, pass in the dataSources parameter
...
- In the JDBCEngineConnExecutor, if the dataSources pass value is obtained, it will obtain the data source connection information according to the dataSource name, then construct the corresponding data source connection pool, and finally execute the sql. If the dataSource name is not specified, the original logic will be followed.
...
- The data source name parameter is stored in the first line of the script through an identifier like: %data_source_name, which is similar to the parsing and storage mechanism of variable parameters.
Things to Consider & Note:● Do
- Do you need to consider the compatibility of the original parameter method?
Changes
| Modification | Detail | |
|---|---|---|
| 1 | Modification of maven module | |
| 2 | Modification of HTTP interface | |
| 3 | Modification of the client interface | |
| 4 | Modification of database table structure | |
| 5 | Modification of configuration item | |
| 6 | Modification Error code | |
| 7 | Modifications for Third Party Dependencies |
...