1 Reply Latest reply: Jul 16, 2014 1:35 PM by user11274260 RSS

    Issue while invoking BS which is integrated with JCA adapter.

    bkumar1

      Hello,

      I am having an issue while invoking BS which is further making a call to JCA adapter.. result of call is coming but having entry line in each element. Here is the project design

       

      1. Configured a DB package having multiple fields and few of them are as CHAR ( 1 BYTE).

      2. Generated a JCA file based DB package.

      3. Configured this JCA to my BS.

      While invoking BS, call is going through to DB package and return results. 

       

      Fields which are defined as CHAR ( 1 byte) in DB are returning result like

      <P_VALIDATE_RESPONSE>

      Y

      </P_VALIDATE_RESPONSE>

      <P_PAYLOAD_LOGGING>

      Y

      </P_PAYLOAD_LOGGING>

      <P_ROUTE_TO>

      P

      </P_ROUTE_TO>

       

      When I check the size of each return result , its coming as 3267(something like this).. since its a CHAR(1 byte) it should not be that high....

       

      Issue.. I am running a compare and that failing.

       

       

      but ideally this should come like below

      <P_VALIDATE_RESPONSE>Y</P_VALIDATE_RESPONSE>

      <P_PAYLOAD_LOGGING>Y</P_PAYLOAD_LOGGING>

      <P_ROUTE_TO>P</P_ROUTE_TO>

       

       

      in XSD these element are defined as

      <element name="P_VALIDATE_RESPONSE" type="string" db:index="8" db:type="CHAR" minOccurs="0" nillable="true"/>

      <element name="P_PAYLOAD_LOGGING" type="string" db:index="9" db:type="CHAR" minOccurs="0" nillable="true"/>

      <element name="P_ROUTE_TO" type="string" db:index="10" db:type="CHAR" minOccurs="0" nillable="true"/>

       

       

      Could someone please help me whats wrong here.