Composites are not working intermittently due to ClassCastException (Doc ID 2552687.1)

Last updated on MAY 12, 2023

Applies to:

Symptoms

Some composites which are changing the xa datasource name dynamically at the runtime in connection factory are encountering this issue, and are not working intermittently.

The error code is,

Exception occurred when binding was invoked.

Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'OracleDBServiceSelect' failed due to: Could not create/access the TopLink Session.

This session is used to connect to the datastore.

Caused by java.lang.ClassCastException: org.eclipse.persistence.queries.ScrollableCursorPolicy cannot be cast to org.eclipse.persistence.queries.CursoredStreamPolicy.

You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not to be retry-able, likely due to a modelling mistake.

Cause

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