Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Service Broker / November 2006

Tip: Looking for answers? Try searching our database.

Any tips or ideas on how to implement "switch" concept in SSB?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Farmer - 06 Nov 2006 22:38 GMT
Hi.
Thanks for your time and help.

I have a switch problem I am trying to resolve using Service Broker.

I have any number of consoles that need to ask any number of services any number of questions.

------------            -------------
| Console A |            | Service X |
------------            -------------

------------            -------------
| Console B |            | Service Y |
------------            -------------

------------
| Console C |
------------

So if Console A asks Service Y a question, Service Y needs to know how to answer console A and not others.

I thought of starting never ending conversations from Console endpoint to Service endpoint. Each time a service starts, new conversation would begin and it would be ended if service is stopped.
This will give me a reliable way for any console to pick a service and ask a qestion.

--------------------------------------------------------
|         Console Queue/Service                        |
--------------------------------------------------------
   |                    |
   | Service X          | Service Y (conversations)
   |                    |
--------------------------------------------------------
|         Service Queue/Service                        |
--------------------------------------------------------

Now, the return path is a bit unclear. Any ideas how I can return answers?

Thanks
Farmer.
Roger Wolter[MSFT] - 06 Nov 2006 23:31 GMT
Conversations are always bidirectional so when the service receive a message on a conversation, sending a message using the received message's conversation handle will always return the message to the initiator's queue. A console should be able to send a question to a service and receive the response on the FROM SERVICE queue specified in the begin dialog.  This should work whether the service is running or not - that's the beauty of reliable messaging.  It's perfectly legitimate to send a message to a service that doesn't exist.  Service broker assumes that you know what you're doing and that someday the service will exist and at that time the message will be delivered.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 Hi.
 Thanks for your time and help.

 I have a switch problem I am trying to resolve using Service Broker.

 I have any number of consoles that need to ask any number of services any number of questions.

 ------------            -------------
 | Console A |            | Service X |
 ------------            -------------

 ------------            -------------
 | Console B |            | Service Y |
 ------------            -------------

 ------------
 | Console C |
 ------------

 So if Console A asks Service Y a question, Service Y needs to know how to answer console A and not others.

 I thought of starting never ending conversations from Console endpoint to Service endpoint. Each time a service starts, new conversation would begin and it would be ended if service is stopped.
 This will give me a reliable way for any console to pick a service and ask a qestion.

 --------------------------------------------------------
 |         Console Queue/Service                        |
 --------------------------------------------------------
     |                    |
     | Service X          | Service Y (conversations)
     |                    |
 --------------------------------------------------------
 |         Service Queue/Service                        |
 --------------------------------------------------------

 Now, the return path is a bit unclear. Any ideas how I can return answers?

 Thanks
 Farmer.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.