Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
Sprint connector/j 2.1.0
Description
ResultSet.update* methods aren't implemented
statement using ResultSet.CONCUR_UPDATABLE must be able to update record.
exemple:
Statement stmt = con.createStatement(
|
ResultSet.TYPE_SCROLL_INSENSITIVE,
|
ResultSet.CONCUR_UPDATABLE);
|
ResultSet rs = stmt.executeQuery("SELECT age FROM TABLE2"); |
// rs will be scrollable, will not show changes made by others, |
// and will be updatable |
while(rs.next()){ |
//Retrieve by column name |
int newAge = rs.getInt(1) + 5; |
rs.updateDouble( 1 , newAge ); |
rs.updateRow();
|
}
|
|