supersonic icon indicating copy to clipboard operation
supersonic copied to clipboard

DatabaseReq 建议是使用jdbc url 替代host 和 port

Open witkeyshare opened this issue 1 year ago • 1 comments

当前jdbc url 目前是拼接的,实际上需要增加额外的链接参数是实现特定的目的,拼接的无法满足需求。

比如我的 mysql链接需要配置 &useSSL=false,我就要改代码

public String getUrl() {
    if (type.equalsIgnoreCase(DataTypeEnum.H2.getFeature())) {
        return url;
    }
    String databaseUrl = database;
    if (StringUtils.isBlank(databaseUrl)) {
        databaseUrl = "";
    } else {
        databaseUrl = "/" + database;
    }
    if (type.equalsIgnoreCase(DataTypeEnum.MYSQL.getFeature())) {
       return String.format("jdbc:%s://%s:%s%s?sessionVariables=sql_mode='IGNORE_SPACE'&allowMultiQueries=true&%s",
                type, host, port, databaseUrl, "useSSL=false");
    }
    return String.format("jdbc:%s://%s:%s%s", type, host, port, databaseUrl);
}

witkeyshare avatar Dec 02 '23 08:12 witkeyshare