MQSeries.net :: View topic - Stored proc verus EJB Call

mmksri

Dear All,
I need your valuable inputs on designing a business scenario using WMBv6. I have a scenario where SwiftFIN message is received on a WMQ Queue and have to apply some business validations on that before processing it further. As any other EAI implementation, we have WAS And WMB in middle tier. Since WAS can not understand SwiftFIN messages directly, I am planing to have this transformed into xml and feed WAS to do the business validation. In our scenario we have all business logic built on WAS for all other types of messages. But only this case (SwiftFIN), MB is going to be the entry point.
One more thing we should be considering here is, sequential processing of the incoming requestes. Though WMB can be configured to have the message sequencing, to have the business validation ( just couple of db queries to authenticate and apply some rules on the incoming request) done I have two options:
1. Calling EJB from java compute node ( multiple instances of WAS are deployed and sequencing will be lost, if we use normal queue based communication).
2. Having a stored procedure invoked from WMB compute node.

I need your kind suggestions on this point. Would like to know the pros and cons for both the options. I feel that stored procedure call is going to be less expensive compared to other. Would be of great help if someone can give me some inputs on this (with some stats, if available to convince the client). Also wondering whether it's recommended to have business validation at stored procedure level.
Requesting you all to give me some pointers and kind suggestions on this. Many Thanks.

Thanks & regards,
mmksri.