Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5.8
-
None
-
RedHat 8/Centos 8
Description
Good afternoon, this question probably has little to do with Connect Engine, rather more to connect via JDBC in General. However, I noticed one nuance that when I try to create a connection to MSSQL via JDBC, through the created server:
CREATE OR REPLACE SERVER 'mssql_server' FOREIGN DATA WRAPPER 'jdbc' OPTIONS ( |
HOST 'jdbc:sqlserver://mssql-server:1433', |
DATABASE 'sample_db', |
USER 'sample_user', |
PASSWORD 'sample_user' |
);
|
 |
CREATE OR REPLACE TABLE sample_database.table_from_mssql ( |
guid CHAR(36)) |
ENGINE=connect TABLE_TYPE=jdbc CONNECTION='mssql_server/sample.dbo.t_table' OPTION_LIST='scrollable=1'; |
Next, when I try to view the contents of the created table, I get an error
Error SQL (1296): Got error 174 'Connecting: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server chose TLSv1' from CONNECT
And this error seems to only apply to MSSQL, because the JDBC driver for Oracle and MariaDB does not have such problems
Maybe someone has experience in solving this problem?
It is worth noting that for some reason there is no such problem in RedHat 7/Centos 7 :/