Sehrope Sarkuni schrieb am 04.10.2021 um 14:49:
> On Sun, Oct 3, 2021 at 8:08 AM Thomas Kellerer <shammat@gmx.net <mailto:shammat@gmx.net>> wrote:
>
> Postgres 14 supports SQL standard conforming bodies for functions and procedures
> which are no longer string constants, e.g.
>
> create or replace procedure do_stuff()
> language sql
> begin atomic
> select 1;
> select 2;
> end
>
> However, it seems that the JDBC driver will parse the string and split it into
> multiple statements based on the semicolons thus making it an invalid create procedure
> statement.
>
>
> If you set the connection property "preferQueryMode" to "simple" or
> "extendedForPrepared", then the driver will not attempt to split the
> statement into multiple commands.
Thanks, that works fine.
Changing the connection URL is a good enough solution for me.
Thomas