We have more than one cluster. One is using Phoenix 3 and one is using Phoenix 4. Here is what we have found: the latest DB Visualizer works with the official Phoenix 4.0 release from April even. But the problem is you cannot have both a Phoenix 3 connection and a Phoenix 4+ connection going on at the same time. If the Phoenix 3 connection happens first, DB Visualizer will erroneously use the Phoenix 3 driver to attempt the Phoenix 4+ connection. That is why people were seeing the infamous  "Not a host:port pair: PBUF" exception.


Mike
________________________________________
From: Mike Friedman <Mike.Friedman@ds-iq.com>
Sent: Friday, August 01, 2014 1:09 PM
To: dev@phoenix.apache.org
Subject: RE: Phoenix and CDH 5.1 success

Here's where I got it from:  Let me know if there is a better place to get the Phoenix 4 source:  http://www.trieuvan.com/apache/incubator/phoenix/phoenix-4.0.0-incubating/

-----Original Message-----
From: Gabriel Reid [mailto:gabriel.reid@gmail.com]
Sent: Friday, August 01, 2014 12:41 PM
To: dev@phoenix.apache.org
Subject: Re: Phoenix and CDH 5.1 success

Thanks for the follow-up Mike.

Just to clarify, did you build 4.0 from the 4.0 release tag, or the current head of the 4.0 branch? The reason I ask is because
PHOENIX-966 [1] fixed some issues with Phoenix being used as a "normal" JDBC driver in terms of classpath issues. As part of that ticket, Phoenix was also successfully tested with DbVisualizer.
PHOENIX-966 isn't in the 4.0 release, but it is available in the head of the 4.0 branch, and will be present in the 4.1 release.

Could you give a bit more info on the kind of issue (errors or stack
traces) you're currently getting when trying to connection with DbVisualizer?

Thanks,

Gabriel

1. https://issues.apache.org/jira/browse/PHOENIX-966

On Fri, Aug 1, 2014 at 8:00 PM, Mike Friedman <Mike.Friedman@ds-iq.com> wrote:
> I would also like to report that we now have Phoenix working with Java JDBC as well, by following the steps that the sqlline source code uses to connect. I have filed a support request to DB Visualizer to look into why their product has a problem connecting to the driver.
>
>
> Mike
>
> -----Original Message-----
> From: Mike Friedman [mailto:Mike.Friedman@ds-iq.com]
> Sent: Thursday, July 31, 2014 4:56 PM
> To: dev@phoenix.apache.org; dev@phoenix.incubator.apache.org
> Subject: Phoenix and CDH 5.1 success
>
> I would like to report that we got Phoenix and CDH 5.1 working. In the end, we built 4.0 from the sources, specifying Hadoop profile 2. We did not have to do any kludgy thing. Sqlline and Squirrel work fine. Pig works fine. However, DB Visualizer does not work. We will file a bug with them. Also, we found Java applications using JDBC are not working right now. However, since sqlline is open source, my plan is to study the sqlline source code and change the way we do the database connection to mimic what sqlline does, and that will get those Java applications going again.
>
> I want to thank members of the Phoenix community for their reports of success and for specific suggestions they provided.
>
>
>
> Mike