My Oracle Support Banner

Database Adapter Execution Results in the Error: [EclipseLink-6044] Primary keys must not contain null (Doc ID 1262880.1)

Last updated on AUGUST 09, 2018

Applies to:

Oracle SOA Platform - Version to [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 21-June-2013***


You have an installation of Oracle Fusion Middleware 11g where you are developing a composite application to run within the Oracle SOA Suite technology and within the implementation of your composite you have leveraged the Database Adapter component.

You have successfully developed and deployed the composite to the SOA managed server but at run-time, when testing the composite you encounter an error similar to the following:

java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException:
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding:
"JCA Binding execute of Reference operation 'searchListOfSubscribersSelect'
failed due to:
DBReadInteractionSpec Execute Failed Exception. Query name: [searchListOfSubscribersSelect], Descriptor name: [searchListOfSubscribers.Topic].
Caused by Exception [EclipseLink-6044] (Eclipse Persistence Services - 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.QueryException Exception Description:
The primary key read from the row [DatabaseRecord( TOPIC.NAME => NAME#1 TOPIC.ENDPOINT => topicendpoint_1 => SUBSCRIBER#1 => filter_1)]
during the execution of the query was detected to be null. Primary keys must not contain null. Query: ReadAllQuery(name="searchListOfSubscribersSelect"
referenceClass=Topic sql="select T.NAME, T.ENDPOINT, S.SUBSCRIBER, F.FILTER from TOPIC T inner join SUBSCRIBER S on T.TOPIC_ID = S.TOPIC_ID left outer join FILTERS F on s.SUBSCRIBER_ID = F.SUBSCRIBER_ID where upper( s.status ) ='ACTIVE' and (T.NAME = ?)"). ".
The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
at oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(
at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(
at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.
at java.lang.reflect.Method.invoke(
at com.sun.el.parser.AstValue.invoke(
at com.sun.el.MethodExpressionImpl.invoke(


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.