[teiid-issues] [JBoss JIRA] (TEIID-1952) Oracle native driver preparedstatement char parameters are required to be padded

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12670636#comment-12670636 ] 

Ramesh Reddy commented on TEIID-1952:
-------------------------------------

Looks like "setObject('foo', Types.FixedLength)" seems to also work. However no different than the setFixedChar you mentioned above.

Can we not determine the type in the simple case of constants and then do the expression value as you suggested? 
                
> Oracle native driver preparedstatement char parameters are required to be padded
> --------------------------------------------------------------------------------
>
>                 Key: TEIID-1952
>                 URL: https://issues.jboss.org/browse/TEIID-1952
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 7.6
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 7.7.1
>
>
> The ojdbc driver expects the method setFixedChar to be used to set char values regardless of their padding.  This does not occur with other drivers, such as the DataDirect Oracle JDBC.

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