| 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 |
|
| Back to top |
|
 |
| 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. |
|
| Back to top |
|
|
| 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? |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
| 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? |
|
| Back to top |
|
|
|
|
