Glad you've got things working. FYI, you can also control the default of
auto commit across all connections through
the phoenix.connection.autoCommit property in your client-side
hbase-site.xml file.
James
On Mon, Apr 11, 2016 at 11:37 PM, F21 <[email protected]> wrote:
> Thanks, James! That was very helpful.
>
> For those interested, the PhoenixRuntime.java file is here:
> https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/util/PhoenixRuntime.java
>
> In my case, I used (JSON equivalent):
>
> {
> "AutoCommit": "true",
> "Consistency": "8",
>
> }
>
>
>
> On 12/04/2016 4:29 PM, James Taylor wrote:
>
>> This map corresponds to the properties in the
>> DriverManager.getConnection()
>> call [1]. The possible values are dependent on the particular driver with
>> which you're interacting. For Phoenix, these can be HBase connection
>> property/values (if a connection being opened needs to have different
>> values than the default configuration), or in support of other features
>> such as multi-tenancy (TenantId), the max time stamp for flashback queries
>> (CurrentSCN), and a few other not too well documented options (see
>> PhoenixRuntime.java).
>>
>> Thanks,
>> James
>>
>>
>> [1]
>>
>> https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html#getConnection(java.lang.String,%20java.util.Properties)
>>
>> On Mon, Apr 11, 2016 at 10:46 PM, F21 <[email protected]> wrote:
>>
>> The protobuf documentation for avatica says we can send a map along with
>>> the connection id when using an OpenConnectionRequest:
>>>
>>> https://calcite.apache.org/docs/avatica_protobuf_reference.html#openconnectionrequest
>>>
>>> Is there a list of keys that can go into the map? Perhaps this should be
>>> better documented.
>>>
>>> I tried sending a map (shown in JSON, but I was sending the golang
>>> protobuf equivalent):
>>> {
>>> "auto_commit": "true",
>>> "has_auto_commit": "true",
>>> "transaction_isolation": "8",
>>> }
>>>
>>> However, the connection was not opened with auto_commit set to true.
>>>
>>>
>>>
>
