How to parse a JDBC url to get hostname,port etc?

Question

How can I parse a JDBC URL (oracle or sqlserver) to get the hostname, port, and database name. The formats of the URL are different.

Answer 1

Start with something like this:

 String url = "jdbc:derby://localhost:1527/netld;collation=TERRITORY_BASED:PRIMARY"; String cleanURI = url.substring(5);  URI uri = URI.create(cleanURI); System.out.println(uri.getScheme()); System.out.println(uri.getHost()); System.out.println(uri.getPort()); System.out.println(uri.getPath()); 

Output from the above:

 derby localhost 1527 /netld;collation=TERRITORY_BASED:PRIMARY 

Answer 2

That didn't work for me. I came up with these methods, based on the assumption that hostname and port are always joined together by a colon. That assumption holds for all the databases I have to deal with at work (Oracle, Vertica, MySQL, etc). But it probably don't work for something that doesn't reach out to a network port.

String url = null; // set elsewhere in the class final public String regexForHostAndPort = "[.\\w]+:\\d+"; final public Pattern hostAndPortPattern = Pattern.compile(regexForHostAndPort); public String getHostFromUrl() {     Matcher matcher = hostAndPortPattern.matcher(url);      matcher.find();     int start = matcher.start();     int end = matcher.end();     if(start >= 0 && end >= 0) {         String hostAndPort = url.substring(start, end);         String [] array = hostAndPort.split(":");         if(array.length >= 2)             return array[0];     }     throw new IllegalArgumentException("couldn't find pattern '" + regexForHostAndPort + "' in '" + url + "'"); }  public int getPortFromUrl() {     Matcher matcher = hostAndPortPattern.matcher(url);      matcher.find();     int start = matcher.start();     int end = matcher.end();     if(start >= 0 && end >= 0) {         String hostAndPort = url.substring(start, end);         String [] array = hostAndPort.split(":");         if(array.length >= 2)             return Integer.parseInt(array[1]);     }     throw new IllegalArgumentException("couldn't find pattern '" + regexForHostAndPort + "' in '" + url + "'"); }