| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| IIB9: JCN, Commit. |
« View previous topic :: View next topic » |
| Author |
Message
|
| akil |
 Posted: Sat Mar 14, 2015 10:09 pm Post subject: IIB9: JCN, Commit. |
 |
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
Hi
The documentation clearly states the following
| Code: |
When you write Java classes for a JavaCompute node or a user-defined node, your code must comply with the following restrictions:
Do not include any code that performs a COMMIT or a ROLLBACK function.
Do not close the connection to the database. The broker manages all connections, and closes a connection if it is idle for approximately one minute, or if the message flow completes.
|
Does this mean that the JCN should be used to invoke a stored procedure that has a commit written in it or does it only say that a connection.commit should be called from within the JCN..
_________________
Regards |
|
| Back to top |
|
 |
| paustin_ours |
| Posted: Sat Mar 14, 2015 10:20 pm Post subject: |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
| ASAIK MQ acts as the transaction co-ordinator. IT does what is called a two phase commit with MQ and the Database. So when you the JCN do not include the commit. The broker will do the commit as part of the two phase commit. There is not need to write a stored proc with a commit in it. Give it a shot see what happens a simple insert statement to begin with. |
|
| Back to top |
|
|
| akil |
| Posted: Sun Mar 15, 2015 4:41 am Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
We have a couple of legacy stored procedures that we have to call. These stored procedures already have a commit in them. (We can't remove the commit, as the same procedure is used elsewhere)
In such a case, can the JCN be used or do we have to necessarily use ESQL with Commit ?
[/b]
_________________
Regards |
|
| 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
|
|
|
|
