1 2 Previous Next 19 Replies Latest reply on Feb 6, 2012 9:41 PM by rareddy Go to original post
      • 15. Re: How to use Teiid DelegatingExecutionFactory
        rareddy

        Please find attached my translator and vdb file.

         

        Ramesh..

        • 16. Re: How to use Teiid DelegatingExecutionFactory
          gamvi01

          Hi Ramesh

           

          Its working independently but its not owrking with my applcation. Thanks for the help.

          • 17. Re: How to use Teiid DelegatingExecutionFactory
            gamvi01

            Hi Ramesh,

             

            I tried debugging my application. This is what i found. When the delegateName is embedded in a model the interceptor doesnt seem to work. Does Basedelegatingexecutionfactory intercepts deelgates which are not models ??

             

            Say for 1st case  as i dont have resultsetstore as a model - i executed query as select * from resultstore_id_seq  , In org.teiid.dqp.internal.datamgr.ConnectorWorkItem when you inspect  this.requestMsg the connectorName value is chorus_safety and

            SELECT g_0.ID, g_0.HASHCODE1, g_0.HASHCODE2, g_0.CREATEDDATE, g_0.DATA FROM "chorus-safety".RESULTSETSTORE AS g_0

             

            For the second case as resultsetstore is a model - i hav  to execute query select * from resultsetstore.resultstore_id_seq  connectorName value is resultsetstore and

             

            Working vdb :  Here resultsetore is not embedded in a model

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

             

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

             

               

                            <model type="PHYSICAL" visible="true" name="chorus-safety">

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

                    <source name="chorus-safety" connection-jndi-name="java:CHORUS-H2-RESULTSETSTORE-DS" translator-name="chorus-safety.delegated-translator"/>

                </model>

                            <translator type="h2" name="h2-translator"/>

                            <translator name="chorus-safety.delegated-translator" type="chorus-translator-safetyHarness">

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

                </translator>

            </vdb>

             

             

            Non working VDB:   Similar to Chorus – where resultsetstore model is created.

             

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

             

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

             

               

                            <model type="PHYSICAL" visible="true" name="chorus-safety">

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

                    <source name="chorus-safety" connection-jndi-name="java:CHORUS-H2-RESULTSETSTORE-DS" translator-name="chorus-safety.delegated-translator"/>

                </model>

            <model type="PHYSICAL" visible="true" name="resultsetstore">

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

                    <source name="resultsetstore" connection-jndi-name="java:CHORUS-H2-RESULTSETSTORE-DS" translator-name="h2"/>

                </model>

                            <translator type="h2" name="h2-translator"/>

                           

                            <translator name="chorus-safety.delegated-translator" type="chorus-translator-safetyHarness">

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

                </translator>

            </vdb>

            • 18. Re: How to use Teiid DelegatingExecutionFactory
              gamvi01

              Ramesh/Steve

               

              Do you have anycomments to add for my questions?

              • 19. Re: How to use Teiid DelegatingExecutionFactory
                rareddy

                I see no issues on my VDB. If you want you can add another model to the vdb.xml file I attached before and test.

                 

                Ramesh..

                1 2 Previous Next