| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | "Votilla, Mike # Pittsburgh" <Mike(dot)Votilla(at)per-se(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Message / Error Handler |
| Date: | 2007-01-16 21:16:25 |
| Message-ID: | Pine.BSO.4.64.0701161614150.27765@leary2.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Tue, 16 Jan 2007, Votilla, Mike # Pittsburgh wrote:
> Is there a way to register a message / error handler within my java code
> that will capture any messages issued by a RAISE (debug, log, info etc)
> command from within a PL/pgSQL user defined function?
>
There is no specific callback provided, but RAISE output is available via
Statement.getWarnings(). You also need to ensure that
the level you RAISE at is at least that of client_min_messages to ensure
that the server actually sends it to the JDBC driver.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2007-01-17 16:58:37 | Strange error using postgres 8.2 + JDBC 8.2 driver |
| Previous Message | Votilla, Mike # Pittsburgh | 2007-01-16 21:00:46 | Message / Error Handler |