"java.sql.SQLException: ResultSet is not updatable" with JdbcRowSet

Asked May 11 '19 at 13:39

Active May 11 '19 at 19:00

Viewed 369 times

I want to use RowSet Interface implement update,But I meet some error.

I’ve tried on following code:

// Load the JDBC driver
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("Driver loaded");

RowSetFactory rsFactory = RowSetProvider.newFactory();
JdbcRowSet rowSet = rsFactory.createJdbcRowSet();

rowSet.setUrl(DATABASE_URL);
rowSet.setUsername(USERNAME);
rowSet.setPassword(PASSWORD);

// make rowset updateable
rowSet.setReadOnly(false); 
rowSet.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
rowSet.setConcurrency(ResultSet.CONCUR_UPDATABLE);

rowSet.setCommand("Select * from money");
rowSet.execute();

rowSet.absolute(3);
rowSet.updateInt("balance", parseIntBalance); //update third rows balance label to 5000
rowSet.updateRow();

Following is error message:

java.sql.SQLException: ResultSet is not updatable
    at com.sun.rowset.JdbcRowSetImpl.checkTypeConcurrency(JdbcRowSetImpl.java:4139)
    at com.sun.rowset.JdbcRowSetImpl.updateInt(JdbcRowSetImpl.java:2306)
    at com.sun.rowset.JdbcRowSetImpl.updateInt(JdbcRowSetImpl.java:2735)

edited May 11 '19 at 19:00

Gord Thompson

116,920
32
215
418

asked May 11 '19 at 13:39

Creek

1

Have you tried doing it directly on a result set instead of a `RowSet`? – Mark Rotteveel May 11 '19 at 14:37
1

I was able to reproduce your issue using MySQL Connector/J version 8.0.16. The issue does not occur with MySQL Connector/J version 5.1.47. – Gord Thompson May 11 '19 at 18:58
@MarkRotteveel No, because the job request is to use rowset – Creek May 12 '19 at 02:39
@GordThompson thank you,But why can't MySQL Connector/J version 8.0.16 be executed? – Creek May 12 '19 at 04:23
It looks like a bug was introduced when the version 5.x code was tweaked for version 8.x. – Gord Thompson May 12 '19 at 15:23
@Gord Thompson thank you very much! – Creek May 13 '19 at 05:33

"java.sql.SQLException: ResultSet is not updatable" with JdbcRowSet

0 Answers0

Linked