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

[31 Mar 2015 11:35] Arco van der Velden
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.
[31 Mar 2015 11:47] Arco van der Velden
Database

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

[31 Mar 2015 11:47] Arco van der Velden
FixTradeInterface

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

[31 Mar 2015 11:48] Arco van der Velden
FixTradeFacade

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

[31 Mar 2015 11:48] Arco van der Velden
InstructionsFacade

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

[31 Mar 2015 11:48] Arco van der Velden
PositionsFacade

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

[31 Mar 2015 11:48] Arco van der Velden
PositionsInterface

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

[31 Mar 2015 11:49] Arco van der Velden
ThreadClass

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

[31 Mar 2015 11:49] Arco van der Velden
Source files are attached.
[2 Apr 2015 12:44] Arco van der Velden
Can anybody please have a look at this, this issue is blocking further development of our application.