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:10 UTC
[camel-kamelets] branch sqlserver-sink-source created (now 522b638f)
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a change to branch sqlserver-sink-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
at 522b638f SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server
This branch includes the following new commits:
new 57dff868 SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
new 028a2f6c SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
new 53c224a7 SQL Server Source: with 11.2.0.jre11 there are troubles connecting to SQL Server
new 0ae4b28d SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server
new 522b638f SQL Server Sink: with 11.2.0.jre11 there are troubles connecting to SQL Server
The 5 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] 04/05: 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
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 0ae4b28dbbe73fa8bcdfa5dada591201bd6c19fe
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 31706051..355c128f 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] 01/05: 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
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 57dff868da734e104e998389099e2e2630a07631
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 b6902242..8f7c50dc 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 b6902242..8f7c50dc 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] 03/05: 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
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:
[camel-kamelets] 05/05: 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
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 522b638f6eafcb60bc31342f0f713408a59fb62a
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Wed Oct 26 12:21: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>
---
.../main/resources/kamelets/sqlserver-sink.kamelet.yaml | 16 +++++++++++++++-
1 file changed, 15 insertions(+), 1 deletion(-)
diff --git a/library/camel-kamelets/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml b/library/camel-kamelets/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
index 31706051..355c128f 100644
--- a/library/camel-kamelets/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
+++ b/library/camel-kamelets/src/main/resources/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] 02/05: 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
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 028a2f6c2e89e25db00a31f5b6f374dc08319a53
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 8f7c50dc..74af161b 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 8f7c50dc..bfe63471 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: