MySQL Bugs: #76544: Insert, update records in multiple java threads with ClusterJ api

Bug #76544	Insert, update records in multiple java threads with ClusterJ api
Submitted:	31 Mar 2015 11:35	Modified:	2 Apr 2015 12:44
Reporter:	Arco van der Velden	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Cluster: Cluster/J	Severity:	S2 (Serious)
Version:	7.3.8 Win x64	OS:	Microsoft Windows
Assigned to:		CPU Architecture:	Any
Tags:	cluster, ClusterJ, java, multiple threads

Description:
I'm trying to insert and update records in three tables using multiple java threads and using the ClusterJ java api.
The result of my test is not all records are inserted and not all updates are performed while the insert and updates are in the same transaction.
Each java thread uses his own connection object obtained from SessionFactory
ClusterJDatastoreException (because of possible duplicate inserts) is catched and in that case rollback is called and the transaction is performed again.
No exceptions occur but like said before not all records are inserted and updated.

How to repeat:
Java classes can be provided if needed.

Database

Attachment: DatabaseSchema.sql (application/octet-stream, text), 2.31 KiB.

FixTradeInterface

Attachment: FixTradeDataInterface.java (application/octet-stream, text), 5.01 KiB.

FixTradeFacade

Attachment: FixTradeFacade.java (application/octet-stream, text), 3.72 KiB.

InstructionsFacade

Attachment: InstructionsFacade.java (application/octet-stream, text), 1.42 KiB.

PositionsFacade

Attachment: PositionsFacade.java (application/octet-stream, text), 1.41 KiB.

PositionsInterface

Attachment: PositionsInterface.java (application/octet-stream, text), 766 bytes.

ThreadClass

Attachment: ThreadClass.java.txt (text/plain), 4.74 KiB.

Source files are attached.

Can anybody please have a look at this, this issue is blocking further development of our application.