Lets see the list of commands for the abstract database (JDBC)
rs.moveToInsertRow();
rs.updateString(1, "AINSWORTH");
rs.updateInt(2,35);
rs.updateBoolean(3, true);
rs.insertRow();
Ok, after that I expected that
rs.getRow(); //Retrieves the current row number.
returns new row id for this row, but I got null.
Read documnetation:
After inserting the row the ResultSet still pointing to the insert row. However, you cannot be certain what will happen if you try to access it, once the row has been inserted. Therefore you should move the ResultSet to a valid position after inserting the new row.
Ok, call
rs.moveToCurrentRow();
And question. How to move forward to inserted row and get rowId (jdbc index, not sql)? I tried
rs.previous();
but got exception. rs.last() move to last row (not inserted)
Please, do not propose to calculate and read specal columns (rowid for ORACLE). I don't find the similar question on stackoverflow, but found with the similar title. My environment is java 6 and oracle 11 with odbc14.jar