Postgres JDBC: Especific error code of PSQLException?

Question

When writing java code that uses an Oracle database, one can always catch SQLException an read an specific Oracle error with e.getErrorCode(). For example, error 28001 means expired password, 28000 is blocked account, 1017 is wrong user/passsword, etc.

That way I can manage different errors the appropiate way.

But with PostgreSQL databases e.getErrorCode() always returns 0, even when catching Postgres-specific PSQLException.

The Question

Is there a way that I don't know of to get an specific error code for a Postgres database exception in Java other than trying to parse the error message (which by the way could be in any localized language)?

Have you tried looking at getSqlState() instead? See also: postgresql.org/docs/9.3/static/errcodes-appendix.html — cjstehno
– cjstehno, Commented Feb 9, 2015 at 18:28

cjstehno · Accepted Answer · 2015-02-09 18:32:08Z

2

Have you tried looking at getSqlState() instead? See also: http://www.postgresql.org/docs/9.3/static/errcodes-appendix.html

answered Feb 9, 2015 at 18:32

cjstehno

14.1k5 gold badges47 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tulains Córdova Over a year ago

Every failed connection attempt returns "08001" regardless of the reason (bad password, bad IP, bad port, bad user, bad database name, no network conecction), everything returns "08001".

Collectives™ on Stack Overflow

Postgres JDBC: Especific error code of PSQLException?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related