Troubleshooting
Problem
How to use a database sequence to define a field as an auto-generated field when JDBC adapter connects to Oracle database
Symptom
When you run the enterprise service discovery process against a table which contains a column as an identity column in either a DB2 or Microsoft SQL Server database, the generated business object for that table does not include the Unique Identifier attribute. Because the adapter needs the Unique Identifier of the identity column at run time, you must add it to the attribute application-specific information. In this case, you add <UID>AUTO<UID> to the attribute application-specific information. For example, id column in following illustration is defined as an identity column in DB2 database.
When using Oracle database in this scenario, you can specify the sequence name to UID in order to define a field as an auto-generated field since Oracle does not support identity column.
Environment
Adapter version 6.2
Resolving The Problem
Specify the sequence name to UID in order to define a field as an auto-generated field since Oracle does not support identity column. Please refer to following illustration.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21379876