Hi Russell, Just a naive question, Are you able to connect to HBase via HBase shell or any other HBase client from that node? I have seen this kind of behavior when the client does not have the HBase cluster conf in its classpath.
Thanks, Anil Gupta On Wed, Jun 25, 2014 at 10:51 PM, Russell Jurney <[email protected]> wrote: > HBase is alive, and I can connect via sqlline from the same host. > /etc/hosts has entries for each host of the quorum. > > Logs... no logs generated by this code: > > import java.sql.Connection; > import java.sql.DriverManager; > import java.sql.Statement; > import com.salesforce.phoenix.jdbc.PhoenixDriver > > #Class.forName("com.salesforce.phoenix.jdbc.PhoenixDriver") > > Java::com.salesforce.phoenix.jdbc.PhoenixDriver > DriverManager.registerDriver("com.salesforce.phoenix.jdbc.PhoenixDriver") > conn = DriverManager.get_connection("jdbc:phoenix:hiveapp1,hiveapp2:2181") > > <hang forever> > > > :( > ᐧ > > > On Wed, Jun 25, 2014 at 9:09 PM, Alex Kamil <[email protected]> wrote: > >> well, I'd chk a few things: >> - enable logger on the client to see if there are any exceptions - >> Logger.getRootLogger().setLevel(Level.DEBUG); >> - chk if hbase is alive, if there are any errors in the hbase logs, if >> you can access hbase master url, or hbase shell without issues, >> - see if you can connect with sqlline locally, >> - if you are connecting from this client machine for the first time, make >> sure /etc/hosts has the ip address of zookeeper quorum used by hbase >> >> >> >> >> >> On Wed, Jun 25, 2014 at 11:54 PM, Russell Jurney < >> [email protected]> wrote: >> >>> We're running Phoenix 2.2.2. >>> ᐧ >>> >>> >>> On Wed, Jun 25, 2014 at 8:31 PM, Alex Kamil <[email protected]> >>> wrote: >>> >>>> Russell, which version of Phoenix are you using on the server vs >>>> client? >>>> the most recent phoenix driver is >>>> *org.apache.phoenix.jdbc.PhoenixDriver * >>>> >>>> I see older salesforce driver in your log, could be mismatch between >>>> client and server phoenix versions >>>> DriverManager.registerDriver("*com.salesforce* >>>> .phoenix.jdbc.PhoenixDriver") >>>> >>>> >>>> On Wed, Jun 25, 2014 at 11:23 PM, Russell Jurney < >>>> [email protected]> wrote: >>>> >>>>> https://gist.github.com/rjurney/c30123ddb1dec87afd8e >>>>> >>>>> I can't get a connection via JDBC to Phoenix. It simply sits there >>>>> forever... >>>>> >>>>> -- >>>>> Russell Jurney twitter.com/rjurney [email protected] >>>>> datasyndrome.com >>>>> >>>> >>>> >>> >>> >>> -- >>> Russell Jurney twitter.com/rjurney [email protected] datasyndrome >>> .com >>> >> >> > > > -- > Russell Jurney twitter.com/rjurney [email protected] datasyndrome. > com > -- Thanks & Regards, Anil Gupta
