Обсуждение: How to get RAISE INFO in JDBC

Поиск
Список
Период
Сортировка

How to get RAISE INFO in JDBC

От
Ravi Krishna
Дата:
How do we get the notification mentioned in RAISE INFO of PL/PGSQL in JDBC.
I can get it in psql, but not in JDBC.

I am talking about redshift which has the same procedural language like postgres.

thanks

Re: How to get RAISE INFO in JDBC

От
Thomas Kellerer
Дата:
Ravi Krishna schrieb am 20.03.2020 um 15:48:
> How do we get the notification mentioned in RAISE INFO of PL/PGSQL in JDBC.
> I can get it in psql, but not in JDBC.
>
> I am talking about redshift which has the same procedural language like postgres.

I can only answer this for Postgres.
As Redhisft has its own JDBC driver, I don't know if this applies to that as well:

All messages from a RAISE are reported as SQL Warnings on the Statement instance that you used.

So you can use Statement.getWarnings() to retrieve the RAISE output.
Note, that you need a loop that checks SQLWarning.getNextWarning() to find out if there was more than one RAISE

Thomas