| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Errors using JDBC batchUpdate with plpgsql function |
| Date: | 2015-05-04 11:11:47 |
| Message-ID: | CADK3HHLeAnkZN_3GYATdXfa0UycuqKhD+pQCRjYSbK8tRs7_xg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The logs from the server would be useful
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 07:05, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> 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.
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2015-05-04 14:08:26 | Re: Setting up a database for 10000 concurrent users |
| Previous Message | Thomas Kellerer | 2015-05-04 11:05:56 | Re: Errors using JDBC batchUpdate with plpgsql function |