Hi,
I have a batch process running 50 threads (WorkManager in WebLogic 9).

For efficiency each thread loads 200 trades to be processed in a single flush/transaction. Now I need to accoumulate calculated charges for each trade in a single record.

While processing 200 trades, current accumulated value being added should be visible and updatable by other threads.
Application is running on a single machine.
Not sure if hibernate can and what should be done on hibernate level
I'm processing around 10 transactions per second per thread so record will be updated at 100 times per second.
I'm also planning to use batch update statements like
"update trade set tradeCount=tradeCount+?"
I'm assuming that optimistic locking will create a lot of exceptions in this scenario.

Any ideas are very welcomed.

Thanks, Igor.