I have some JDBC code that creates a connection and then calls executeUpdate to insert a new record. Now the table has some triggers for the insert statement that seems to complete the record by adding a status and then a status message. How can I get these new values from the table? The current code looks like this:
Connection conn = getConnection();
PreparedStatement pstmt = conn.prepareStatement(SUBMIT_SQL);
int retCode = pstmt.executeUpdate();
System.out.println("executeUpdate retCode: " + retCode);
if (retCode != 1)
I have a SQL statement called "GETSUBMITTED_SQL" that keys on the uniqueKey to get the record but I would rather not make another call... is there a more efficient way to get the data from the record? The fields I want to get are "status" and "statusMsg" (INT and VARCHAR). The database is Oracle.