[teiid-issues] [JBoss JIRA] (TEIID-2006) Add a JDBC/ODBC statement to set the command payload

Mon Apr 23 15:55:18 EDT 2012

     [ https://issues.jboss.org/browse/TEIID-2006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-2006.
-----------------------------------

    Resolution: Done

Added support for SET PAYLOAD name value

A session scoped payload properties object will have the corresponding name value pair set.  The payload object is not fully session scoped.  It will be removed from the session when the XAConnection handle is closed / returned to the pool (assumes the use of TeiidDataSource).  The session scoped payload is superseded by the usage of TeiidStatement.setPayload.

Also added encryptRequests as a datasource/connection property.  When set to true, then a non-SSL connection using client encryption will also encrypt the request message and associated payload.  This is also useful in situations where the user SQL may be sensitive, but SSL is not enabled.

> Add a JDBC/ODBC statement to set the command payload
> ----------------------------------------------------
>
>                 Key: TEIID-2006
>                 URL: https://issues.jboss.org/browse/TEIID-2006
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Driver
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.0
>
>
> We currently lack a statement driven mechanism to set the command payload.  We should also provide an option to secure the payload in transit.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira