0

I created a new sequence in ESB config project.I am using wso2 developer studio 3.8

   <sequence xmlns="http://ws.apache.org/ns/synapse" name="TestDBSequence" trace="enable">
   <dbselect>
     <connection>
     <pool>
        <dsName>jdbc/sqlserver</dsName>
     </pool>
  </connection>
      <statement>
        <sql>select si.[Name] as SKU,from [Test] si WHERE NAME = '100000051'</sql>
        <result name="SKU" column="SKU"></result> 
       </statement>
       </dbselect>
    </sequence>

But when I am trying to save the sequence there is an error : Unknown synapse configuration tag.

I have the jars files for dbselect but no idea how to add in pom.xml to save it.

Community
  • 1
  • 1
nitin
  • 61
  • 3

1 Answers1

0

Likely the error points to the fact that you are using a non-existing mediator, I think you mean dblookup, like this:

<dblookup>
      <connection>
         <pool>
            <dsName>jdbc/sqlserver</dsName>
         </pool>
      </connection>
          <statement>
            <sql>select si.[Name] as SKU,from [Test] si WHERE NAME = '100000051'</sql>
            <result name="SKU" column="SKU"></result> 
          </statement>
</dblookup>
Jan
  • 618
  • 5
  • 12
  • Yes Jan I am using Dbselect mediator using below jars. I searched something for maven and installed the jar in local repository. Can you help m e in how to add that dependency in project.? https://github.com/mephist/wso2-esb-dbselect – nitin Apr 14 '16 at 17:34
  • Ah I see, so normally it should work with the following steps: - Build the .jar with mvn clean package - Put the .jar in the repository/components/dropins folder of the WSO2 ESB installation – Jan Apr 15 '16 at 11:30
  • So to be clear: The .jar is not linked in the ESB project but it is deployed in the ESB itself to make `dbselect` available – Jan Apr 15 '16 at 11:40