2 Replies Latest reply: Apr 10, 2012 3:26 PM by 927466 RSS

    Transform http input message into an other format using mediator

    927466
      Hi guys,

      Hope someone can help me out.
      I have to translate a HTTP message into an internal format p.e. SQL using mediator.
      In the composite.xml we have a HTTP Binding connect to a mediator.
      In the HTTP Binding is the Operation Type 'One Way" and the Verb = "GET", Operation Name = "Receive".
      Now in the mediator, if I double click on it, I see Routing Rules.
      Operation is "Receive" and 1 Fiter Expression.
      I expect to make the translation from HTTP to SQL here or am I wrong ?
      Do I have to make a "Filter Expression" and if so how can I do that?

      All suggestions are welcome.

      Kind regards, Cees
        • 1. Re: Transform http input message into an other format using mediator
          Swgt
          HI Cees,

          I didnt quite understand your question when you are talking about transformation from http input message into SQL format. Do you mean to say that you want to invoke a stored procedure or something on your SQL database? If so, then you can use the Database Adapter, and create a static routing rule to invoke a "Service" (which will be the DB Adapter) and get going.

          I doubt if this answers your question however. :(

          Swgt
          • 2. Re: Transform http input message into an other format using mediator
            927466
            Hi Swgt (and other guys),

            The problem is as follows :
            1)     Accept a Order message from an HTTP interface.
            2)     Transform the message to a new internal format using Mediator.
            3)     Update an arbitrary amount of lines in the DB, according to the message.
            4)     Update the original message with the result of the execution.

            I have first import schemas to an application, no problem.

            Then create a mediator, create a bpel proccess to update a database, I think I'll do it with a database adapter and a sored procedure.

            Just a description to start with it will help me for example : first import, then mediator (how it must look like?) then a bpel process.

            I hope you can help me, thanks,

            Cees