如何解决sqlserver连接时提示：动程序无法使用安全套接字层(SSL)加密

1. 参考文章 https://blog.csdn.net/T_susan/article/details/134655599配置

2. 如果第一步不行的话，则可尝试更换驱动为jtds-1.3.1.jar（自行下载）

   2.1 修改连接信息

   

   2.2 修改模板信息

   修改查询字段模板（如下图）：

   

SELECT
    schema_name = sch.name,
    tbl_def_key =    tab.name,
    order_value =    col.column_id,
    def_key =        col.name,
    def_name =       ep.value,
    intro =          '',
    db_data_type =   t.name,
    data_len =       NULLIF(col.max_length, 0),
    num_scale =       NULLIF(col.scale, 0),
    primary_key = ISNULL((
                             SELECT
                                 1
                             FROM
                                 information_schema.table_constraints AS tc,
                                 information_schema.key_column_usage AS kcu
                             WHERE tc.constraint_name = kcu.constraint_name
                               AND tc.constraint_type = 'PRIMARY KEY'
                               AND tc.table_name = tab.name
                               AND tc.CONSTRAINT_SCHEMA = sch.name
                               AND kcu.column_name= col.name
                         ),0),
    not_null=         CASE WHEN col.is_nullable = 1 THEN 0 ELSE 1 END,
    auto_increment = is_identity,
    default_value =  ISNULL(REPLACE(REPLACE(dc.definition,'(',''), ')',''),'')      --  ISNULL(dc.definition, '')
FROM
    sys.schemas sch
        INNER JOIN sys.tables tab
                   ON sch.schema_id = tab.schema_id
        INNER JOIN sys.columns col
                   ON tab.object_id = col.object_id
        LEFT JOIN sys.extended_properties ep
                  ON tab.object_id = ep.major_id
                      AND col.column_id = ep.minor_id
                      AND ep.name = 'MS_Description'
                      AND ep.class = 1
        LEFT JOIN sys.types t ON col.system_type_id = t.system_type_id  AND col.user_type_id = t.user_type_id
        LEFT JOIN sys.default_constraints dc ON dc.object_id = col.default_object_id
where sch.name IN (:schemaName)  AND sch.name + '.' + tab.name IN  (:sysTableNames)
ORDER BY sch.name,tbl_def_key, order_value

修改索引查询模板（如下图）

SELECT
 sch.name                                     AS schema_name,
 tab.name                                     AS TBL_DEF_KEY,
 col.name                                     AS COL_DEF_KEY,
 i.name                                       AS DEF_KEY,
 ep.value                                     AS def_name,
 CASE 
     WHEN i.is_unique = 1 THEN 'UNIQUE'
     ELSE 'NORMAL'
 END AS TYPE,
 CASE 
     WHEN ic.is_descending_key = 1 THEN 'DESC'
     ELSE 'ASC'
 END AS SORT_TYPE,
 ic.key_ordinal                               AS ORDER_VALUE,
 ''                                           AS INTRO
FROM
 sys.schemas sch LEFT JOIN sys.tables tab
     ON sch.schema_id = tab.schema_id
 LEFT JOIN sys.indexes i
     ON i.object_id = tab.object_id
 LEFT JOIN sys.index_columns ic
     ON i.object_id = ic.object_id AND i.index_id = ic.index_id
 LEFT JOIN sys.columns col
     ON ic.object_id = col.object_id AND ic.column_id = col.column_id
 LEFT JOIN sys.extended_properties ep
     ON tab.object_id = ep.major_id
            AND i.index_id = ep.minor_id
            AND ep.name = 'MS_Description'
            AND ep.class = 7
WHERE sch.name in (:schemaName) AND sch.name + '.' + tab.name IN (:sysTableNames) AND is_primary_key = 0 AND i.type IN (1, 2)
ORDER BY sch.name,TBL_DEF_KEY, ORDER_VALUE