Re: Is there a list of valid properties for avatica's OpenConnectionRequest info map?

[F21]

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.gro...@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.