java - JMS Multiple messages locks database table -
i having web service receiving multiple xml file @ time contains student's data need process file , store values database.
for have used jms queue. creating object message , pushing queue. when queue processing message messages available process , due database table gets locked.
consider having 1 list contains 5000 values , in loop iterating list , processing jms messages.
this scenario . problem while processing 1 message table gets locked , rest of file remains in queue.
suggest solution
- make sure use right lock strategy (see table level locking , row level locking)
- see if can treat messages 1 @ time, (jms consumer conf.) way, first message release lock second 1 , on
edit: typo , links
Comments
Post a Comment