This is an automated email from the ASF dual-hosted git repository. acosentino pushed a commit to branch 0.9.x in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 068cf42494adba2055c9a5d759c2c871ef6df735 Author: Andrea Cosentino <[email protected]> AuthorDate: Wed Oct 26 12:03:36 2022 +0200 SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server Signed-off-by: Andrea Cosentino <[email protected]> --- .../resources/kamelets/sqlserver-source.kamelet.yaml | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) diff --git a/library/camel-kamelets/src/main/resources/kamelets/sqlserver-source.kamelet.yaml b/library/camel-kamelets/src/main/resources/kamelets/sqlserver-source.kamelet.yaml index 13ce487f..0976468a 100644 --- a/library/camel-kamelets/src/main/resources/kamelets/sqlserver-source.kamelet.yaml +++ b/library/camel-kamelets/src/main/resources/kamelets/sqlserver-source.kamelet.yaml @@ -81,6 +81,20 @@ spec: description: A query to run on a tuple consumed type: string example: 'DELETE FROM accounts where user_id = :#user_id' + encrypt: + title: Encrypt Connection + description: Encrypt the connection to SQL Server. + type: boolean + x-descriptors: + - 'urn:alm:descriptor:com.tectonic.ui:checkbox' + default: false + trustServerCertificate: + title: Trust Server Certificate + description: Trust Server Ceritificate + type: boolean + x-descriptors: + - 'urn:alm:descriptor:com.tectonic.ui:checkbox' + default: true types: in: mediaType: application/json @@ -99,7 +113,7 @@ spec: - key: password value: '{{password}}' - key: url - value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};trustServerCertificate=true;' + value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};encrypt={{encrypt}};trustServerCertificate={{trustServerCertificate}};' - key: driverClassName value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver' from:
