| Author |
SQL receive adapter
|
|
| Charmy.Nandani 2005-09-04, 11:08 pm |
| hi all
I have configured a receive port using sql adapter.
Now i want to pass values to the select clause in the adapter dynamically from an orchestration.
Is there any way to do so?
Expecting a quick response
Thanx a lot
Charmy | |
| McGeeky 2005-09-05, 7:47 am |
| > Expecting a quick response
Good for you
> Now i want to pass values to the select clause in the adapter
> dynamically from an orchestration.
You cannot pass values to a receive adapter from an orchestration
--
McGeeky
http://mcgeeky.blogspot.com
"Charmy.Nandani" <Charmy.Nandani.1uvl91@mail.webservertalk.com> wrote in
message news:Charmy.Nandani.1uvl91@mail.webservertalk.com...
>
> hi all
>
> I have configured a receive port using sql adapter.
> Now i want to pass values to the select clause in the adapter
> dynamically from an orchestration.
>
> Is there any way to do so?
>
> Expecting a quick response
>
>
> Thanx a lot
> Charmy
>
>
>
> --
> Charmy.Nandani
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1190304.html
>
| |
| Alan Smith 2005-09-05, 7:47 am |
| Hi,
You need to use a the solicit-response pattern for this, the orchestration
sends a request message to SQL, and SQL returns a response.
To do this, create a solicit response port (two way request-respnse, I'll be
sending a request, then receiving a response), in your orchestration, then
bind it to a two-way send port that uses the SQL adapter.
Regards,
Alan
--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith
"Charmy.Nandani" wrote:
>
> hi all
>
> I have configured a receive port using sql adapter.
> Now i want to pass values to the select clause in the adapter
> dynamically from an orchestration.
>
> Is there any way to do so?
>
> Expecting a quick response
>
>
> Thanx a lot
> Charmy
>
>
>
> --
> Charmy.Nandani
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1190304.html
>
>
| |
| Charmy.Nandani 2005-09-08, 4:52 am |
| Hi
I tried passing values from the orchestration to sql using stored procedures .
But i m not able to configure stored procedures with return values
R any special configurations to be made for the same?
Plz reply soon | |
| Matt Milner 2005-09-08, 5:52 pm |
| You can't use return values, your stored procedure must return XML. Take a
look at the samples in the SDK for some basic ways to call the stored
procedure.
You can setup a receive location to call a stored procedure with parameters,
but you can't set the parameters dynamically. If you use a solicit-response
send port with SQL, then you can set the inbound parameters dynamically in
your orchestration and get back XML from the stored procedure.
Matt
"Charmy.Nandani" <Charmy.Nandani.1v1j51@mail.webservertalk.com> wrote in
message news:Charmy.Nandani.1v1j51@mail.webservertalk.com...
>
> Hi
>
> I tried passing values from the orchestration to sql using stored
> procedures .
>
> But i m not able to configure stored procedures with return values
>
> R any special configurations to be made for the same?
>
> Plz reply soon
>
>
>
> --
> Charmy.Nandani
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1190304.html
>
| |
| Charmy.Nandani 2005-09-08, 11:07 pm |
| Hi
i m returning xml from the stored procedure
but when i try to generate a schema using sql adapter, it does'nt cgenerate the response schema according to the procedure's return value, it just gives "Sucess" as an element in the response schema
What could be the probable reason for this.
Thanx | |
|
| The select query in SP should include xmldata predicate ..
Eg: Select * from ABC for xml auto, xmldata
This "xmldata" predicate should be present in the SP only during the
generation of the schema.. after that, you need to remove it..
Hope this helps!
Jagan
"Charmy.Nandani" wrote:
>
> Hi
>
> i m returning xml from the stored procedure
> but when i try to generate a schema using sql adapter, it does'nt
> cgenerate the response schema according to the procedure's return
> value, it just gives "Sucess" as an element in the response schema
>
> What could be the probable reason for this.
>
> Thanx
>
>
>
> --
> Charmy.Nandani
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1190304.html
>
>
|
|
|
|