Catching postgres exceptions - functions returning error values?

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Catching postgres exceptions - functions returning error values?
Date: 2006-08-30 14:38:47
Message-ID: 1156948727.29660.24.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(dot)splivalo(at)mobart(dot)hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message meil parachorras 2006-08-30 15:53:05 Encoding Problem
Previous Message Tom Lane 2006-08-30 13:05:42 Re: Could not determine data type of parameter $1