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 2e997660dd5e3db8af01230d5f8d3823e86947e2
Author: Andrea Cosentino <[email protected]>
AuthorDate: Wed Oct 26 12:01:55 2022 +0200

    SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL 
Server
    
    Signed-off-by: Andrea Cosentino <[email protected]>
---
 kamelets/sqlserver-source.kamelet.yaml                   | 16 +++++++++++++++-
 .../resources/kamelets/sqlserver-source.kamelet.yaml     |  2 +-
 2 files changed, 16 insertions(+), 2 deletions(-)

diff --git a/kamelets/sqlserver-source.kamelet.yaml 
b/kamelets/sqlserver-source.kamelet.yaml
index 2afe4d91..0976468a 100644
--- a/kamelets/sqlserver-source.kamelet.yaml
+++ b/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}};encrypt=true;trustServerCertificate=true;'
+            value: 
'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};encrypt={{encrypt}};trustServerCertificate={{trustServerCertificate}};'
           - 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 2afe4d91..13ce487f 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}};encrypt=true;trustServerCertificate=true;'
+            value: 
'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};trustServerCertificate=true;'
           - key: driverClassName
             value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
     from:

Reply via email to