Catching postgres exceptions - functions returning error values?
От | Mario Splivalo |
---|---|
Тема | Catching postgres exceptions - functions returning error values? |
Дата | |
Msg-id | 1156948727.29660.24.camel@localhost.localdomain обсуждение исходный текст |
Список | 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.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."
В списке pgsql-jdbc по дате отправления: