Forum Replies Created
-
AuthorPosts
-
any help regarding this post is appreciated.
Thanks
R-
Kumar,
You can do this by BizTalk SQL Adapter(comes with BizTalk 2004)!!
1. create a Stored Procedure
2.create a XSD using SQL Adapter(Updategram)
3.map hl7 messages to SQL XSD
need some information regarding SQL Adapter look at this link:
http://www.codeproject.com/dotnet/usingsqladapter.asp
Hope this information helps you.
Nar-
September 19, 2006 at 6:42 AM in reply to: Want a adapter to connect to oracle database from Biztalk server 2004 #15733can i see that sproc.
R-
September 19, 2006 at 6:30 AM in reply to: An error when trying to use orchestration as a webservice #15731If I were you, I'd first check this list of common fixes to this error (http://blogs.msdn.com/richardbpi/archive/2006/08/30/731783.aspx), then, I'd download and review the new BizTalk Developer's Troubleshooters Guide (http://blogs.msdn.com/richardbpi/archive/2006/09/13/751994.aspx).
Create a fact creator, then drop it in the GAC. Then you can test via the Composer …public class MyFactCreator : IFactCreator
{
private object[] myFacts;
public MyFactCreator()
{
}
public object[] CreateFacts ( RuleSetInfo rulesetInfo )
{
myFacts = new object[1];
myFacts.SetValue(new MySampleBusinessObject(),0);
return myFacts;
}
public Type[] GetFactTypes (RuleSetInfo rulesetInfo)
{
return null;
}
}DebugTrackingInterceptor dti = new DebugTrackingInterceptor(@"C:\NISHIL\outputtrace.txt");
//create an instance of the XML object
dti = new DebugTrackingInterceptor(@"C:\NISHIL\outputtrace.txt");
//create an instance of the XML object
//create an instance of the XML object
XmlDocument xd1 = new XmlDocument();
xd1.Load(@"C:\NISHIL\Input.xml");
TypedXmlDocument doc1 = new TypedXmlDocument("NishBizTest.Input", xd1);
// create the array of short-term facts
XmlDocument xd1 = new XmlDocument();
xd1.Load(@"C:\NISHIL\Input.xml");
TypedXmlDocument doc1 = new TypedXmlDocument("NishBizTest.Input", xd1);
// create the array of short-term facts
@"C:\NISHIL\Input.xml");
TypedXmlDocument doc1 = new TypedXmlDocument("NishBizTest.Input", xd1);
// create the array of short-term facts
TypedXmlDocument doc1 = new TypedXmlDocument("NishBizTest.Input", xd1);
// create the array of short-term facts
// create the array of short-term facts
object[] shortTermFacts = new object[1];
shortTermFacts[0] = doc1;
Policy policy = null;
object[] shortTermFacts = new object[1];
shortTermFacts[0] = doc1;
Policy policy = null;
Policy policy = null;
policy = new Policy("NishBizTest");
policy.Execute(shortTermFacts, dti);
FileInfo finfo = new FileInfo(@"C:\NISHIL\Output.xml");
StreamWriter writer = finfo.CreateText();
writer.Write(doc1.Document.OuterXml);
writer.Close();
FileInfo finfo = new FileInfo(@"C:\NISHIL\Output.xml");
StreamWriter writer = finfo.CreateText();
writer.Write(doc1.Document.OuterXml);
writer.Close();
StreamWriter writer = finfo.CreateText();
writer.Write(doc1.Document.OuterXml);
writer.Close();
All in all, a convoy and a singleton are the same thing. A singleton is implemented using a convoy.
There is no reason you need any type of batch or timeout. That’s just a more common scenario.
For a singleton, you’d just have a loop and have it never end. Loop until 1 = 0 or something.
You can use some like Received Port Name rather then message type, assuming everything is on the same port. Or you can create a custom pipeline that added some unique context property. The correlation can be on any promoted property that would unique to your group of messages. You could even use something like PO Exists.
Hope this helps.
only .dll
use a binding file to define ports and adapters.
only assemblies!!!
R-
September 18, 2006 at 6:26 AM in reply to: Problem of catching error if sending message fails on send port #15715You can use delivery notifications for this. Here are some good articles on the topic:
http://blogs.msdn.com/kevinsmi/archive/2004/07/03/172574.aspx
http://www.geekswithblogs.net/sthomas/archive/2004/08/02/9234.aspx
I'm not sure the way my understanding of Convoy is correct:
- Convoy is about processing several message in batchs(sequential or concurrent), those messages all contribute to a certain action
- and using correlation to define groups of batch –correlation is the unique property to identify a message or a batch of messages
But in my case, i cannot find a unique property for every file, becasue a single file can be sent twice, e.g., there may two files containing the same PO number, just because we need to do another data extract to update
And a single file will trigger the orchestration instance, it doesn't need to waiting for any other files to continue. The samples i found in MSDN are not my case…..mine seems simpler, but i have no idea how to using convoy to make the orchestration become singleton…
Can anyone clarify Convoy or Singleton Pattern clearer?
Many Thanks
September 17, 2006 at 12:04 AM in reply to: Map a LOT of values to different destinations conditionally #15711Hi, was reading youre post and I started google on "Inline XSLT" and I found this page:http://blogs.msdn.com/skaufman/archive/2005/12/19/505654.aspx. I Hoop you got some help out of it.
Regards,
J/*!
September 16, 2006 at 11:40 PM in reply to: Map a LOT of values to different destinations conditionally #15710I’ve always used inline XSLT for this type of task.
I wish there was a better way…
September 16, 2006 at 11:37 PM in reply to: issue using BTS.MessageID after message assignment #15709So you want the message ID of the newly constructed message?
One reason you see what you are seeing is the message doesn’t get constructed until a persistence point is reached. At that point, the new message will get persisted to the database and get assigned all the context properties. I’m guessing the reason you see it when you run the debugger, is that forces a persistence point. Likewise when you send out the message; another persistence point.
Try this as a test…. Right after the contract put in an Atomic Scope. This will force a persistence point. See if that solves the problem.
If that fixes it, you can then look at a better way to force a persistence to get your message id.
Hope this helps.
-
AuthorPosts