1 Reply Latest reply on Sep 14, 2016 1:42 PM by Steven Hawkins

    CLOB data type

    Himanshu Kapoor Newbie

      Hi ,

       

      If i  create a VDB on top of Oracle DB having geometry data type. Would it be possible to fetch the data of this column by connecting to this VDB through teiid JDBC driver ? If yes what will be type CLOB ?

       

      Thanks

      Himanshu Kapoor

        • 1. Re: CLOB data type
          Steven Hawkins Master

          > If i  create a VDB on top of Oracle DB having geometry data type. Would it be possible to fetch the data of this column by connecting to this VDB through teiid JDBC driver ? If yes what will be type CLOB ?

           

          Prior to 8.10 you could retrieve the geometry column as a struct.  With 8.10 and later you can use the importer option useGeometryType to have the column imported as a Teiid Geometry type.  From a client perspective the Teiid geometry type can be used as a clob.