| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Connecting database from MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| jeevan |
 Posted: Thu Nov 09, 2006 9:46 am Post subject: Connecting database from MQ |
 |
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
When MQ application connects to database it does thorugh a server application. Also, it uses the xa function. But i am not clear the mechanism. For example
who cals the server application? JMS client?
where is the mqbegin coded in Client application or in server applicaiton
are these the right calls xa_open, xa_end ? for accessing databse?
I would appreciate any clarification on this.
Thanks |
|
| Back to top |
|
 |
| jeevan |
| Posted: Thu Nov 09, 2006 9:54 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
Furthermore, it is not clear while reading that at what phase the call to database is made? does that machine require odbc confgured? what driver does that application use?
| Quote: |
The queue manager communicates with database managers using the XA interface as described in X/Open Distributed Transaction Processing: The XA Specification. Examples of these function calls are xa_open, xa_start, xa_end, xa_prepare, and xa_commit. We use the terms transaction manager and resource manager in the same sense as they are used in the XA specification
|
thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Nov 09, 2006 10:04 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The queue manager (not MQ, the queue manager) establishes connections to databases only when the queue manager is configured to act as a transaction manager for a database.
The only use of those connections is for purposes of coordinating the database transactions that are in a global unit of work with MQ transactions.
Without the installation and use of the Extended Transactional Client, the queue manager can only coordinate transactions for MQ applications that are using binding connections.
MQ can also be configured to act as a resource manager for it's connections to allow another program to act as a transaction coordinator. In that case, the queue manager would not make any connections to the databases - as the transaction coordinator would handle the database part of the global transaction.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jeevan |
| Posted: Thu Nov 09, 2006 10:33 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
Thank you jeff. I am asking this, I have to dealth with a situatoin where there is database connection problem. I am basically admin guy though i understand mqi call and jmx call in general but not transaction is beyond my understanding.
from admin point of view, what configuration does the queue manager need? any swith to turn on or ? what does it require?
Thanks again |
|
| Back to top |
|
|
| jeevan |
| Posted: Thu Nov 09, 2006 12:39 pm Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
| Generally, application server ( WAS ) will be xa coordinator. Is that right? |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
