File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes Problem with Two phase commit (WebShpere-MQ) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Problem with Two phase commit (WebShpere-MQ)" Watch "Problem with Two phase commit (WebShpere-MQ)" New topic

Problem with Two phase commit (WebShpere-MQ)

Devesh H Rao
Ranch Hand

Joined: Feb 09, 2002
Posts: 687


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

Joined: Jan 30, 2003
Posts: 46
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).

I agree. Here's the link:
subject: Problem with Two phase commit (WebShpere-MQ)
It's not a secret anymore!