Re: Exception while updating result set
От | Prasanth |
---|---|
Тема | Re: Exception while updating result set |
Дата | |
Msg-id | d9bd732f-da47-213f-468b-9a1f13dca8b5@pangburngroup.com обсуждение исходный текст |
Ответ на | Re: Exception while updating result set (Dave Cramer <davecramer@postgres.rocks>) |
Список | pgsql-jdbc |
Thanks,
Prasanth
On Fri, Jun 25, 2021, 3:43 PM Prasanth <dbadmin@pangburngroup.com> wrote:Sorry did not get the below email, just saw it in the website. Below is the sql.
"SELECT * FROM accounting_periods where plan_id = 30756 order by start_date";
Thanks,
PrasanthOn Thu, 25 Mar 2021 at 12:00, Prasanth <dbadmin(at)pangburngroup(dot)com> wrote:
> Hi,
>
> Does anyone have any thoughts on this?
>
> Thanks,
> Prasanth
>
> On 3/18/21 5:20 PM, Prasanth wrote:
>
> Hi,
>
> The following code generates an exception shown below. Commenting out the
> refreshRow() call would solve the issue. This exception happens only in
> driver versions 42.2.13 and above. Is this a bug in the driver?
>
> ResultSet rs =
> connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.CONCUR_UPDATABLE ).executeQuery(sql);
> rs.next();
> rs.updateDate("start_date", Date.valueOf("2020-01-01"));
> rs.updateDate("end_date", Date.valueOf("2020-12-31"));
> rs.updateRow();
> rs.refreshRow();
> rs.updateDate("end_date", Date.valueOf("2020-12-30"));
> rs.updateRow(); // Exception occurs at this line.
>
>
> Exception in thread "main" java.lang.IllegalArgumentException: Attempted
> to write to readonly tuple
> at org.postgresql.core.Tuple.set(Tuple.java:96)
> at
> org.postgresql.jdbc.PgResultSet.setRowBufferColumn(PgResultSet.java:1680)
> at
> org.postgresql.jdbc.PgResultSet.updateRowBuffer(PgResultSet.java:1733)
> at org.postgresql.jdbc.PgResultSet.updateRow(PgResultSet.java:1378)
>
> Thanks,
> Prasanth
>
> What is the query ?
From: Dave Cramer <davecramer(at)postgres(dot)rocks> To: dbadmin(at)pangburngroup(dot)com Cc: pgsql-jdbc(at)lists(dot)postgresql(dot)org Subject: Re: Exception while updating result set Date: 2021-03-29 14:19:13 Message-ID: CADK3HHK8WPCxbhoE4dTt=U0jpmtGWMT0okXY5oj5SAE1b7T26Q@mail.gmail.com Views: Raw Message | Whole Thread | Download mbox | Resend email Lists: pgsql-jdbc On 3/25/21 11:00 AM, Prasanth wrote:Hi,
Does anyone have any thoughts on this?
Thanks,
PrasanthOn 3/18/21 5:20 PM, Prasanth wrote:Hi,
The following code generates an exception shown below. Commenting out the refreshRow() call would solve the issue. This exception happens only in driver versions 42.2.13 and above. Is this a bug in the driver?
ResultSet rs = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE ).executeQuery(sql);
rs.next();
rs.updateDate("start_date", Date.valueOf("2020-01-01"));
rs.updateDate("end_date", Date.valueOf("2020-12-31"));
rs.updateRow();
rs.refreshRow();
rs.updateDate("end_date", Date.valueOf("2020-12-30"));
rs.updateRow(); // Exception occurs at this line.
Exception in thread "main" java.lang.IllegalArgumentException: Attempted to write to readonly tuple
at org.postgresql.core.Tuple.set(Tuple.java:96)
at org.postgresql.jdbc.PgResultSet.setRowBufferColumn(PgResultSet.java:1680)
at org.postgresql.jdbc.PgResultSet.updateRowBuffer(PgResultSet.java:1733)
at org.postgresql.jdbc.PgResultSet.updateRow(PgResultSet.java:1378)
Thanks,
Prasanth
В списке pgsql-jdbc по дате отправления:
Следующее
От: Sehrope SarkuniДата:
Сообщение: [pgjdbc/pgjdbc] 5f9798: test: Remove PG 14 procedure error special handling