Re: Errors using JDBC batchUpdate with plpgsql function - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Errors using JDBC batchUpdate with plpgsql function
Date
Msg-id mi7jqk$i9$1@ger.gmane.org
Whole thread Raw
In response to Re: Errors using JDBC batchUpdate with plpgsql function  (Hannes Erven <hannes@erven.at>)
Responses Re: Errors using JDBC batchUpdate with plpgsql function  (Dave Cramer <pg@fastcrypt.com>)
Re: Errors using JDBC batchUpdate with plpgsql function  (Nanker Phelge <n.phelge01@gmail.com>)
List pgsql-general
Hannes Erven schrieb am 04.05.2015 um 12:31:
> Hi,
>
>
>>          String sql = "select test_user_result_insert_func(?, ?, ?);";
>
> You can't call functions via JDBC like that.

That's perfectly valid - unless the function uses out parameters or ref cursors.

I am however unsure about batched statements here. So trying CallableStatement is definitely worth a shot.


pgsql-general by date:

Previous
From: Hannes Erven
Date:
Subject: Re: Errors using JDBC batchUpdate with plpgsql function
Next
From: Dave Cramer
Date:
Subject: Re: Errors using JDBC batchUpdate with plpgsql function