wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Problem with Two phase commit (WebShpere-MQ)" Watch "Problem with Two phase commit (WebShpere-MQ)" New topic
Author

Problem with Two phase commit (WebShpere-MQ)

Devesh H Rao
Ranch Hand

Joined: Feb 09, 2002
Posts: 687

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

Joined: Jan 30, 2003
Posts: 46
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with Two phase commit (WebShpere-MQ)
 
Similar Threads
2 phase commit
J2EE Transaction Context in the distributed environment
MQ v5.3 in WSAD5.1.1-Read File from MQ
MQSeries or messaging simple question
Problem:(Urgent ) 2 Phase Commit by WebSphere on Oracle database and MQ Series