Custom Translator

[anilnair]

Hi All,

I am trying to achieve a scenario as mentioned below

1.  I have  to execute a query .but before execution and after execution of the query I need a stored procedure to be executed and this stored procedure is expecting a parameter that is passed from the teiid client, and the stored procedure does not return any value

The version of teiid that i am using for evaluation is Teiid 8.10.1 ,database :Sql server: driver is Jtds.

After digging through the documentation I am assuming  I should be using custom translator.

So keeping  the above thought in mind i have setup the environment for the custom translator development(Maven setup). The questions I have

1. I would have to execute the stored procedure and query with the same connection

2. In the custom translator with(understanding from documentation) I have to use ResultSetExecution for the query and Procedure Execution for the stored procedures in the ExecutionFactory class. So I was thinking if there is a way I can combine this together?

Any pointers on this direction would be great.

Thanks

Anil

[rareddy]

I think you can write a "delegate" translator as described in [1] & [2] Here you need to be delegating to the SQLServer translator. You need to override the

public ResultSetExecution createResultSetExecution(QueryExpression command, ExecutionContext executionContext, RuntimeMetadata metadata, Connection conn)

method, and write delegate methods for that such that the extra procedure call is invoked. As per the property from client, you can find that ExecutionContext class's command payload method. You set the payload on the statement, see TeiidStatement class.

[1] https://docs.jboss.org/author/display/TEIID/Delegating+Translators

[2] Delegating Translator - Teiid 8.11 (draft) - Project Documentation Editor

[anilnair]

Hi Ramesh,

Sorry could not understand this part

As per the property from client, you can find that ExecutionContext class's command payload method. You set the payload on the statement, see TeiidStatement class.

I did  see executioncontext.GetExecutionPayload method but not sure how I would pass values from client or rather I would I set the execution context from the client

Thanks

Anil

[rareddy]

https://github.com/teiid/teiid/blob/master/client/src/main/java/org/teiid/jdbc/TeiidStatement.java#L102

[anilnair]

Thank you Ramesh