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 <sterr...@oculus360.us
<mailto:sterr...@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
<sterr...@oculus360.us <mailto:sterr...@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
<sterr...@oculus360.us <mailto:sterr...@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