calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From F21 <f21.gro...@gmail.com>
Subject Re: Is there a list of valid properties for avatica's OpenConnectionRequest info map?
Date Tue, 12 Apr 2016 06:37:31 GMT
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 <f21.groups@gmail.com> 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.
>>
>>


Mime
View raw message