|Subject||Re: Indexed Views|
> Virtually all of my application level programming is in Java, forUnfortunately(?) there is a standard API in JDBC 3.0 for this case,
> example, and JDBC has no way to support the construct above. [OK, I
> suppose you could argue that it doesn't have a way to access a
> sequence, either, which would rather put me on the spot].
that's why I wrote that it would be nice addition for JayBird:
public ResultSet getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing
this Statement object. If this Statement object did not generate any
keys, an empty ResultSet object is returned.
a ResultSet object containing the auto-generated key(s)
generated by the execution of this Statement object
SQLException - if a database access error occurs
It has been introduced in JDBC 3.0 (i.e. in JDK 1.4.x), but many
drivers support this construct.
> [The above is predicated on the probably unwarranted assumption thatSQL99 and working draft of SQL2003 do not contain proposal, however
> the SQL committee didn't slip it into the standard when I wasn't
this feature has been discussed in Note 849 (SQL 2003 Foundation, page
Notes-17 (1289)). You should check the final specification, it may be