2 Replies Latest reply on Mar 21, 2014 8:37 AM by Mubasshar Ahmad

    Dynamic VDB with Java UDF not pulling data

    Mubasshar Ahmad Newbie

      Hi Friends,

       

      Here is a dynamic vdb attached herewith for the reference. It was working fine before adding UDF functionality but after following this tutorial (Support for User-Defined Functions (Non-Pushdown) - Teiid 8.7 (draft) - Project Documentation Editor), it is totally silent. Dont know where is the problem.

       

      Please help in this regard and oblige.

       

      Regards,

       

      Mubasshar Ahmad

        • 1. Re: Dynamic VDB with Java UDF not pulling data
          Tom Arnold Novice

          Could you also post the non-UDF version that was working?

           

          Should the delegate name be something besides "sample"?

           

          eg.


          <translator name="delegate" type="interceptor">
                <property name="delegateName" value="oracle" />
          </translator>

           

          Tom

          • 2. Re: Dynamic VDB with Java UDF not pulling data
            Mubasshar Ahmad Newbie

            Hi Tom,

             

            Thanks for your reply.

             

            Actually "sample" is just the name of my custom translator which is basically written as a wrapper on oracle.

             

            I am attaching the working vdb file for your reference.

             

            ============================ START =============================

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

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

                <description>Sample Dynamic VDB</description>

             

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

               

             

                <model name="sample" type="VIRTUAL">

             

                    <property name="importer.importKeys" value="true"/>

                    <property name="importer.useFullSchemaName" value="false"/>

                    <property name="importer.widenUnsignedTypes" value="false"/>

                    <property name="importer.schemaPattern" value="%"/>

                    <property name="supports-multi-source-bindings" value="true"/>

                    <property name="multisource.columnName" value="TEIID_MULTI_DATA_SOURCE_COLUMN"/>

                    <property name="multisource.addColumn" value="true"/>

                    <source translator-name="delegate" connection-jndi-name="java:/SAMPLE/1000.1.0" name="SAMPLE" />

                   

                </model>

                <translator name="delegate" type="interceptor">

                    <property name="delegateName" value="sample" />

                   </translator>

            </vdb>

            ===================== END =======================================

             

             

            Thanks