[jira] [Commented] (HIVE-12605) Implement JDBC Connection.isValid

["Thejas M Nair (JIRA)" <ji...@apache.org>]

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

Thejas M Nair commented on HIVE-12605:
--------------------------------------

The javadoc for the JDBC api says - "The driver shall submit a query on the connection or use some other mechanism that positively verifies the connection is still valid when this method is called. ".

We could use something lightweight 'read' operation to validate the connection. Maybe a 'set <config name>' , where it just prints the value of the config name.


> Implement JDBC Connection.isValid
> ---------------------------------
>
>                 Key: HIVE-12605
>                 URL: https://issues.apache.org/jira/browse/HIVE-12605
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2, JDBC
>            Reporter: Thejas M Nair
>              Labels: newbie, trivial
>
> http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#isValid(int) implementation in Hive JDBC driver throws "SQLException("Method not supported")".
> That is a method often used by connection pooling libraries.
> Thanks to [~yeeza] for raising this issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)