From: Michael Paquier [mailto:michael.paqu...@gmail.com] > Does JDBC use something like that to make a difference between a failure > and a move-on-to-next-one?
No, it just tries the next host. See the first while loop in org/postgresql/jdbc/core/v3/ConnectionFactoryImpl.java. > From maintenance point of view, this would > require lookups each time a new SQLSTATE is added. Not sure that people > would remember that. Yes, I have the same concern, but I'll see if there's a good way anyway (e.g. whether we can simply use the class code of the SQLSTATE, which seems hopeless.) I guess PgJDBC's way is practical and sensible in the end. Regards Takayuki Tsunakawa -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers