Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-12159

Fuse Online: parsing SQL command with numeric parameter fail with error "Stream has already been closed..."

    XMLWordPrintable

Details

    • % %
    • Hide
      • Create a table with the following DDL:
        CREATE TABLE persons 
        ( 
            person_id  NUMBER generated BY DEFAULT AS identity, 
            first_name VARCHAR2(50) NOT NULL, 
            last_name  VARCHAR2(50) NOT NULL, 
            PRIMARY KEY(person_id) 
        );
        
      • Create Connection to an Oracle DB (jdbc as extention)
      • Create Integration step with DB and the following sql:
          select * from PERSONS where PERSON_ID = :#param
        
      Show
      Create a table with the following DDL: CREATE TABLE persons ( person_id NUMBER generated BY DEFAULT AS identity , first_name VARCHAR2 (50) NOT NULL , last_name VARCHAR2 (50) NOT NULL , PRIMARY KEY (person_id) ); Create Connection to an Oracle DB (jdbc as extention) Create Integration step with DB and the following sql: select * from PERSONS where PERSON_ID = :#param

    Description

      Parsing of a sql with a numeric parameter with and Oracle Connector fail with the following error:

      Stream has already been closed. Unable to fetch and process
      

      Attachments

        1. data_map_issue_log.tar.gz
          16 kB
        2. screenshot-syndesis.png
          screenshot-syndesis.png
          35 kB
        3. screenshot-syndesis-datamapissue.png
          screenshot-syndesis-datamapissue.png
          101 kB
        4. syndesis-meta-2-wbjgm.log
          46 kB
        5. syndesis-server-1-9mm4h.log
          50 kB
        6. TestIn-export_datamapissue.zip
          3.33 MB

        Activity

          People

            christoph.deppisch Christoph Deppisch
            rhn-support-agagliar Antonio Gagliardi
            Stefan Veres Stefan Veres
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: