| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Information req on Collab object key and sequence number |
« View previous topic :: View next topic » |
| Author |
Message
|
| emiddleware |
 Posted: Tue Apr 18, 2006 1:10 am Post subject: Information req on Collab object key and sequence number |
 |
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Hi ,
could anybody tell me the following :
1) How does ICS create the object key if it has to process n- number of collaborations ?
2) In which table of repository does ICS server maintain the object key ?? Is it CxWIPObjects table ??
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
 |
| Curry |
| Posted: Tue Apr 18, 2006 9:43 am Post subject: |
|
|
Newbie
Joined: 22 Feb 2006
Posts: 7
|
Hey,
Can you be more specific about the quesion ?
ICS maintains sequencing based on the key values. If you set multiple attributes as key values, then the server will use the composite key for ensuring sequencing.
To answer your second question, it does not write the business object data to any of the persistent tables(CxWipObjects, CxPBusObsjtate).. The server has its own unique key (connectorname+queueIndex+something else..)that it associates with each new event, that gets persisted. During recovery, it uses this unique key to retrieve the object from either MQ or the CxWipBlobs. |
|
| Back to top |
|
|
| veggiehui |
| Posted: Mon Jun 05, 2006 5:40 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
dear Curry,
| Quote: |
| ICS maintains sequencing based on the key values. If you set multiple attributes as key values, then the server will use the composite key for ensuring sequencing. |
when I insert a record, the destination will pop up a SQL error, [ORA-00001: unique constraint (CSI_SAMPLE.SYS_C008786) violated] ,I know , just as duplicated keys,how can I make the ICS can maintain sequence ?what information need I set up? |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Jun 08, 2006 12:58 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
have a auto generated field in the table to maintain the unique constraint.
_________________
-Ratan |
|
| Back to top |
|
|
| veggiehui |
| Posted: Wed Jul 05, 2006 4:46 pm Post subject: about the sequence |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
Dear Ratan ,
Would you please tell me more details? I am just stumped by this problem.Someone have ever told me create a trigger to increase the sequence in the table when insert a record, I want to know if have a better way.many thanks . |
|
| 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
|
|
|
|
