Re: JDBC getImortedKeys() getExportedKeys() incorrect ON

On Fri, 15 Aug 2003, Richard Froud wrote:

> Please enter a FULL description of your problem:
> ------------------------------------------------
> When reading database metadata for foreign keys using the JDBC
> DatabaseMetaData.getImportedKeys() and DatabaseMetaData.getExportedKeys()
> methods the ON UPDATE rule is returned as the ON DELETE rule. It is also
> correctly returned as the ON UPDATE rule. Therefore there is no way to
> access the ON DELETE rule. Consequenntly innaccurate representations of the
> database structure are obtained.

Here is a patch for this. Additionally the on delete rule would not
return importedKeyRestrict because of a missing if statement. Also an
addition to the test suite is attached.

Kris Jurka