MQSeries.net :: View topic - Broker and database query behavior

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker and database query behavior

Broker and database query behavior

« View previous topic :: View next topic »

Author

Message

sanjoo

Posted: Mon Feb 27, 2012 11:26 pm Post subject: Broker and database query behavior

Acolyte

Joined: 26 Oct 2005
Posts: 65

Hello.
We have some configurable properties in database. Our message flow reads this data and takes decisions based on it.
However, if I change some parameter values in the database (either by another flow or manually and then commit the change), my message flow continues to run with old data. It somehow does not get updates and I have to reload EG to make changes effective.
Am I missing some configuration on odbc driver or within the broker?
I tried searching answers on the forum. May be it's just me but no help!

(Message broker 6.1.0.4 using odbc drivers and database is oracle 10g)

Thanks
_________________
Sanjoo

Keep smiling

adubya

Posted: Tue Feb 28, 2012 12:41 am Post subject:

Partisan

Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK

Is your broker code caching the DB parameter values ? There is no reason a broker flow cannot access modified DB values if it's actually reading the DB

smdavies99

Posted: Tue Feb 28, 2012 1:02 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Unless your flow does a periodic refresh of the params in the DB then your ONLY solution is to reload the EG or restart the Flow.

Normally where you are caching 'stuff' loaded from a DB (normally for performance reasons) you add a periodic timed DB refresh.

This is not difficult to code up but you do have to watch out if any of your flows have additional instances.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker and database query behavior

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