Return-Path: 
 <issues-return-26454-apmail-hive-issues-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-issues-archive@minotaur.apache.org
Delivered-To: apmail-hive-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id BEF0C18443
	for <apmail-hive-issues-archive@minotaur.apache.org>;
 Mon,  7 Dec 2015 17:27:37 +0000 (UTC)
Received: (qmail 16358 invoked by uid 500); 7 Dec 2015 17:27:15 -0000
Delivered-To: apmail-hive-issues-archive@hive.apache.org
Received: (qmail 16308 invoked by uid 500); 7 Dec 2015 17:27:11 -0000
Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@hive.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@hive.apache.org>
List-Post: <mailto:issues@hive.apache.org>
List-Id: <issues.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list issues@hive.apache.org
Received: (qmail 16296 invoked by uid 99); 7 Dec 2015 17:27:11 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Dec 2015 17:27:11 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 290272C14F0
	for <issues@hive.apache.org>; Mon,  7 Dec 2015 17:27:11 +0000 (UTC)
Date: Mon, 7 Dec 2015 17:27:11 +0000 (UTC)
From: "Thejas M Nair (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12919779.1449508987000.291173.1449509231164@Atlassian.JIRA>
In-Reply-To: <JIRA.12919779.1449508987000@Atlassian.JIRA>
References: <JIRA.12919779.1449508987000@Atlassian.JIRA>
 <JIRA.12919779.1449508987481@arcas>
Subject: [jira] [Commented] (HIVE-12605) Implement JDBC Connection.isValid
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


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