-
15. Re: How to use Teiid DelegatingExecutionFactory
rareddy Feb 2, 2012 9:29 AM (in response to gamvi01)Please find attached my translator and vdb file.
Ramesh..
-
myvdb-vdb.xml 548 bytes
-
16. Re: How to use Teiid DelegatingExecutionFactory
gamvi01 Feb 2, 2012 6:45 PM (in response to rareddy)Hi Ramesh
Its working independently but its not owrking with my applcation. Thanks for the help.
-
jboss-beans.xml 1.1 KB
-
SafetyHarnessExecutionFactory.java.zip 982 bytes
-
-
17. Re: How to use Teiid DelegatingExecutionFactory
gamvi01 Feb 3, 2012 12:49 PM (in response to 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 Feb 6, 2012 6:39 PM (in response to gamvi01)Ramesh/Steve
Do you have anycomments to add for my questions?
-
19. Re: How to use Teiid DelegatingExecutionFactory
rareddy Feb 6, 2012 9:41 PM (in response to gamvi01)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..