You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by ac...@apache.org on 2022/10/26 10:22:13 UTC
[camel-kamelets] 03/05: SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch sqlserver-sink-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 53c224a784fce3ebc2e531d465fede7f229a9e69
Author: Andrea Cosentino <an...@gmail.com>
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 <an...@gmail.com>
---
.../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 bfe63471..74af161b 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: