Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Wed, 12 Aug 2015 04:23:46 +0000 (UTC)
From: "Kylin Soong (JIRA)" <jira@apache.org>
To: dev@phoenix.incubator.apache.org
Message-ID: <JIRA.12855439.1439353378000.41294.1439353426352@Atlassian.JIRA>
In-Reply-To: <JIRA.12855439.1439353378000@Atlassian.JIRA>
References: <JIRA.12855439.1439353378000@Atlassian.JIRA>
 <JIRA.12855439.1439353378991@arcas>
Subject: [jira] [Created] (PHOENIX-2176) JDBC AutoCommit is true, but can
 not AutoCommit the UPSERT
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Kylin Soong created PHOENIX-2176:
------------------------------------

             Summary: JDBC AutoCommit is true, but can not AutoCommit the UPSERT
                 Key: PHOENIX-2176
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2176
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.2.1
         Environment: - Phoenix 4.2.1
- hbase-0.98.8-hadoop2
            Reporter: Kylin Soong


Create TABLE DDL as below
{code}
CREATE TABLE IF NOT EXISTS \"smalla5\"(\"ROW_ID\" INTEGER PRIMARY KEY, \"cf5\".\"city\" VARCHAR)
{code}

Execute code
{code}
...
Connection conn = ...
boolean isAutoCommit = conn.getAutoCommit();
System.out.println(isAutoCommit);
{code}
the output is 'true', this hint the AutoCommit is enabled, but the UPSERT not save to table, for example, continue execute
{code}
execute(conn, "UPSERT INTO  \"smalla5\" VALUES(6, '66')", false);
execute(conn, "SELECT * FROM \"smalla5\"", false);
close(conn);
{code}
the query result is empty.

If set AutoCommit to false, then commit manually then the UPSERT save to Table,for example
{code}
conn.setAutoCommit(false);
execute(conn, "UPSERT INTO  \"smalla5\" VALUES(5, '5')", false);
conn.commit();
conn.setAutoCommit(isAutoCommit);
execute(conn, "SELECT * FROM \"smalla5\"", false);
close(conn);
{code}

Does this should be a bug?


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