Thanks for the response; I'll wait for 4.7. On Mon, Feb 22, 2016 at 3:22 PM, Josh Elser <[email protected]> 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 <[email protected] >> <mailto:[email protected]>> 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 >> <[email protected] <mailto:[email protected]>> 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 >> <[email protected] <mailto:[email protected]>> 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 >> >> >> >> >>
