• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with Two phase commit (WebShpere-MQ)

 
Devesh H Rao
Ranch Hand
Posts: 687
Hibernate jQuery Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I need some help to figure out what may be happening as i am not getting any error trace or exception.

I am selecting some values from database packaging the information and putting it in MQ, if the steps are successful i am updating certain statuses in the database so the flow is for the following transactions are

1. Select
2. Put in MQ
3. Update

I am facing a problem where in the tables locks whenever the API is called. after some time the transaction times out and rolls back.

I am working on the following config

Server = Websphere v5
MQ = v5.2
DB2 = v8.1
Database Drivers = Type 2 XA complaint
API transaction type = "TX_REQUIRED"

can anyone help me out in here as i think i have missed out on some configuration or done some configuration in a wrong way.


Thanks & Regards
[ May 23, 2004: Message edited by: Devesh H Rao ]
 
Suttan Pym
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
What is the isolation-level used during database access. The porblem seems that the select is getting lock on the table and you are not able to update the data. To confirm this just try to start the Transaction after the select and it would work. (Anyway select need not be within a Transaction - right).

Suttan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic