ClusterJ Raising Exception on SetPartitionKey After Previous Transaction Failed (Doc ID 1626770.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Cluster - Version 7.3 and later
Information in this document applies to any platform.
This is based on implementing Cluster/J code and is not part of the MySQL Cluster product itself.

Symptoms

On : 7.3 version, Cluster/J

When attempting to set partitioning key using setPartitionKey() before starting next transaction ClusterJ displays
the following error occurs.

ERROR
-----------------------
ClusterJUserException: "transaction enlisted"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open session with autocommit off.
2. Start a transaction and rollback.
3. Try to set partitioning key using setPartitionKey.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot trust the consistency of the transactions.

Cause

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