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:36:10 UTC
[camel-kamelets] 01/04: 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-fix
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 9b08963db9296adad59c129054fe6e1a83922b5c
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Wed Oct 26 11:48:52 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>
---
kamelets/sqlserver-source.kamelet.yaml | 2 +-
.../src/main/resources/kamelets/sqlserver-source.kamelet.yaml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/kamelets/sqlserver-source.kamelet.yaml b/kamelets/sqlserver-source.kamelet.yaml
index c7871323..2afe4d91 100644
--- a/kamelets/sqlserver-source.kamelet.yaml
+++ b/kamelets/sqlserver-source.kamelet.yaml
@@ -99,7 +99,7 @@ spec:
- key: password
value: '{{password}}'
- key: url
- value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}}'
+ value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};encrypt=true;trustServerCertificate=true;'
- key: driverClassName
value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
from:
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 c7871323..2afe4d91 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
@@ -99,7 +99,7 @@ spec:
- key: password
value: '{{password}}'
- key: url
- value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}}'
+ value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};encrypt=true;trustServerCertificate=true;'
- key: driverClassName
value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
from: