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

    • % %
    • 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

      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

        1. data_map_issue_log.tar.gz
          16 kB
          Antonio Gagliardi
        2. screenshot-syndesis.png
          35 kB
          Antonio Gagliardi
        3. screenshot-syndesis-datamapissue.png
          101 kB
          Antonio Gagliardi
        4. syndesis-meta-2-wbjgm.log
          46 kB
          Antonio Gagliardi
        5. syndesis-server-1-9mm4h.log
          50 kB
          Antonio Gagliardi

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

                Created:
                Updated:
                Resolved: