My Oracle Support Banner

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: and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.


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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.