question Re: HBase/Phoenix - How to specify autocommit in JDBC URL ? in Archives of Support Questions (Read Only)

HBase/Phoenix - How to specify autocommit in JDBC URL ?

dineshc — Mon, 08 May 2017 22:07:37 GMT

I want to avoid setting auto-commit=true by default, thus I am not adding the required property in hbase-site.xml.

However, I want to add auto commit property to the jdbc url so that I can get a connection with autocommit=true on need basis.

I am not able to find how to add this property to connection url.

I have a kerberized cluster and I an using the following url:

jdbc:phoenix[:zk_quorum][:zk_port][:zk_hbase_path][:headless_keytab_file:principal]

I also tried the following approach but it did not connect due to malformed url:

jdbc:phoenix[:zk_quorum][:zk_port][:zk_hbase_path][:headless_keytab_file:principal][:AutoCommit=true]

Re: HBase/Phoenix - How to specify autocommit in JDBC URL ?

sreeviswa_athic — Mon, 08 May 2017 22:11:19 GMT

Replace the colon with a semi-colon in jdbc url and this will work:jdbc:phoenix[:zk_quorum][:zk_port][:zk_hbase_path][:headless_keytab_file:principal] [;autocommit=true]

Re: HBase/Phoenix - How to specify autocommit in JDBC URL ?

mqureshi — Mon, 08 May 2017 22:13:50 GMT

@Dinesh Chitlangia

you can use PhoenixRuntime.AUTO_COMMIT_ATTRIB as supported in following class.

https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/util/PhoenixRuntime.java

Please see the following JIRA to make sure you are using the version of Phoenix that supports it.

https://issues.apache.org/jira/browse/PHOENIX-1559

Re: HBase/Phoenix - How to specify autocommit in JDBC URL ?

dineshc — Tue, 09 May 2017 02:52:54 GMT

Thank you. This solved the problem.