Need to pass custom properties from JDBC connection to Translator.

[jamit]

Hi,

We have a requirement to pass some custom properties to be set on the jdbc connection and would be passed to the teiid(8.3 final) layer and all upto the custom translator layer.

The properties would be then be used by the translator to do some decision making.

These properties would be set by the jdbc client code and the values may differ from connection to connection.

for e.g

Properties object would contain:

PropKey              PropValue

1) ScrollLock        TRUE

2) PrintScreen       FALSE

and this would be sent to get jdbc connection,using the   final Connection connection = DriverManager.getConnection(url,prop);

the intention is these custom properties would go all upto the custom translator.

Did debug through the Teiid code and figured out that a new connection is created by WrappedConnectionFactory within teiid, for the translator, during query execution,and hence the properties dont reach the translator.

I somehow need to have these properties passed on via the executionContect or the BasicConnection or something else:) to the translator.

I wanted to know if there is an existing way to do this in the current teiid environment?

Thanks

Amit

[rareddy]

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..

[shawkins]

To 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

[jamit]

Thanks guys for prompt reply ,I checked the setPayload method and it suits the purpose.

[kchen007]

Does ODBC support similar custom properties?

thanks

Kevin

[rareddy]

SET PAYLOAD  statement will work in both JDBC and ODBC.

[kchen007]

Thanks.