-
1. Re: Need to pass custom properties from JDBC connection to Translator.
rareddy Apr 15, 2013 10:46 AM (in response to jamit)Amit,
Please see CommandPayload at https://docs.jboss.org/author/display/teiid830final/Statement+Extensions. Here using the TeiidStatement object you can insert a payload object ex: properties object and then can read in your custom translator through ExecutionContext.getCommandPayload object.
Ramesh..
-
2. Re: Need to pass custom properties from JDBC connection to Translator.
shawkins Apr 15, 2013 10:51 AM (in response to jamit)1 of 1 people found this helpfulTo further what Ramesh said, you can also use SET PAYLOAD statements - https://docs.jboss.org/author/display/TEIID/SET+Statement that will build up a Properties object as the command payload if you don't want to use the TeiidStatement interface.
Also, Teiid 8.4 has the concept of session variables - see https://issues.jboss.org/browse/TEIID-1092 that are available via the Execution/CommandContext.
Steve
-
3. Re: Need to pass custom properties from JDBC connection to Translator.
jamit Apr 16, 2013 3:28 AM (in response to rareddy)Thanks guys for prompt reply ,I checked the setPayload method and it suits the purpose.
-
4. Re: Need to pass custom properties from JDBC connection to Translator.
kchen007 Apr 16, 2013 5:43 PM (in response to jamit)Does ODBC support similar custom properties?
thanks
Kevin
-
5. Re: Need to pass custom properties from JDBC connection to Translator.
rareddy Apr 16, 2013 6:10 PM (in response to kchen007)SET PAYLOAD statement will work in both JDBC and ODBC.
-
6. Re: Need to pass custom properties from JDBC connection to Translator.
kchen007 Apr 17, 2013 4:03 PM (in response to rareddy)Thanks.