Re: Fail-over PG server in connection string - syntax ?

hi Michal,


 >What is the correct syntax for building connection string? Should the fail-over within postgres-jdbc driver work?

The correct syntax is as the following
jdbc:postgresql://host1:port1,host2:port2/test


 >                  String connectionString = "jdbc:postgresql://pgsqldc1:5432/test,pgsqldc2:5432/test";

In the above sample,the correct connection string should looks like that

String connectionString = "jdbc:postgresql://pgsqldc1:5432,pgsqldc2:5432/test";


Best regards,
Chen Huajun