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

Exception when updating Oracle NVARCHAR2 columns (Teiid embedded)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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

    Description

      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

      Attachments

        Issue Links

          clones

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-1531 Exception when updating Oracle NVARCHAR2 columns

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: