Loading...

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: fuse-7.6-GA
Affects Version/s: fuse-7.4-GA
Component/s: Fuse Online
Labels:
- reminded
- verified
Environment:
- Fuse Online 1.7.25
- Openshift 3.11
- Oracle jdbc driver 12.1.0.2.0

GSS Priority:
Target Release:

fuse-7.6-GA
Git Pull Request:
https://github.com/syndesisio/syndesis/pull/7101
Steps to Reproduce:
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