phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Terrell <sterr...@oculus360.us>
Subject Re: Thin Client Commits?
Date Tue, 23 Feb 2016 01:20:14 GMT
Thanks for the response; I'll wait for 4.7.

On Mon, Feb 22, 2016 at 3:22 PM, Josh Elser <josh.elser@gmail.com> wrote:

> I only wired up commit/rollback in Calcite/Avatica in Calcite-1.6.0 [1],
> so I Phoenix-4.6 isn't going to have that in the binaries that you can
> download (Phoenix-4.6 is using 1.3.0-incubating). This should be included
> in the upcoming Phoenix-4.7.0.
>
> Sadly, I'm not sure why autoCommit=true wouldn't be working. I don't have
> any experience with the SQuirreL.
>
> [1] https://issues.apache.org/jira/browse/CALCITE-767
>
> Steve Terrell wrote:
>
>> I spoke too soon.  This is odd.  I'm using SQuirreL Client with the thin
>> 4.6 thin client driver, and sometimes the updates/deletes take effect,
>> and sometimes they don't.  Seems like when I make a new connection the
>> commits work, but when I go back to that same tab later, they don't.  I
>> could really use a clue, here, if anyone knows what is going on.
>>
>> Thanks again,
>>      Steve
>>
>> On Sun, Feb 21, 2016 at 9:56 AM, Steve Terrell <sterrell@oculus360.us
>> <mailto:sterrell@oculus360.us>> wrote:
>>
>>     I'm surprised that no one knew the answer to this, but I eventually
>>     figured out that I could set phoenix.connection.autoCommit to true
>>     in phoenix-4.6.0-HBase-0.98-bin/bin/hbase-site.xml , and then
>>     restarted the query server.  Passing the answer along…
>>
>>     Thanks,
>>          Steve
>>
>>     On Thu, Feb 18, 2016 at 9:35 AM, Steve Terrell
>>     <sterrell@oculus360.us <mailto:sterrell@oculus360.us>> wrote:
>>
>>         I found this page:
>>
>> http://apache-phoenix-user-list.1124778.n5.nabble.com/Thin-Client-Connection-Refused-td822.html
>>         that says "dbConnection.commit() is not supported" (in a
>>         discussion about thin client).
>>
>>         Does anyone know if this is true, and if so, why?
>>
>>         Thank you,
>>              Steve
>>
>>         On Wed, Feb 17, 2016 at 9:49 AM, Steve Terrell
>>         <sterrell@oculus360.us <mailto:sterrell@oculus360.us>> wrote:
>>
>>             It seems that when I
>>             use phoenix-4.6.0-HBase-0.98-thin-client.jar , that deletes
>>             and upserts do not take effect.  Is this expected behavior?
>>
>>             Thanks,
>>                  Steve
>>
>>
>>
>>
>>

Mime
View raw message