in src/main/java/com/datacompare/model/DatabaseInfo.java [132:168]
public String getURL() {
String url = "";
switch (type) {
case POSTGRESQL:
url = "jdbc:postgresql://" + hostName + ":" + port + "/" + database + "?tcpKeepAlive=true";
break;
case POSTGRESQL_SSL:
url = "jdbc:postgresql://" + hostName + ":" + port + "/" + database + "?sslmode=require&tcpKeepAlive=true";
break;
case ORACLE:
if (sslRequire)
url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=" + hostName + ")(PORT=" + port + "))(CONNECT_DATA=(SERVICE_NAME=" + database + ")))";
else
url = "jdbc:oracle:thin:@" + hostName + ":" + port + ":" + database;
break;
case ORACLE_SID:
if (sslRequire)
url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=" + hostName + ")(PORT=" + port + "))(CONNECT_DATA=(SERVICE_NAME=" + database + ")))";
else
url = "jdbc:oracle:thin:@" + hostName + ":" + port + ":" + database;
break;
case ORACLE_Service:
if (sslRequire)
url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=" + hostName + ")(PORT=" + port + "))(CONNECT_DATA=(SERVICE_NAME=" + database + ")))";
else
url = "jdbc:oracle:thin:@" + hostName + ":" + port + "/" + database;
break;
case SQLSERVER:
url = "jdbc:sqlserver://" + hostName + ":" + port + ";databaseName=" + database;
break;
}
return url;
}