Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2281

Exception when updating Oracle NVARCHAR2 columns (Teiid embedded)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.2
    • 8.1
    • JDBC Connector
    • None
    • Hide

      1. Deploy a vdb containing NVARCHAR2 column
      2. Issue a SQL Statement "update TEST set nvarchar2_col='ABC'"
      3. Execute SQL

      Show
      1. Deploy a vdb containing NVARCHAR2 column 2. Issue a SQL Statement "update TEST set nvarchar2_col='ABC'" 3. Execute SQL

      The TEIID jdbc driver returns SQLType of “JAVA_OBJECT” for NVARCHAR, so it throws and exception in Oracle JDBC call “setObject(i,param,TYPE.JAVA_OBJECT)”.

      We can reproduce the same exception using the Oracle jdbc driver by making the same setObject call.

      This is happening using Teiid embedded but also happens with a dynamic vdb in XML. We have not tried a designer-created vdb.

      Discussion:
      https://community.jboss.org/message/772860#772860
      Possibly related:
      https://issues.jboss.org/browse/TEIIDDES-179

              rhn-engineering-shawkins Steven Hawkins
              ileitch I Leitch (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: