open-jbi-components
  1. open-jbi-components
  2. OPEN_JBI_COMPONENTS-595

Select Statements with no WHERE generate a Required Empty Input Sequence

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Blocker Blocker
    • Resolution: Unresolved
    • Affects Version/s: current
    • Fix Version/s: milestone 1
    • Component/s: SQL SE
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      595

      Description

      Creating an SQLApp with the following query causes an empty input parameter to
      be generated in the WSDL.

      SELECT * FROM PERSON

      Generates :

      <xsd:element name="PersonSelectRequest">
      <xsd:complexType>
      <xsd:sequence/>
      </xsd:complexType>
      </xsd:element>
      <xsd:element name="PersonSelectResponse">
      <xsd:complexType>
      <xsd:sequence>
      <xsd:element maxOccurs="unbounded" ref="record"/>
      </xsd:sequence>
      </xsd:complexType>
      </xsd:element>
      <xsd:element name="record">
      <xsd:complexType>
      <xsd:sequence>
      <xsd:element name="PERSONID" type="xsd:int"/>
      <xsd:element name="NAME" type="xsd:string"/>
      <xsd:element name="JOBTITLE" type="xsd:string"/>
      <xsd:element name="FREQUENTFLYER" type="xsd:short"/>
      <xsd:element name="LASTUPDATED" type="xsd:string"/>
      </xsd:sequence>
      </xsd:complexType>
      </xsd:element>

      When you attempt to use this within a BPEL Module and then execute it fails
      because the input is not initialised but you can not initialise it because their
      is nothing to pass. This should not be generated if no input is required.

      This can be reproduce by simply creating an SQLApp that uses the above select
      against the standard JavaDB Travel database.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            open-jbi-components-issues
            Reporter:
            andrewhopkinson
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: