ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Multiphase Commit » 2phase commit

Post new topic  Reply to topic Goto page 1, 2  Next
 2phase commit « View previous topic :: View next topic » 
Author Message
Seshagiri
PostPosted: Tue Oct 11, 2011 8:18 am    Post subject: 2phase commit Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

Hi,

I am running a java application and using MQ7 and oralce 11g release2. I am using 2phase commit. when I commit queue then I am able to see the data in the queue but unable to see the data in table but when I close the database connection then able to see the data in the tables. The calls as as follows

qmanager.commit();//At this point the data commited in queue but no data in database tables

con.close();// At this point I am able to see the data in the database.

OS: solaries10

Here java application,MQ and database are on the same system.

I am using oracle.jdbc.xa.client.OracleXADataSource in java application


I feel that 2phase is not working properly. Please let me know is any thing has to be changed.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Oct 11, 2011 8:23 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
Location: US: west coast, almost. Otherwise, enroute.

Is this the same subject as your prior post ?http://www.mqseries.net/phpBB2/viewtopic.php?t=59098
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Oct 11, 2011 8:26 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

bruce2359 wrote:
Is this the same subject as your prior post ?http://www.mqseries.net/phpBB2/viewtopic.php?t=59098


Yes. Please help me to figure it out
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue Oct 11, 2011 8:29 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

It appears you are expecting that the commit call to the queue manager object will magically cause a commit call to the database.

There is no magic.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Oct 11, 2011 8:33 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

mqjeff wrote:
It appears you are expecting that the commit call to the queue manager object will magically cause a commit call to the database.

There is no magic.


Please let me know how it works. We have created the switchfile and done the configuration.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Oct 11, 2011 8:35 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
Location: US: west coast, almost. Otherwise, enroute.

Seshagiri wrote:
bruce2359 wrote:
Is this the same subject as your prior post ?http://www.mqseries.net/phpBB2/viewtopic.php?t=59098


Yes. Please help me to figure it out

Please do not open a new post for an existing issue. There are some WMQ configuration issues you must address that will let an mq commit coordinate changes to your Oracle database AND mq resources.

You will need to refer to Oracle documentation, and then make the appropriate changes to your WMQ configuration.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Oct 11, 2011 8:40 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

bruce2359 wrote:
Seshagiri wrote:
bruce2359 wrote:
Is this the same subject as your prior post ?http://www.mqseries.net/phpBB2/viewtopic.php?t=59098


Yes. Please help me to figure it out

Please do not open a new post for an existing issue. There are some WMQ configuration issues you must address that will let an mq commit coordinate changes to your Oracle database AND mq resources.

You will need to refer to Oracle documentation, and then make the appropriate changes to your WMQ configuration.


Jedi sorry for opening the issue again. Can you please let me know the mq configuration issues so that I can understand where I am going wrong.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Oct 11, 2011 8:43 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
Location: US: west coast, almost. Otherwise, enroute.

WMQ comes with the capability for your application to coordinate local units of work (WMQ resources only).

In order for your application to coordinate global units of work (resources of WMQ and database), you or your WMQ administrator will need to make modifications to the qmgr configuration.

You (or your WMQ administrator) will need to refer to Oracle documentation and WMQ documentation (WMQ System Administration manual), and then make the appropriate changes to your WMQ configuration.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Oct 11, 2011 8:56 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

bruce2359 wrote:
WMQ comes with the capability for your application to coordinate local units of work (WMQ resources only).

In order for your application to coordinate global units of work (resources of WMQ and database), you or your WMQ administrator will need to make modifications to the qmgr configuration.

You (or your WMQ administrator) will need to refer to Oracle documentation and WMQ documentation (WMQ System Administration manual), and then make the appropriate changes to your WMQ configuration.


Can you please guide on this to me. Here I am dealing with global unit of work. But just to understand. Is closing of connection of databse is correct or worng.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Oct 11, 2011 9:02 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
Location: US: west coast, almost. Otherwise, enroute.

Seshagiri wrote:
Is closing of connection of databse is correct or worng.

Your application will not be able to coordinate a global unit of work until your WMQ configuration is set up to support a global unit of work. Until then, your application will only coordinate local units of work.

Please read about global units of work in the WMQ Application Programming Referene, WMQ Application Programming Guide, and WMQ System Administration manuals.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue Oct 11, 2011 9:06 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Seshagiri wrote:
bruce2359 wrote:
WMQ comes with the capability for your application to coordinate local units of work (WMQ resources only).

In order for your application to coordinate global units of work (resources of WMQ and database), you or your WMQ administrator will need to make modifications to the qmgr configuration.

You (or your WMQ administrator) will need to refer to Oracle documentation and WMQ documentation (WMQ System Administration manual), and then make the appropriate changes to your WMQ configuration.


Can you please guide on this to me.

You have been guided.

You have been guided to READ THE DOCUMENTATION.

We can not read the documentation to you.

You have provided absolutely no information about what steps you have taken to CONFIGURE the global unit of work.

You have provided no absolutely no information about whether your application CAN SUPPORT a global unit of work. It is not automatic that ALL mq applications, regardless of what language and where they run, can use global units of work.

It is your job to spend a lot more of your time researching this.

If you have specific questions about specific pieces of the documentation, then you may get more assistance.

If you persist in saying "tell me how to do this", you will likely not get more assistance.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Oct 11, 2011 9:18 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

mqjeff wrote:
Seshagiri wrote:
bruce2359 wrote:
WMQ comes with the capability for your application to coordinate local units of work (WMQ resources only).

In order for your application to coordinate global units of work (resources of WMQ and database), you or your WMQ administrator will need to make modifications to the qmgr configuration.

You (or your WMQ administrator) will need to refer to Oracle documentation and WMQ documentation (WMQ System Administration manual), and then make the appropriate changes to your WMQ configuration.


Can you please guide on this to me.

You have been guided.

You have been guided to READ THE DOCUMENTATION.

We can not read the documentation to you.

You have provided absolutely no information about what steps you have taken to CONFIGURE the global unit of work.

You have provided no absolutely no information about whether your application CAN SUPPORT a global unit of work. It is not automatic that ALL mq applications, regardless of what language and where they run, can use global units of work.

It is your job to spend a lot more of your time researching this.

If you have specific questions about specific pieces of the documentation, then you may get more assistance.

If you persist in saying "tell me how to do this", you will likely not get more assistance.



Sorry I did not intend you people to read docs for me. I just wana know closing the connection is right or wrong.
Back to top
View user's profile Send private message
Vitor
PostPosted: Tue Oct 11, 2011 9:23 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Seshagiri wrote:
I just wana know closing the connection is right or wrong.


It's irrelevant.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Oct 11, 2011 9:29 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
Location: US: west coast, almost. Otherwise, enroute.

Vitor wrote:
Seshagiri wrote:
I just wana know closing the connection is right or wrong.


It's irrelevant.


I'm not sure how I/we can make this any clearer.

There is nothing your application (or any application, in any programming language) can do to effect a two-phase commit until your queue-manager is configured to support two-phase commit.

How to configure your queue-manager to support two-phase commit is documented.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Thu Oct 13, 2011 8:56 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

I have a question. I have two qmanagers say Qmgr1 and Qmgr2 and database oracle. I have added resource manager information in qm.ini file of Qmgr1 with the resource name as say "myoracle". if I want to add the resource manager information in qm.ini file of Qmgr2 then do I need to use same name or can specify different name.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page 1, 2  Next Page 1 of 2

MQSeries.net Forum Index » Multiphase Commit » 2phase commit
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.