From: | Prasanth <dbadmin(at)pangburngroup(dot)com> |
---|---|
To: | pgsql-jdbc(at)lists(dot)postgresql(dot)org |
Subject: | ResultSet updates are not retained - 42.2.23 |
Date: | 2021-07-08 16:00:30 |
Message-ID: | 83846059-d513-5617-6076-af9110f55485@pangburngroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
With the latest release 42.2.23 ResultSet updates are not propagated to the database. Below is a sample code to verify the issue. In the below code we are querying the record using the primary key in
that table.
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class RowSet {
public void test () throws SQLException, ClassNotFoundException {
Class.forName("org.postgresql.Driver");
Connection connection = DriverManager.getConnection("jdbc:postgresql://192.168.0.100:5432/testdb", "postgres", "xxxxxxxxxxxxxxxx");
connection.setAutoCommit(false);
String sql = "SELECT * FROM plan_data where plan_id = 30756";
ResultSet rs = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE ).executeQuery(sql);
rs.next();
System.out.println("Starting Value: " + rs.getDate("accounting_current_start"));
rs.updateDate("accounting_current_start", Date.valueOf("2020-01-01"));
rs.updateRow();
System.out.println("After Update: " + rs.getDate("accounting_current_start"));
connection.commit();
sql = "SELECT * FROM plan_data where plan_id = 30756";
rs = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE ).executeQuery(sql);
rs.next();
System.out.println("After Requery: " + rs.getDate("accounting_current_start"));
connection.close();
}
public static void main(String args[]) {
try {
new RowSet().test();
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
----------------OUTPUT with 42.2.23 -----------
Starting Value: 2021-01-01
After Update: 2020-01-01
After Requery: 2021-01-01
Update accounting_current_start to 2021-01-01 using a query directly on the database and rerun with 42.2.22
----------------OUTPUT with 42.2.22 -----------
Starting Value: 2021-01-01
After Update: 2020-01-01
After Requery: 2020-01-01
Thanks,
Prasanth
On 7/6/21 10:41 AM, Dave Cramer wrote:
> Branch: refs/tags/REL42.2.23
> Home: https://github.com/pgjdbc/pgjdbc
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2021-07-08 17:08:45 | Re: ResultSet updates are not retained - 42.2.23 |
Previous Message | Dave Cramer | 2021-07-06 15:41:47 | [pgjdbc/pgjdbc] |