Re: Message / Error Handler - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Message / Error Handler
Date
Msg-id Pine.BSO.4.64.0701161614150.27765@leary2.csoft.net
Whole thread Raw
In response to Message / Error Handler  ("Votilla, Mike # Pittsburgh" <Mike.Votilla@per-se.com>)
List 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

pgsql-jdbc by date:

Previous
From: "Votilla, Mike # Pittsburgh"
Date:
Subject: Message / Error Handler
Next
From: Csaba Nagy
Date:
Subject: Strange error using postgres 8.2 + JDBC 8.2 driver