wood burning stoves 2.0*
The moose likes Websphere and the fly likes 2 phase commit Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "2 phase commit" Watch "2 phase commit" New topic
Author

2 phase commit

sateesh lg
Greenhorn

Joined: Mar 29, 2004
Posts: 2
Hi,
I am getting the below error in a 2 phase commit transaction. I am using Websphere MQ 5.3 and DB2 Connect 7.2. Can someone please help? Are there any specific settings required for 2 phase commit. My datasource is JTA enabled, EJB is container managed and the transaction type is required
ERORR:
--------
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL30090N Operation invalid for application execution environment. Reason code = "1". SQLSTATE=25000
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
What version of WebSphere Application Server are you running?
Kyle


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
sateesh lg
Greenhorn

Joined: Mar 29, 2004
Posts: 2
Hi Kyle,
Thanks for the response. I am using Websphere Application Studio Developer 4.0.3, DB2 connect 7.2. The database resides on OS/390. Is there any specific setting that needs to be done for Db2 connect to support 2 phase commit? I am using a DB2XADatasource class to get the connection and it is JTS enabled. Is there any need of transaction processing monitor to be installed either on the workstation or the database (OS/390 - DB2)
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
Originally posted by sateesh lg:
Hi Kyle,
Thanks for the response. I am using Websphere Application Studio Developer 4.0.3, DB2 connect 7.2. The database resides on OS/390. Is there any specific setting that needs to be done for Db2 connect to support 2 phase commit? I am using a DB2XADatasource class to get the connection and it is JTS enabled. Is there any need of transaction processing monitor to be installed either on the workstation or the database (OS/390 - DB2)

This sounds like something on the DB2 (OS/390) side is not configured correctly. Take the following URL to you DBA and ask them to look at this.
WebSphere IS a TP Monitor. It sounds like DB2 on the mainframe is at fault in this case.
Kyle
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: 2 phase commit