WSO2EI DataSource for IFS Database

IFS_DATAService.dbs

<data name="IFSAPP9PROD" serviceNamespace="IFS" transports="http https local">
   <description>IFS App9 Production</description>
   <config enableOData="false" id="IFSAPP9PROD">
      <property name="driverClassName">oracle.jdbc.driver.OracleDriver</property>
      <property name="url">jdbc:oracle:thin:@<DBHOST>:1521:<SID></property>
      <property name="username"><APPOWNER></property>
      <property name="password"><APPOWNER_PW></property>
   </config>
   <query id="SELECT_ALL_WO_QUERY" useConfig="IFSAPP9PROD">
      <sql>select CONTRACT, ORG_CODE, MCH_CODE, MCH_CODE_DESCRIPTION, MCH_CODE_CONTRACT, WO_NO, REG_DATE, ERR_DESCR, PLAN_S_DATE, REPORTED_BY, PART_NO, STATE from ACTIVE_SEPARATE</sql>
      <result element="WOCollection" rowName="WORKORDER">
         <element column="CONTRACT" name="CONTRACT" xsdType="xs:string"/>
         <element column="ORG_CODE" name="ORG_CODE" xsdType="xs:string"/>
         <element column="MCH_CODE" name="MCH_CODE" xsdType="xs:string"/>
         <element column="MCH_CODE_DESCRIPTION" name="MCH_CODE_DESCRIPTION" xsdType="xs:string"/>
         <element column="MCH_CODE_CONTRACT" name="MCH_CODE_CONTRACT" xsdType="xs:string"/>
         <element column="REG_DATE" name="REG_DATE" xsdType="xs:date"/>
         <element column="ERR_DESCR" name="ERR_DESCR" xsdType="xs:string"/>
         <element column="PLAN_S_DATE" name="PLAN_S_DATE" xsdType="xs:date"/>
         <element column="REPORTED_BY" name="REPORTED_BY" xsdType="xs:string"/>
         <element column="PART_NO" name="PART_NO" xsdType="xs:string"/>
         <element column="STATE" name="STATE" xsdType="xs:string"/>
      </result>
   </query>
   <query id="SELECT_WO_BY_STATE_QUERY" useConfig="IFSAPP9PROD">
      <sql>select CONTRACT, ORG_CODE, MCH_CODE, MCH_CODE_DESCRIPTION, MCH_CODE_CONTRACT, WO_NO, REG_DATE, ERR_DESCR, PLAN_S_DATE, REPORTED_BY, PART_NO, STATE from ACTIVE_SEPARATE WHERE STATE=?</sql>
      <result element="WOCollection" rowName="WORKORDER">
         <element column="CONTRACT" name="CONTRACT" xsdType="xs:string"/>
         <element column="ORG_CODE" name="ORG_CODE" xsdType="xs:string"/>
         <element column="MCH_CODE" name="MCH_CODE" xsdType="xs:string"/>
         <element column="MCH_CODE_DESCRIPTION" name="MCH_CODE_DESCRIPTION" xsdType="xs:string"/>
         <element column="MCH_CODE_CONTRACT" name="MCH_CODE_CONTRACT" xsdType="xs:string"/>
         <element column="REG_DATE" name="REG_DATE" xsdType="xs:date"/>
         <element column="ERR_DESCR" name="ERR_DESCR" xsdType="xs:string"/>
         <element column="PLAN_S_DATE" name="PLAN_S_DATE" xsdType="xs:date"/>
         <element column="REPORTED_BY" name="REPORTED_BY" xsdType="xs:string"/>
         <element column="PART_NO" name="PART_NO" xsdType="xs:string"/>
         <element column="STATE" name="STATE" xsdType="xs:string"/>
      </result>
      <param name="STATE" sqlType="STRING"/>
   </query>
   <operation name="SELECT_ALL_WO_QUERY_OPERATION">
      <call-query href="SELECT_ALL_WO_QUERY"/>
   </operation>
   <operation name="SELECT_WO_BY_STATE_OPERATION">
      <call-query href="SELECT_WO_BY_STATE_QUERY">
         <with-param name="STATE" query-param="STATE"/>
      </call-query>
   </operation>
</data>