What does your URL look like? It should be in the form: jdbc:phoenix [ :<zookeeper quorum> [ :<port number> ] [ :<root node> ] ]
e.g. jdbc:phoenix:zookeeper1:2181:/hbase-unsecure Since squirrel typically doesn't have access to hbase-site.xml, you need to specify port and root node if they are not the defaults. I believe the default port is 2181 and the default root node is /hbase. On Wed, Aug 13, 2014 at 4:22 AM, [email protected] < [email protected]> wrote: > Hi > Here is some exception information when I am trying to use squirrel sql > client to connect to phoenix. I have no idea why there is such timeout > exception. Anybody had ever encountered such problem? I strictly followed > the instructions as here: http://phoenix.apache.org/download.html > But when I press test and connect button , I got the timeout execption > while not being sure what the problem is. Hoping any available information > can help. > Best Regards.. > > 2014-08-13 16:00:38,978 [AWT-EventQueue-1] ERROR > net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack - > Unexpected Error occurred attempting to open an SQL connection. > java.util.concurrent.TimeoutException > at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) > at java.util.concurrent.FutureTask.get(Unknown Source) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > > at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > 2014-08-13 16:01:19,349 [AWT-EventQueue-1] ERROR > net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack - > Unexpected Error occurred attempting to open an SQL connection. > java.util.concurrent.TimeoutException > at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) > at java.util.concurrent.FutureTask.get(Unknown Source) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > > at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > 2014-08-13 16:13:33,532 [AWT-EventQueue-1] ERROR > net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack - > Unexpected Error occurred attempting to open an SQL connection. > java.util.concurrent.TimeoutException > at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) > at java.util.concurrent.FutureTask.get(Unknown Source) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > > at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > ------------------------------ > ------------------------------ > > CertusNet > > 赛特斯信息科技股份有限公司 > > > > 孙福林 > > Add: 江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼 > > Mobile: 15850710386 > Mail: [email protected] <[email protected]> > > Website: www.certusnet.com.cn >
