[jira] [Commented] (CALCITE-4970) Avatica ResultSet getObject with class argument fails unnecessarily

["Knut Forkalsrud (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17467046#comment-17467046 ] 

Knut Forkalsrud commented on CALCITE-4970:
------------------------------------------

Pull request: https://github.com/apache/calcite-avatica/pull/170

> Avatica ResultSet getObject with class argument fails unnecessarily
> -------------------------------------------------------------------
>
>                 Key: CALCITE-4970
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4970
>             Project: Calcite
>          Issue Type: Improvement
>          Components: avatica
>    Affects Versions: avatica-1.20.0
>            Reporter: Knut Forkalsrud
>            Priority: Minor
>
> The default implementation of Avatica's Cursor method
> {{public <T> T getObject(Class<T> type) throws SQLException}}
> thrown an exception about not being able to convert. However, there is the trivial case when no conversion is necessary. I propose returning the same value as {{getObject()}} does, when that's an acceptable type.
>  
> The background for this is our experience with different JDBC drivers. Our in-house "query master" tries to visualize result sets. We use {{ResultSetMetaData.getColumnTypeName}} to figure out which type to expect. Some drivers don't necessarily produce objects of the same type when we call {{{}getObject{}}}, but they do convert to the right type when we call the method with the class as an argument.
>  
> Pull request forthcoming.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)