Re: Errors using JDBC batchUpdate with plpgsql function

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Errors using JDBC batchUpdate with plpgsql function
Date: 2015-05-04 11:05:56
Message-ID: mi7jqk$i9$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2015-05-04 11:11:47 Re: Errors using JDBC batchUpdate with plpgsql function
Previous Message Hannes Erven 2015-05-04 10:31:10 Re: Errors using JDBC batchUpdate with plpgsql function