how to get inserted OID once insert a record into MySQL

[linjylo]

Good day everyone

I need to retrieve inserted OID for record inserted

public int createRecord(Record record) throws SQLException
{
      String sql="insert into Record(name) values(?)";
      PreparedStatement pstmt = con.prepareStatement(sql,
      ResultSet.TYPE_SCROLL_INSENSITIVE,
      ResultSet.CONCUR_UPDATABLE);

      pstmt.setString(1, record.getName());
      int row=pstmt.executeUpdate();
      pstmt.close();

      int OID=-1;//how to get inserted OID?
      return (OID);
}

anyone who know please advise me, thanks in advance

[Belisarius]

pstmt.getGeneratedKeys() might work, I don't know as I haven't used it before.

[Mazzman]

A technique that I usally use is to create and use the DB sequece object of that database.

You select the next sequence value from the DataBase using a SQL select statment like "select sequence_name.NEXTVAL from DUEL", Then use that number when you insert a new row.

Very reliable technique.