ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Storing SQL queries

Post new topic  Reply to topic
 Storing SQL queries « View previous topic :: View next topic » 
Author Message
sapana
PostPosted: Thu Feb 26, 2009 6:07 am    Post subject: Storing SQL queries Reply with quote

Apprentice

Joined: 16 Apr 2007
Posts: 33
Location: Pune
I need to retrieve data from database from a message flow.
Where should I store the sql query if I expect the sql query to change in future and need to avoid rebuilding & deployment of message flow? Is there a standard way of doing this? I intend to use the builtin database nodes for accessing database.

Sapana
Back to top
View user's profile Send private message
sridhsri
PostPosted: Thu Feb 26, 2009 6:52 am    Post subject: Reply with quote

Master

Joined: 19 Jun 2008
Posts: 297
You have a number of options to persist

1) Store them in table
2) Store them in a file that can be loaded in the memory when the EG starts.
3) Store them in queue - use some sort of message selector to get the message you want.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Thu Feb 26, 2009 8:17 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
it is a question how do you use the default values in Business Mapping properly well

There are chances that the default may change in the future to a different value (functional Requirements), that time the developer has to change the code and rebuild it. (as you mentioned you dont like this to happen)

so keep the Default values as string in Database, use a helper function (propertyFile Lookup) and fetch the values out of it and use.

change the database and bounce your broker when ever the updation happens at Database side
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Storing SQL queries
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.