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

    CLOB data type

    capoorhimanshu

      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
          shawkins

          > 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.