BizTalk Server Orchestration

Author

SQL Adapter

Chello

2005-01-12, 5:53 pm

Hello,

I have tried just about everything to construct a message for a SQL-adapter
in an orchestration, but I keep on getting a message saying "Message has not
been initialized in construct statement ".

I have got a file which I drop in a directory. Two of the fields in this
record have to used to insert a record in a table in a SQL Server database.
For that reason, I defined a SQL adapter. That worked just fine. the
appropriate request and response messages were created in my solution.

Next I created a message of type: requestmessage of the SQL-adapter. Then I
add a coonstruct shape and a message assignment to the orchestratioon. .Now
I try to assign the two fields to the SQL-fields like this:

mSQL.Customer = mOrder.Customer;
mSQL.OrderDate - mOrder.OrderDate;

But that does not work. While typing in mSQL and a dot it says "illegal
dotting". mSQL seems to be unknown, but I have specified it, and typed it.

Any clues?

Thanks in advance
Jan van Toor

Jon Flanders

2005-01-12, 5:53 pm

Jan - in order for you to be able to do the "dot" syntax, the elements in
your schema have to be promoted as distinguished fields. In any case,
someone has to create the new xml document for the outgoing message, you can
do that with a .NET component (generally the easiest way to do tit). You
can find many examples of this in the documentation and on the web.

--
Jon Flanders [DevelopMentor]
http://staff.develop.com/jfland/
http://www.develop.com/courses/biztalk
"Chello" <sandmann@chello.nl> wrote in message
news:EJcFd.92373$yn4.3702@amsnews03-serv.chello.com...
> Hello,
>
> I have tried just about everything to construct a message for a
SQL-adapter
> in an orchestration, but I keep on getting a message saying "Message has
not
> been initialized in construct statement ".
>
> I have got a file which I drop in a directory. Two of the fields in this
> record have to used to insert a record in a table in a SQL Server
database.
> For that reason, I defined a SQL adapter. That worked just fine. the
> appropriate request and response messages were created in my solution.
>
> Next I created a message of type: requestmessage of the SQL-adapter. Then
I
> add a coonstruct shape and a message assignment to the orchestratioon.
..Now
> I try to assign the two fields to the SQL-fields like this:
>
> mSQL.Customer = mOrder.Customer;
> mSQL.OrderDate - mOrder.OrderDate;
>
> But that does not work. While typing in mSQL and a dot it says "illegal
> dotting". mSQL seems to be unknown, but I have specified it, and typed it.
>
> Any clues?
>
> Thanks in advance
> Jan van Toor
>
>

Matt Milner

2005-01-12, 8:46 pm

You can create a map from yoru input file to the sql message and create your
message that way.

Matt

"Chello" <sandmann@chello.nl> wrote in message
news:EJcFd.92373$yn4.3702@amsnews03-serv.chello.com...
> Hello,
>
> I have tried just about everything to construct a message for a
> SQL-adapter in an orchestration, but I keep on getting a message saying
> "Message has not been initialized in construct statement ".
>
> I have got a file which I drop in a directory. Two of the fields in this
> record have to used to insert a record in a table in a SQL Server
> database. For that reason, I defined a SQL adapter. That worked just fine.
> the appropriate request and response messages were created in my solution.
>
> Next I created a message of type: requestmessage of the SQL-adapter. Then
> I add a coonstruct shape and a message assignment to the orchestratioon.
> .Now I try to assign the two fields to the SQL-fields like this:
>
> mSQL.Customer = mOrder.Customer;
> mSQL.OrderDate - mOrder.OrderDate;
>
> But that does not work. While typing in mSQL and a dot it says "illegal
> dotting". mSQL seems to be unknown, but I have specified it, and typed it.
>
> Any clues?
>
> Thanks in advance
> Jan van Toor
>
>