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:09 UTC
[camel-kamelets] branch sqlserver-sink-source-fix created (now edb6c3b3)
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a change to branch sqlserver-sink-source-fix
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
at edb6c3b3 SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server
This branch includes the following new commits:
new 9b08963d SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
new 33664c2d SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
new 75f4e71f SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
new edb6c3b3 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.
[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 sqlserver-sink-source-fix
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 33664c2ddedd07566c2b9dbebe96f1f81b411885
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:
[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 sqlserver-sink-source-fix
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 75f4e71fceb6866cae1e4a0c9d96c858b042136c
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] 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 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:
[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 sqlserver-sink-source-fix
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit edb6c3b39ec636d4769950dd5dde5a1d9490e035
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: