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

  1. make sure use right lock strategy (see table level locking , row level locking)
  2. see if can treat messages 1 @ time, (jms consumer conf.) way, first message release lock second 1 , on

edit: typo , links


Comments

Popular posts from this blog

html - How to style widget with post count different than without post count -

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

javascript - storing input from prompt in array and displaying the array -