From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to get RAISE INFO in JDBC |
Date: | 2020-03-20 16:12:16 |
Message-ID: | 1c83d660-79ce-efb3-3dd5-fa968d98f9f6@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Hughes | 2020-03-20 16:30:15 | Re: Passwordcheck configuration |
Previous Message | Adrian Klaver | 2020-03-20 15:00:15 | Re: Duplicate key violation on upsert |