MQSeries.net :: View topic - Transcation in Java Compute Node

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Transcation in Java Compute Node

Transcation in Java Compute Node

« View previous topic :: View next topic »

Author

Message

new_to_wmb8

Posted: Tue Sep 02, 2014 1:14 am Post subject: Transcation in Java Compute Node

Centurion

Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India

Hi,

I am using java compute node for database interaction.

MQInput----> Compute Node--->Java Compute Node

In java compute node, i am interacting with oracle database and updating the 2 tables. I want to roll back every thing if any of the table during insertion throws the exception.
I already set the MQ Input Transcation to yes but seems its not working.

Any suggestion????

Thanks

smdavies99

Posted: Tue Sep 02, 2014 1:21 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

If you do a search on this forum for

JCN Transactionality

there is a lot of discussion about this very issue especially relating to the type of JDBC connection you have to use.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

new_to_wmb8

Posted: Tue Sep 02, 2014 2:18 am Post subject:

Centurion

Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India

I have chedked that forum but my problem remain same.

I want to rollback the databse insert if any of the two table fails.

Any suggestion?

smdavies99

Posted: Tue Sep 02, 2014 2:28 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Perhaps also searching for

Compensating Transaction

might help you a bit further
for example
http://www.mqseries.net/phpBB/viewtopic.php?t=57733

Are you using an 'XA' transaction manager? This may also have an impact on what you need to do.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

vicentius

Posted: Tue Sep 02, 2014 2:47 am Post subject:

Apprentice

Joined: 01 Mar 2013
Posts: 28

Do you use a JDBC type 4 connection?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Transcation in Java Compute Node

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