0 Replies Latest reply on Jul 11, 2014 4:05 PM by Michael Farwell

    Teiid MongoDB translator varbinary type support

    Michael Farwell Newbie

      Does the Teiid MongoDB translator support the varbinary type?

       

      Versions:

      Teiid 8.8

      MongoDB 2.4

       

      vdb.xml

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

      <vdb name="tracks" version="1">

        <model name="tracks">

          <source name="tracks" translator-name="mongodb" connection-jndi-name="java:/mongoDS"/>

          <metadata type="DDL"><![CDATA[

            CREATE FOREIGN TABLE  track_points (

              name varchar(25),

              id integer,

              ts timestamp,

              uuid varbinary(3)

            )

            OPTIONS(UPDATABLE 'TRUE');]]>

          </metadata>

        </model>

       

        <translator name="mongodb" type="mongodb">

           <property name="SupportsDirectQueryProcedure" value="true"/>

        </translator>

      </vdb>

       

       

      db.track_points.find()

      { "_id" : ObjectId("53c03fe86c2d58b8c581ff80"), "uuid" : BinData(3,"FKKq1/oBQKSKgAQkK5Ru5A=="), "name" : "point 1", "id" : 1, "ts" : ISODate("2013-01-01T00:00:01Z") }

       

      Query:

      select * from track_points


      Error:

      TEIID10076 Invalid conversion from type class java.lang.Object with value 'a44001fa-d7aa-a214-e46e-942b2404808a' to type class org.teiid.core.types.BinaryType