Re: BUG #1988: keygen not implemented

Mike Clements wrote:

> Insert a row into the table using:
> Connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
> The driver throws an exception saying this method is not yet implemented.

This is an optional part of the JDBC spec, and the driver doesn't claim
to support it in the metadata it provides
(DatabaseMetaData.supportsGetGeneratedKeys() returns false).

> What it should do is create the prepared statement so when you execute it,
> the returned ResultSet has the generated primary key.

Unfortunately this requires functionality in the backend that does not
yet exist (support for "INSERT .. RETURNING ...", or similar).

-O