You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Steve Terrell <st...@oculus360.us> on 2016/02/17 16:49:41 UTC
Thin Client Commits?
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
Re: Thin Client Commits?
Posted by Steve Terrell <st...@oculus360.us>.
Thanks for the response; I'll wait for 4.7.
On Mon, Feb 22, 2016 at 3:22 PM, Josh Elser <jo...@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
>> <ma...@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 <ma...@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 <ma...@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
>>
>>
>>
>>
>>
Re: Thin Client Commits?
Posted by Josh Elser <jo...@gmail.com>.
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
> <ma...@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 <ma...@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 <ma...@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
>
>
>
>
Re: Thin Client Commits?
Posted by Steve Terrell <st...@oculus360.us>.
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 <st...@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 <st...@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 <st...@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
>>>
>>
>>
>
Re: Thin Client Commits?
Posted by Steve Terrell <st...@oculus360.us>.
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 <st...@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 <st...@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
>>
>
>
Re: Thin Client Commits?
Posted by Steve Terrell <st...@oculus360.us>.
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 <st...@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
>