[teiid-issues] [JBoss JIRA] (TEIID-1651) Due to a change in the JDBC spec on how the use of "AS" in the select statement will now be returned in the getColumnLabel of the ResultSetMetadata, Teiid must provide backwards support

Wed Aug 15 10:08:14 EDT 2012

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

Steven Hawkins updated TEIID-1651:
----------------------------------

    Affects: Documentation (Ref Guide, User Guide, etc.),Compatibility/Configuration,Release Notes

    
> Due to a change in the JDBC spec on how the use of "AS" in the select statement will now be returned in the getColumnLabel of the ResultSetMetadata, Teiid must provide backwards support 
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1651
>                 URL: https://issues.jboss.org/browse/TEIID-1651
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver
>    Affects Versions: 7.4.1
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>            Priority: Blocker
>             Fix For: 7.4.1, 7.5
>
>
> Teiid has already applied a fix to support the JDBC spec change for when an alias is used in the select clause.   The spec change says the "AS" name will now be returned when getColumnLabel() is called, instead of getColumnName().   Unfortunately, this breaks backwards compatibility.    To resolve the issue, the JDBC driver, to provide support for backwards compatibility, can allow the user to specify the useJDBC4ColumnNameAndLabelSemantics=true (default is false) property on the url (this is the recommended spec property). 

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