Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Retrieving auto-assigned index from inserted record  RSS feed

Ron Olson
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A common database feature is the automatic assignment of a unique index for a newly inserted record (e.g. AutoNumber in MS Access). But, immediately following the insertion, how through JDBC can I retrieve that index?
What might work is to insert via ResultSet.insertRow(), and then read back the index field from that row while that ResultSet is still alive. Unfortunately, my experiments on this have been hampered because of limitations of the JDBC-ODBC bridge driver, which is a separate issue. Anyway, that technique works in other environments, like MS ADO. Does it work here? Are there other techniques that work?
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!