首页 > 解决方案 > 为什么接受 dbreport 响应 202,我需要 200

问题描述

* 此 API 用于插入 DB。当我请求此 ESB API 响应 202 接受时,但我需要 200 我没有设置异步请求。请原谅我糟糕的英语。我说清楚了吗?谢谢。*

<api xmlns="http://ws.apache.org/ns/synapse" name="xxxxxx" context="/xxxxxxx">
   <resource methods="POST" url-mapping="/xxxxxx">
      <inSequence>
            <property name="requestMsg" expression="json-eval($)"/>
            <property name="children" expression="json-eval($.children)"/>
           <property name="messageType" value="application/json" scope="axis2" type="STRING"></property> 
         <dbreport>
            <connection>
               <pool>
                  <driver>oracle.jdbc.OracleDriver</driver>
                  <url>jdbc:oracle:thin:@xxxxxxxxxx:1521/xxxxxx</url>
                  <user>xxxxxx</user>
                  <password>xxxxxx</password>
               </pool>
            </connection>
            <statement>
               <sql>INSERT INTO TABLE (CARDID )VALUES(?)</sql>
               <parameter expression="//CARDID/text()" type="CHAR"/>
            </statement>
         </dbreport> 
         <foreach id="foreach_1" expression="//children">
            <sequence>
                  <property name="PKID" expression="json-eval($.children.PKID)"/>
               <dbreport>
                  <connection>
                     <pool>
                        <driver>oracle.jdbc.OracleDriver</driver>
                        <url>jdbc:oracle:thin:@xxxxxxxxxxxxxx/xxxxxx</url>
                        <user>xxxxxx</user>
                        <password>xxxxxx</password>
                     </pool>
                  </connection>
                  <statement>
                     <sql>INSERT INTO TABLE_1 ( PKID )VALUES  ( ? )</sql>
                     <parameter expression="//PKID/text()" type="VARCHAR"/>
                  </statement>
               </dbreport>
            </sequence>
         </foreach>
         <respond/>
      </inSequence>
   </resource>
</api>

标签: oracleresponse

解决方案


推荐阅读