And the configuration files of your cluster are present in the classpath of your java client?
On Wed, Jun 25, 2014 at 11:26 PM, Russell Jurney <[email protected]> wrote: > 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 > -- Thanks & Regards, Anil Gupta
