Instruct how to implement an auto-generated/identity column by means of a database sequence when JDBC adapter connects to Oracle database

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.

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2","Edition":"-NA-","Line of Business":{"code":"","label":""}}]

Was this topic helpful?

Document Information

More support for:
WebSphere Adapters Family

Software version:
6.2

Operating system(s):
AIX, HP-UX, Solaris, Windows

Document number:
622887

Modified date:
15 June 2018

UID

swg21379876

IBM Support

Tips