Kbase 17625: How does Apptivity identify the unique key - JDBC connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How does Apptivity identify the unique key - JDBC connection
Apptivity uses various JDBC methods to try to find the columns that
uniquely identify a row in a resultset.
The first is the DatabaseMetaData.getBestRowIdentifier().
If this fails, then DatabaseMetaData.getPrimaryKeys() is tried.
If this fails, then we look for a non-nullable column that is indexed
and does not allow duplicate entries (unique key index) using the
DatabaseMetaData.getIndexInfo() method.
Finally, if this fails and the database is oracle we append the
ROWID field to the select statement for use as the unique key.
Progress Software Technical Support Note # 17625