How to convert nvarchar2 to string datatype in view using DDL approach

[govindarajs]

Hi,

I have created view in view model (using DDL approach) and pointing to oracle table, In the oracle table, the column data type as nvarchar2, but I need the same column and type as String in view, it does not allow me to create view with column type as String, it raise the below error, How to convert nvarchar2 to String in view?

TEIID31080 Viewmodel.testview validation error: The definition for Viewmodel.testview has the wrong type for column 1. Expected string, but was object

Note: In Model Approach (Teiid Designer), Teiid Designer is converted nvarchar2 to String automatically when we import the schema from Oracle

Thanks & Regards

Govindaraj Sanjeevi

[shawkins]

What version of Teiid are you using?

Older versions of Teiid did not properly import the nvarchar2 type - [TEIID-2281] Exception when updating Oracle NVARCHAR2 columns (Teiid embedded) - JBoss Issue Tracker

[govindarajs]

Currently we are using Teiid Server 8.7 with Jboss EAP 6.1

Here we are using DDL approach to create VDB, so we don't have source model, directly JDBC consider as a source model and write SQL queries in view model and deploy the VDB in the Teiid Server 8.7

[shawkins]

Actually this wasn't fully addressed until Teiid 8.10 [TEIID-3294] dynamic vdb imports nvarchar2 as object - JBoss Issue Tracker

[govindarajs]

Do we have any workaround for this issue in Teiid 8.7?

[shawkins]

You would have to define the metadata for the source table in ddl rather than just letting it import.  To do this you would exclude it from import, and used chained metadata to have both ddl and imported metadata - Metadata Repositories - Teiid 8.7 - Project Documentation Editor