1 2 Previous Next 19 Replies Latest reply on Feb 6, 2012 9:41 PM by Ramesh Reddy Go to original post
      • 16. Re: How to use Teiid DelegatingExecutionFactory
        Vineela Gampa Novice

        Hi Ramesh

         

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

        • 17. Re: How to use Teiid DelegatingExecutionFactory
          Vineela Gampa Novice

          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
            Vineela Gampa Novice

            Ramesh/Steve

             

            Do you have anycomments to add for my questions?

            • 19. Re: How to use Teiid DelegatingExecutionFactory
              Ramesh Reddy Master

              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