rendered paste bodyimport java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DerbyTestCase { private static String URL = "jdbc:derby:data/TestDB"; private static String driveName = "org.apache.derby.jdbc.EmbeddedDriver"; { try { Class.forName(driveName); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public static void main(String [] args) { try { Connection c = DriverManager.getConnection(URL); Statement s = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE, ResultSet.HOLD_CURSORS_OVER_COMMIT); String sql; //ReCreate Schema try { //sql = "DROP TABLE MY_DUMMY_TABLE"; //s.execute(sql); //sql = "CREATE TABLE MY_DUMMY_TABLE (ID INT GENERATED BY DEFAULT AS IDENTITY, NAME VARCHAR(30) DEFAULT '' NOT NULL)"; //s.execute(sql); } catch (Exception e) { e.printStackTrace(); } sql = "SELECT * FROM MY_DUMMY_TABLE"; ResultSet rs = s.executeQuery(sql); //Critical Junction rs.moveToInsertRow(); rs.updateString("NAME", "John"); rs.insertRow(); System.out.println(rs.getInt("id")); System.out.println(rs.getString("NAME")); rs.moveToCurrentRow(); rs.moveToInsertRow(); rs.updateString("NAME", "Ralphs"); rs.insertRow(); System.out.println(rs.getInt("id")); System.out.println(rs.getString("NAME")); rs.refreshRow(); rs.close(); s.close(); c.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }}