I can connect to Phoenix from that machine using SqlLine, and also to HBase via 'hbase shell'. ᐧ
On Wed, Jun 25, 2014 at 11:23 PM, anil gupta <[email protected]> wrote: > 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 > -- Russell Jurney twitter.com/rjurney [email protected] datasyndrome.com
