What I miss in BizTalk: It's the behavior in the Oracle Adapter. When I use composite operation calling two consecutive insert, If "UseOracleConnectionPool" is not switched on, it will get the well known error, "ORA-08002 Sequence not yet defined in this session". I didn't know the reason why use connection pool.
What can be done to fix it: not fix.
Do I think it is an easy fix? 7-8 Still not fix it. Really Lost..
Please Mark as the Answer, if this answers your question. Please vote as helpful, if this post is helpful.
- Edited by Molly Bryant Monday, July 08, 2013 9:08 AM edit
What I miss in BizTalk: I would really like for there to be a way to programatically initialize a correlation set in an orchestration without sending or receiving a message, possibly without a message at all (manually setting context properties based on variables or hard coded variables). Currently the only way to activate a correlation set is upon a message receipt or a message send, and can only be based on context properties that exist on the received or sent message which can impose a limit on flexibility.
What can be done to fit it: Expose a programmatic means of initializing correlation. Maybe something like - corrSet1.Add("ReceivePortName", http://schemas.microsoft.com/BizTalk/2003/system-properties, "ReceivePort1"); corrSet1.Add("CustomContextProperty1", "CustomNamespace1", "A value"); corrSet1.Activate;
Do I think it is an easy fix? 5. This really depends how correlation is implemented under the hood. Would of course require a whole new level of testing by Microsoft.
How could this be useful?
- You're creating long running orchestrations and want to be able to activate a constant correlation set in all of them so you can send control messages to them. For example if you want to have all your long running orchestrations write their activating message to the file system and shut down so you can do a deployment if you want to avoid side by side versioning.
- You want to initialize a correlation set based on a lookup of a value in the activating message. However the lookup was done within the orchestration using BRE/SSO/.Net class and you really don't want to have to create a message and send it out of your orchestration to initialize a correlation set which forces an unnecessary persistence point and you've got to do something with the sent message.
- You want to initialize a correlation set based on a value within a message however the element isn't promoted to a context property and you are not allowed to modify the schema.
- Edited by Johann Cooper Wednesday, July 17, 2013 11:35 PM More details.