I am surprised this was not answered correct yet.
I am in the same bucket as you and here is the problem. A quick look at the
code and you find the answer.
The BaseDataSource class (from which PGSimpleDataSource inherits) does NOT
support failover addresses. The underlying driver used to parse th
I forgot to say I am trying to investigate how to make it work as we need
specific stuff from the DataSource object.
It might work if you use setServerName rather than setUrl. setServerName
will append itself the jdbc:postgresql:// so you only give it the server
name (i.e "url1:port1,url2:port2")