What would be the preffered way of catching postgres exceptions within
Java code?
For instance, I have an application where user types in database name
he/she wishes to connect to. So, when user enters the database name, I
try to connect to it. If that database does not exists, I'm thrown an
exception, something like this:
org.postgresql.util.PSQLException: Backend start-up failed:
org.postgresql.util.PSQLException: FATAL: database "testdb" does not
exist
Now, if the database server is unavailable, I get something like this:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
I would like to know, in my code, what happened, and inform user
apropriatley, I don't want just to print the exception to the user.
I could parse the return from printStackTrace method, but that just
doesn't seem right.
Also, some of the functions need to return errorcode of some sort. If
the function is returning SETOF, I can't use OUT parametars. So, I'm
asking for a recomendation here.
I'm using postgres 8.1 with latest JDBC driver.
Thank you in advance,
Mario
--
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
