Search Postgresql Archives

Re: JDBC connectivity issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I believe its Postgresql-9.4.1208.jre7.jar
On 03/13/2018 05:48 PM, Adrian Klaver wrote:
On 03/13/2018 04:46 PM, chris wrote:
I'm sorry that took a few days but I am running;


Postgresql-9.4

and

jre7.jar

What we are looking for is the JDBC driver you are using?


Thanks in advance.


On 03/08/2018 02:30 PM, chris wrote:
Given that the syntax looks correct for the url, how would we go about debugging that it's not seeing the comma?


On 03/08/2018 02:27 PM, Adrian Klaver wrote:
On 03/08/2018 01:12 PM, chris wrote:
Hi,

I have a JDBC temping to connect to 2 postgres nodes in a hot standby configuration. Running postgres 9.4 on centos6.

What we are trying to accomplish is in an event of a failover, to first try to connect to the master. If that fails to then reach out to the standby.

I looked online and found the suggested way to do this, but it's not working.

This is the JDBC line we have:

/jdbc.url=jdbc:postgresql://10.16.10.12:5432,10.16.10.13:5432/app_db/

Here is the error we are getting:/
/

/2018-03-07 13:54:36, 994 ERROR:com.zaxxer.hikari.util.PropertyElf - failed to set properly port number on target class org.postgresql.ds.PGSimpleDataSource java.langNumberFormatException:for input string: "5432,10.16.10.13:5432"/

Lets try that again:

To me it looks like whatever code you are using is trying to use "5432,10.16.10.13:5432" as the port number for 10.16.10.12. In other words it is not seeing the ',' as a separator for the two IP's'.

Time to clean the glasses:)


It looks like the first IP address has disappeared or is not set right./
/

Thanks in advance for the help.


//














[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux