| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Using DB as end-point to a flow? |
« View previous topic :: View next topic » |
| Author |
Message
|
| torryramesh |
 Posted: Wed Jun 08, 2005 12:03 pm Post subject: Using DB as end-point to a flow? |
 |
|
Novice
Joined: 06 Aug 2004
Posts: 15
|
Is it good to design a message flow which does only updates to an Application Database ? In effect, using a message flow like a minimal JDBC adapter. (Input Node---->DatabaseNode)
What are the points to be considered in doing so, apart from, say, performance issues involved by nature of doing DB operations in a message flow.
In our case, we are trying to come up with this design option to save some cost. Currently, the requirement is to update 2 or 3 tables for the target application based on the input message.
Any pointers might help us.
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Jun 08, 2005 12:31 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's not a bad design.
IBM will tell you that performance of database calls in WBIMB is slow, and that WBIMB is not an application server.
That said, it's still not a bad design.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Wed Jun 08, 2005 2:32 pm Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
well!.. here is my view,
Performance shudn't be a big for ODBC calls, if you have suffcient CPU's and memory..
question comes,
if the db is down or the comm. chnnel is down, with the message flows, -> the messages are directed to failure queue (catch terminal).
If you have sequential messages coming through..
ex: Create message failed due to db down, routed to failure queue
db is up in a while.. then update message has come along ..
what happes next ? (in case of deltaupdates).
I prefer .. Adapters in this scenario...
as, db is down.. let the messages pile up in the request queue,
but again.. it varies alot with the business requirements, funding..and etc..
-RR |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
