Dynamic VDB with Java UDF not pulling data

[mubasharahmad]

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

[tom9729]

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

[mubasharahmad]

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