When will Oracle's JDBC driver support auto generated keys?
Method: java.sql.Statement.getGeneratedKeys()
Oracle's JDBC FAQ says that auto-generated keys are not supported. (Link: http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm )
The JDBC 3.0 specification states:
{{
Section 13.6
Retrieving Auto Generated Keys
"Many database systems have a mechanism that automatically generates a unique key field when a row is inserted. The method Statement.getGeneratedKeys,
which can be called to retrieve the value of such a key, returns a ResultSet object with a column for each automatically generated key. A flag indicating that any auto generated columns should be returned is passed to the methods execute, executeUpdate or prepareStatement when the statement is executed or prepared. [...]"
}}
-
Oracle JDBC, auto generated keys (0 messages)
- Posted by: Sean Sullivan
- Posted on: December 19 2004 18:26 EST