How To Do Inserts With a Database Adapter Without Touching The PK (Doc ID 1336543.1)

Last updated on SEPTEMBER 21, 2011

Applies to:

Oracle SOA Platform - Version: 11.1.1.5.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Goal

You have configured a Database Adapter to do inserts on a MS SQLServer database. The primary key is automatically generated, but the adapter wizard prevents you from leaving out the primary key. As a result, the insert statement fails because the primary key is getting inserted. How can you leave it out of the insert?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms