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:37:09 UTC

[camel-kamelets] branch 0.9.x updated (ba5f5f37 -> 054f83b1)

This is an automated email from the ASF dual-hosted git repository.

acosentino pushed a change to branch 0.9.x
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git


    from ba5f5f37 [maven-release-plugin] prepare for next development iteration
     new 16986b3c SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
     new 2e997660 SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
     new 068cf424 SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
     new 054f83b1 SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server

The 4 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.


Summary of changes:
 kamelets/sqlserver-sink.kamelet.yaml                     | 16 +++++++++++++++-
 kamelets/sqlserver-source.kamelet.yaml                   | 16 +++++++++++++++-
 .../resources/kamelets/sqlserver-source.kamelet.yaml     | 16 +++++++++++++++-
 3 files changed, 45 insertions(+), 3 deletions(-)


[camel-kamelets] 01/04: SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server

Posted by ac...@apache.org.
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 16986b3ce9295e19c5c8c41d246aa988ac8d74dc
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:


[camel-kamelets] 04/04: SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server

Posted by ac...@apache.org.
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 054f83b1f759dfaca7b397af0efcf615389f4d5d
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Wed Oct 26 12:07:49 2022 +0200

    SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server
    
    Signed-off-by: Andrea Cosentino <an...@gmail.com>
---
 kamelets/sqlserver-sink.kamelet.yaml | 16 +++++++++++++++-
 1 file changed, 15 insertions(+), 1 deletion(-)

diff --git a/kamelets/sqlserver-sink.kamelet.yaml b/kamelets/sqlserver-sink.kamelet.yaml
index f7bb2201..eea18e9f 100644
--- a/kamelets/sqlserver-sink.kamelet.yaml
+++ b/kamelets/sqlserver-sink.kamelet.yaml
@@ -84,6 +84,20 @@ spec:
         title: Database Name
         description: The name of the SQL Server Database.
         type: string
+      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
@@ -102,7 +116,7 @@ spec:
           - key: password
             value: '{{password}}'
           - key: url
-            value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}}'
+            value: 'jdbc:sqlserver://{{serverName}}:{{serverPort}};databaseName={{databaseName}};encrypt={{encrypt}};trustServerCertificate={{trustServerCertificate}};'
           - key: driverClassName
             value: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
     from:


[camel-kamelets] 03/04: SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server

Posted by ac...@apache.org.
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 <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 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:


[camel-kamelets] 02/04: SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server

Posted by ac...@apache.org.
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 <an...@gmail.com>
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 <an...@gmail.com>
---
 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: