public String getURL()

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;
	}