I have a scenario that I am not exactly sure how to implement and I am hoping that someone will be able to help me.
I have 2 different protocols, we will call them simply Protocol-1 and Protocol-2. I have created http bindings, eip routers, and transforms (parse the request, create a Protocol-1 or Protocol-2 specific object, and serialize using Xstream) for each protocol and deployed 2 different service assemblies. Now the problem. The data that is sent in the request from Protocol-1 defines inserts and updates on a database. The data that is sent in the request from Protocol-2 defines inserts, updates, and queries on a database. The inserts and updates from each protocol are not necessarily the same. The database that both protocols communicate with is the same (MySQL) database. I am trying to figure out the best way to implement the database communication. Idea 1, create a web service that will define all of the different operations on the database for both protocol-1 and 2 and simply pass in simple data types. Idea 2, create 2 different web services, Protocol-1-DB-WS that defines Protocol-1 specific calls, and Protocol-2-DB-WS that defines Protocol-2 specific calls. Idea 3, create either a JBI component or a lightweight component that will communicate with the database and perform the operations on it for each of the protocols. Does anyone have any other ideas? Any thoughts? Any questions? Thank you very much, Doug
